Business IntelligenceTechnical

Business Intelligence What Is Cross-Filtering in BI? Cross-filtering in BI is the behaviour where selecting a data point in one visual automatically filters all other visuals on the same… Technical Business Intelligence What Is Data Orchestration? Data orchestration is the coordination and sequencing of data pipeline tasks — ingestion, transformation, quality checks, and delivery — across a multi-step… Technical Business Intelligence What Is a Data Quality Framework for BI? A BI data quality framework is the structured set of rules, checks, processes, and governance controls that ensure data loaded into and… Technical Business Intelligence What Is Data Vault Architecture? Data Vault is a data modelling methodology and architecture for enterprise data warehouses that separates business keys (hubs), relationships (links), and descriptive… Technical Business Intelligence What Is the DAX CALCULATE Function? The DAX CALCULATE function is the most powerful and most frequently used function in the DAX language — it evaluates an expression… Technical Business Intelligence What Is DAX Filter Context vs Row Context? Filter context and row context are the two evaluation contexts in DAX — filter context defines which rows of a table are… Technical Business Intelligence What Is DAX RELATED and RELATEDTABLE? RELATED and RELATEDTABLE are DAX functions for navigating relationships between tables — RELATED retrieves a single value from a related table's column… Technical Business Intelligence What Is DAX Time Intelligence? DAX Time Intelligence is a set of DAX functions in Power BI and Analysis Services that enable calculations relative to time —… Technical Business Intelligence What Are DAX Variables? DAX Variables — introduced through the VAR and RETURN keywords — allow intermediate values to be stored and reused within a single… Technical Business Intelligence What Is dbt (Data Build Tool)? dbt (data build tool) is an open-source SQL-based transformation framework that enables data analysts and engineers to write, test, version-control, and document… Technical Business Intelligence What Is a Degenerate Dimension? A degenerate dimension is a dimension attribute that lives in the fact table itself rather than in a separate dimension table —… Technical Business Intelligence What Is Drill-Through vs Drill-Down in BI? Drill-down and drill-through are two distinct navigation paradigms in BI reports — drill-down descends through a hierarchy within the same visual (from… Technical Business Intelligence What Is Google Looker Studio? Google Looker Studio (formerly Data Studio) is Google's free, cloud-based data visualisation and reporting tool that connects to Google products (Sheets, BigQuery,… Technical Business Intelligence What Is Grain (Data Warehouse)? Grain is the definition of what a single row in a fact table represents — the most atomic level of detail stored… Technical Business Intelligence What Is a Junk Dimension? A junk dimension is a data warehouse design technique that consolidates multiple low-cardinality flag and indicator columns from a fact table —… Technical