Creating a Data Model w/ dbt: Facts (Part 2/3)

Jul 09, 2025

In 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 "1-Person Data Team" At Your Company?

Learn how we can help you design, build and scale a reliable, modern data architecture (without getting overwhelmed). Click the link below to schedule a free Discovery Call.

Schedule a Free Discovery Call