Business IntelligenceTechnical

Business Intelligence What Is Query Folding? Query folding is the Power BI mechanism by which Power Query (M) transformations are translated into native source-system queries — SQL for… Technical Business Intelligence What Is Row-Level Security? Row-level security (RLS) is the access control mechanism that restricts which rows of data a BI report user can see — based… Technical Business Intelligence What Is a Slowly Changing Dimension? A slowly changing dimension (SCD) is the design pattern for managing dimension attribute changes over time — preserving historical values for analytical… Technical Business Intelligence What Is a Snowflake Schema? A snowflake schema is the dimensional modelling pattern in which dimension tables are normalised into sub-dimensions — reducing storage redundancy at the… Technical Business Intelligence What Is a Star Schema? A star schema is the dimensional modelling pattern in which a central fact table containing numeric measures connects directly to a set… Technical