Loading...

Slowly Changing Dimension (SCD) in Power BI, Part 1, Introduction to SCD

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 more
BI Insight
BI Insight

Business Intelligence and Data Visualisation Articles

Share post:

Related posts

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...

1 day ago

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...

2 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy