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

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.