-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Expert Data Modeling with Power BI
By :

The term slowly changing dimension, which we usually refer to with its short form, SCD, is a data warehousing concept introduced by the amazing Ralph Kimball. You can learn more about Ralph Kimball here: https://www.kimballgroup.com/about-kimball-group/.
The SCD concept deals with moving a specific set of data from one state to another. Imagine we have a human resources (HR) system; Stephen Jiang
is a Sales Manager
, having 10 sales representatives in his team. The following screenshot shows the sample data for our scenario:
Figure 12.1 – Stephen Jiang is the sales manager of a team of 10 sales representatives
Today, Stephen Jiang
has been promoted to Vice President of Sales
, so his team grows in size from 10 to 17. The following screenshot shows the changes:
Figure 12.2 – Stephen's team after he was promoted to Vice President of Sales
Another example is when a customer's address changes in...