Business IntelligenceTechnical

Business Intelligence What Is Cross-Filtering in BI? Cross-filtering in BI is the interactive behaviour in which selecting a data point in one visual filters other visuals on the page,… Technical Business Intelligence What Is Data Orchestration? Data orchestration is the coordination of pipeline tasks such as ingestion, transformation, quality checks, model refresh and delivery, managing schedules, dependencies, retries,… Technical Business Intelligence What Is a Data Quality Framework for BI? A data quality framework for BI is the set of rules, checks, thresholds, ownership and monitoring applied across ingestion, transformation and reporting… Technical Business Intelligence What Is Data Vault Architecture? Data vault architecture is a data warehouse modelling method by Dan Linstedt that separates business keys into hubs, relationships into links and… Technical Business Intelligence What Is the DAX CALCULATE Function? The DAX CALCULATE function evaluates an expression in a modified filter context, adding, removing or overriding filters and performing context transition from… Technical Business Intelligence What Is DAX Filter Context vs Row Context? DAX filter context vs row context distinguishes filter context, the set of filters from visuals, slicers and CALCULATE that defines visible rows,… Technical Business Intelligence What Is DAX RELATED and RELATEDTABLE? DAX RELATED and RELATEDTABLE are functions that navigate model relationships: RELATED returns a value from the one side of a relationship into… Technical Business Intelligence What Is DAX Time Intelligence? DAX time intelligence is the set of DAX functions and patterns for time-relative calculations such as year-to-date, prior-year comparisons, rolling periods and… Technical Business Intelligence What Are DAX Variables? DAX variables, defined with VAR and returned with RETURN, store intermediate results within a single expression so they are evaluated once, improving… Technical Business Intelligence What Is dbt (Data Build Tool)? dbt (data build tool) is a SQL-based transformation framework, available as open-source dbt Core and managed dbt Cloud, that lets teams write,… Technical Business Intelligence What Is a Degenerate Dimension? A degenerate dimension is a dimension attribute stored directly in the fact table with no separate dimension table, typically a transaction identifier… Technical Business Intelligence What Is Drill-Through vs Drill-Down in BI? Drill-through vs drill-down in BI distinguishes drill-down, which moves to lower hierarchy levels within the same visual, such as year to quarter… Technical Business Intelligence What Is Google Looker Studio? Google Looker Studio, formerly Data Studio, is Google's free, browser-based visualisation and dashboard tool that connects to Google Sheets, BigQuery, Google Analytics… Technical Business Intelligence What Is Grain (Data Warehouse)? Grain (data warehouse) is the definition of exactly what one row in a fact table represents, such as one journal line per… Technical Business Intelligence What Is a Junk Dimension? A junk dimension groups several low-cardinality flags and indicators, such as status codes, yes-or-no flags and transaction types, from a fact table… Technical