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: End of support for on-prem SharePoint web part
Support for the SSRS Report Viewer SharePoint Webpart ends April 13, 2026. It will remain functional but unsupported. Organizations should tra...
Measuring Geocoding Performance In Power BI Map Visuals Using Performance Analyzer
When a user complains about their Power BI report being slow it’s normal for the developer to open up DAX Studio and start tuning the me...
The Power BI Dataviz World Champs is back!
Join the Power BI Dataviz World Championships – three rounds of visualization challenges, community voting, and a live finale at FabCon ...
Power BI Report metadata defaults to Power BI Enhanced Report format (PBIR)
Starting January 25, 2026, Power BI reports will default to the Enhanced Report format (PBIR), improving source control and collaboration. Exi...
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...