Slowly Changing Dimension (SCD) in Power BI, Part 1, Introduction to SCD
Slowly changing dimension (SCD) is a data warehousing concept coined by the amazing Ralph Kimball. The SCD concept deals with moving a specific set of data from one state to another. Imagine a human resources (HR) system having an Employee table. As the following image shows, Stephen Jiang is a Sales Manager having ten sales representatives in his team: Today, Stephen … Continue reading Slowly Changing Dimension (SCD) in Power BI, Part 1, Introduction to SCD
The post Slowly Changing Dimension (SCD) in Power BI, Part 1, Introduction to SCD appeared first on BI Insight.
Published on:
Learn moreRelated posts
Power BI Demo - Full Semantic Model with TMDL?!?
Power BI Update - April 2025
Dynamic Pareto analysis in Power BI
Image Slicer in Power BI
Deep dive into Direct Lake on OneLake and creating Direct Lake semantic models in Power BI Desktop
Microsoft Fabric’s OneLake data can be visualized and analyzed in Power BI without moving any data using the new Direct Lake storage mode. . P...
Memory Overhead Of Distinct Count Measures In Power BI
The series of blog posts I wrote last year on semantic model memory usage, in particular this post on the query memory limit and the “This que...