Business IntelligenceTechnical

Business Intelligence What Is a Calculated Column? A calculated column is a column added to a BI data model table through a formula expression that is computed at data… Technical Business Intelligence What Is a Data Lake? A data lake is a centralised storage repository holding raw data in its native format — structured, semi-structured, and unstructured — at… Technical Business Intelligence What Is a Data Lakehouse? A data lakehouse is the architectural pattern that combines the storage flexibility and cost economics of a data lake with the ACID… Technical Business Intelligence What Is a Data Mart? A data mart is a subject-area-specific subset of a data warehouse — containing the data model, ETL, and BI-ready structures for one… Technical Business Intelligence What Is Data Modelling? Data modelling in a BI context is the design of the data structures — tables, relationships, hierarchies, and measures — that organise… Technical Business Intelligence What Is a Data Pipeline? A data pipeline is the automated, orchestrated sequence of steps that moves data from source systems through ingestion, transformation, and validation to… Technical Business Intelligence What Is Data Refresh Architecture? Data refresh architecture is the design of the schedules, triggers, dependencies, and data movement strategies that keep a BI environment's datasets current… Technical Business Intelligence What Is DAX? DAX — Data Analysis Expressions — is the formula language used in Power BI, Analysis Services Tabular, and Power Pivot to define… Technical Business Intelligence What Is a Dimension Table? A dimension table stores the descriptive attributes used to filter, group, and label the numeric measures in a fact table — accounts,… Technical Business Intelligence What Is Direct Query vs Import Mode? DirectQuery and Import mode are the two primary data connectivity options in Power BI — Import loads data into Power BI's in-memory… Technical Business Intelligence What Is ELT (Extract, Load, Transform)? ELT — Extract, Load, Transform — reverses the traditional ETL sequence by loading raw data into the target analytical environment first and… Technical Business Intelligence What Is a Fact Table? A fact table is the central table in a dimensional data model — storing the numeric measures of a business process at… Technical Business Intelligence What Is Incremental Refresh? Incremental refresh is the Power BI feature that partitions a large dataset by date and refreshes only the partitions containing new or… Technical Business Intelligence What Is a Measure? A measure is a numeric value that is aggregated across dimensions in a BI model — revenue, cost, headcount, margin. The distinction… Technical Business Intelligence What Is Power BI Premium Capacity? Power BI Premium Capacity is Microsoft's dedicated compute offering for Power BI — providing reserved processing resources, larger dataset size limits, more… Technical