Business Intelligence

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 Report Bursting? Report bursting is the automated process of generating and distributing multiple report instances from a single template — splitting a group management… Business Business Intelligence What Is Report Certification? Report certification is the formal governance process by which a BI report is reviewed, validated, and officially endorsed as a trusted, authoritative… Business 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 Self-Service BI? Self-service BI is the capability that allows business users — finance analysts, department managers, planning teams — to create their own reports,… Business Business Intelligence What Is a Semantic Layer? A semantic layer is the business logic layer in a BI environment that translates raw database tables and technical data structures into… Business Business Intelligence What Is Single Source of Truth? Single source of truth (SSOT) is the principle that each piece of financial information has one authoritative, governed location from which all… Business 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 Business Intelligence What Is Storytelling with Data? Storytelling with data is the practice of presenting financial data in a way that communicates a clear, actionable message — using visual… Business Business Intelligence What Is Tableau? Tableau is a leading business intelligence and data visualisation platform known for its interactive visual analytics capability, flexible data connectivity, and strong… Business