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.
Are you a small or 1-person data team?
I’ll work with you 1:1 to implement a simple, modern data architecture that fits your situation.
Over 8 weeks, we’ll audit your current setup, work through key architecture decisions, and leave you with a clear plan you can execute confidently, without costly mistakes or rework.
