The process of collecting and summarizing data from multiple sources or rows into a single value, such as calculating sums, averages, or counts. Essential for creating high-level insights from detailed data.
A business intelligence process designed to answer specific business questions by querying data on the fly, rather than using pre-built reports or dashboards.
Technologies, applications, and practices for collecting, integrating, analyzing, and presenting business information to support better decision-making.
A visualization type that uses rectangular bars of varying lengths to compare categories or show trends over time. Commonly used in business dashboards for easy data comparison.
A type of behavioral analytics that groups users into related sets (cohorts) to analyze patterns across their lifecycles, often used to track user retention and behavior changes over time.
A temporary named result set that you can reference within a SELECT, INSERT, UPDATE, DELETE, or MERGE statement in SQL. Helps improve code readability and maintenance.
A visual display of the most important information needed to achieve objectives, consolidated and arranged on a single screen for easy monitoring.
A central repository of integrated data from multiple sources, designed for query and analysis rather than transaction processing.
The process of converting data from one format or structure into another, typically to make it more appropriate for analysis or visualization.
A table in a star schema or snowflake schema containing descriptive attributes used for filtering and grouping data in business intelligence applications.
A three-phase process that extracts data from various sources, transforms it to fit operational needs, and loads it into the end target database or data warehouse.
A variant of ETL where data is loaded into the target system before transformation, taking advantage of modern cloud data warehouse processing capabilities.
A primary table in a dimensional model that contains business metrics, measures, and facts, typically containing foreign keys to dimension tables.
A condition applied to data to limit the records shown based on specific criteria, helping users focus on relevant information.
A visualization that displays the distribution of continuous data, showing the frequency of values within specific ranges or bins.
A SQL operation that combines rows from two or more tables based on related columns, essential for connecting data from different sources.
A measurable value that demonstrates how effectively a company is achieving key business objectives. Common in dashboards and executive reports.
A numeric value that can be aggregated, such as sum, average, count, or other mathematical calculations of raw data.
A quantifiable measurement used to track and assess the status of a specific business process or activity.
A technology that enables users to analyze multidimensional data interactively from multiple perspectives, facilitating complex calculations and trend analyses.
A data summarization tool that automatically sorts, counts, totals, or averages data stored in a database or spreadsheet, creating a second table showing the summarized data.
A request for data or information from a database, typically written in SQL, used to retrieve and manipulate data for analysis.
The capability to analyze and visualize data as soon as it becomes available, enabling immediate insight and action.
A security feature that controls access to data at the row level, ensuring users can only see data they're authorized to view.
A standardized programming language used to manage relational databases and perform various operations on the data in them.
A database organization method that uses a central fact table connected to multiple dimension tables, optimized for querying large datasets.
A method of analyzing data points collected over time to identify trends, cycles, and seasonal patterns in business metrics.
The graphical representation of data using charts, graphs, and other visual elements to make complex information more understandable and actionable.
SQL functions that perform calculations across a set of table rows related to the current row, allowing complex analytical queries and rankings.
