Creating a Data Model w/ dbt: Facts (Part 2/3)
Jul 09, 2025In last week's video, we walked through creating a Warehouse data modeling layer with dbt.
More specifically, we covered creating and configuring the Dimension tables.
But this week, we're now going to move to introducing the core Fact table into our model.
While Dimensions cover "context", the Fact table is all about capturing data points around a "business action".
It should be purposely designed around a real analytical need of the business - not just be created to store data for no reason.
So in this video, we'll cover key Fact table concepts like:
- Storing Metrics
- Connecting to Foreign Keys
- Putting it all together within the larger strategy
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.
