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 we have a human resources (HR) system; Stephen Jiang is a Sales Manager, managing 10 sales representatives in his team. The following screenshot shows the sample data: Today, Stephen … Continue reading Slowly Changing Dimension (SCD) in Power BI, Part 1, Introduction to SCD