Data Modeling - How to Track History in a Data Warehouse (Slowly Changing Dimensions)

All my FREE resources: https://www.skool.com/moderndata/about Consulting Services: https://go.kahandatasolutions.com ----- Have you ever had a stakeholder ask to see historical changes to some data over time? Only realize you don’t have a good way to show that. This is a common scenario but also something data teams struggle with quite often. Fortunately, this is a known problem that can be solved by creating what’s known as a Slowly Changing Dimension in your data model. But actually implementing this type of table can be confusing if you don’t understand the options and trade-offs. So in this video, you’ll learn more about the two most common types of slowly changing dimensions, different columns you can add to help with tracking changes and personal advice for how to put it all together successfully. Enjoy. Timestamps: 0:00 - Intro 0:31 - What is a SCD 1:53 - High Level Visual 2:51 - Example Scenario 4:28 - Type 1 5:04 - Type 2 5:57 - Using Flags 9:06 - Surrogate Keys 11:51 - Handling Deletes Title & Tags: How to Track History in a Data Warehouse (Slowly Changing Dimensions) #kahandatasolutions #dataengineering #datamodelling