#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.
Set Your New Data Stack Up for Success with a Free Strategy Call
You’ve modernized your data architecture - now let’s ensure it’s setup for long-term success.
In this Free 30-Minute Strategy Call, we’ll:
- Review your current setup and progress
- Identify potential gaps or risks
- Provide actionable next steps to optimize your process
Whether you’re managing this effort solo or with a small team, you’ll leave with a clear roadmap to confidently build a structured, scalable, and maintainable data architecture.
For best results, please provide as much detail as possible.