Business Intelligence

Business Intelligence What Is BI on Azure Architecture? BI on Azure architecture is the reference design of Microsoft Azure and Fabric services for enterprise BI, covering ingestion from cloud and… Technical Business Intelligence What Is BI Performance Optimisation? BI performance optimisation is the diagnosis and improvement of query, report and refresh speed through better data models, efficient DAX, aggregations, incremental… Technical Business Intelligence What Is BI Security Architecture? BI security architecture is the layered design of identity, access, data protection, network security and audit logging across a BI platform, including… Technical Business Intelligence What Is a Bridge Table? A bridge table resolves a many-to-many relationship between a fact or dimension and another dimension, such as cost centres mapped to several… Technical Business Intelligence What Is Change Data Capture (CDC)? Change data capture (CDC) is an integration technique that identifies and captures only rows inserted, updated or deleted in a source since… Technical Business Intelligence What Is Cloud BI vs On-Premise BI? Cloud BI vs on-premise BI compares BI delivered as managed cloud services with BI deployed on an organisation's own servers, weighing cost… Technical Business Intelligence What Is a Conformed Dimension? A conformed dimension is a dimension, such as date, entity, account or product, defined once and shared with the same keys, attributes… Technical 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