Business IntelligenceTechnical

Business Intelligence What Is Query Folding? Query folding is the Power Query mechanism that translates M transformation steps into native source queries, such as SQL, so filtering and… Technical Business Intelligence What Is Row-Level Security? Row-level security (RLS) is a BI access control that filters which data rows a user can see based on identity, role or… Technical Business Intelligence What Is a Slowly Changing Dimension? A slowly changing dimension (SCD) is the design pattern for handling changes to dimension attributes over time, such as overwriting values (Type… Technical Business Intelligence What Is a Snowflake Schema? A snowflake schema is a dimensional model in which dimension tables are normalised into related sub-tables, reducing redundancy but adding joins and… Technical Business Intelligence What Is a Star Schema? A star schema is a dimensional data model in which a central fact table of numeric measures links directly to denormalised dimension… Technical Business Intelligence What Is Apache Airflow? Apache Airflow is an open-source workflow orchestration platform, originally created at Airbnb, in which data pipelines are written as Python-defined DAGs that… Technical Business Intelligence What Is Apache Spark in BI? Apache Spark in BI refers to using the open-source distributed processing engine on platforms such as Databricks, Microsoft Fabric or Synapse to… Technical Business Intelligence What Is Azure Synapse Analytics? Azure Synapse Analytics is Microsoft's analytics service combining dedicated and serverless SQL pools, Apache Spark and data integration pipelines for warehousing and… Technical 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