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

Diagnosing Power BI DirectQuery Performance Problems Caused By SQL Queries That Return Large Resultsets

One very common cause of Power BI performance problems is having a table with a large number of rows on your report. It’s a problem I wr...

16 hours ago

Diagnosing Power BI DirectQuery Connection Limit Problems With Performance Analyzer

To kick off my series on diagnosing Power BI performance problems with Performance Analyzer in the browser (which I introduced last week with ...

7 days ago

Visualising Power BI Performance Analyzer Data With A Vibe-Coded Custom Visual

Performance Analyzer is now available in the browser, not just in Power BI Desktop! Actually everyone got excited about this back in September...

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