How to Track History in a Data Warehouse (Slowly Changing Dimensions)
Feb 14, 2025Have 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.
Leaders of Small & 1-Person Data Teams
Get A Second Opinion On Your Data Architecture
The Simple Stack Audit is a 36-point assessment of your current data process, a graded scorecard, and custom recommendations on what to fix. Based on 30+ implementations since 2020.
Start with a 30-minute intro call to see if it's the right fit for you.
