#79: 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.
When you're ready, here are 3 ways I can help you further:
1. The Modern Engineer Playbook (Online Course): Master the art of building modern data architectures. Get an end-to-end blueprint for building simple, structured & scalable data pipelines with modern tools.Â
2. The Playbook for dbt™ (Online Course): Learn to build, automate & scale dbt™ with confidence. Discover common strategies teams follow, avoid costly rookie mistakes & get actionable tips based on real-world experience, not a textbook.
3. Consulting Services:Â Request to work 1:1 with Michael Kahan to help you and your team implement a modern data architecture with a simple, scalable structure.