Business IntelligenceTechnical

Business Intelligence What Is a Calculated Column? A calculated column is a column added to a BI model table by a formula that is evaluated row by row at… Technical Business Intelligence What Is a Data Lake? A data lake is a large-scale repository, usually cloud object storage such as Amazon S3 or Azure Data Lake Storage, that holds… Technical Business Intelligence What Is a Data Lakehouse? A data lakehouse is an architecture that combines low-cost data lake storage with warehouse capabilities such as ACID transactions, schema enforcement, time… Technical Business Intelligence What Is a Data Mart? A data mart is a subject-specific analytical data store, such as a finance, sales or HR mart, that holds the dimensional model… Technical Business Intelligence What Is Data Modelling? Data modelling in BI is the design of tables, relationships, hierarchies and measures that organise source data into structures BI tools can… 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 schedules, triggers, dependencies, refresh methods and monitoring that keep BI datasets current, balancing freshness needs… 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 measures, calculated… Technical Business Intelligence What Is a Dimension Table? A dimension table stores the descriptive attributes, such as account, entity, cost centre, product and date, used to filter, group and label… Technical Business Intelligence What Is Direct Query vs Import Mode? Direct query vs import mode is the Power BI storage choice between Import, which loads data into the in-memory engine for fast,… Technical Business Intelligence What Is ELT (Extract, Load, Transform)? ELT (extract, load, transform) is the data integration pattern that loads raw source data into a target analytical platform first and transforms… Technical Business Intelligence What Is a Fact Table? A fact table is the central table of a dimensional model that stores numeric measures of a business process at a defined… Technical Business Intelligence What Is Incremental Refresh? Incremental refresh is the Power BI feature that partitions a large table by date and refreshes only recent or changed partitions instead… Technical Business Intelligence What Is a Measure? A measure is a numeric calculation in a BI model, such as revenue, margin or headcount, that is evaluated at query time… Technical Business Intelligence What Is Power BI Premium Capacity? Power BI Premium Capacity is Microsoft's dedicated-capacity licensing for Power BI that provides reserved compute, larger models, higher refresh limits, paginated reports… Technical