Creating a Data Model w/ dbt: Tests (Part 3/3)
Jul 16, 2025Over the last two weeks, we've walked through how to create a foundational star schema data model using a tool like dbt.
We covered how to create Dimensions and Facts to make up the core model.
But creating the tables alone is just the first step.
Because as we know...data and custom logic is rarely ever 100% perfect.
Which is why having processes to test the quality of the data is incredibly important as well.
Fortunately, dbt provides some great built-in functionality to help address this scenario with just a few simple configurations.
And without needing to overcomplicate things early on.
So in the last video of this 3-part mini series, you'll see how to put a bow around the initial data model by adding some baseline data quality tests.
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.
