How to Create a 3 Layer Data Model Pipeline
May 01, 2024A data warehouse acts as the main hub for most data teams, yet it often becomes a mess.
While there are many different strategies to handle this, in this video I want to share the approach I follow.
It's based around a simple 3-layered design to take raw source data into meaningful data marts ready for analytics.
The main things we'll cover include:
- A high level pipeline overview (source to analytics)
- A simple example of each layer (staging, warehouse & marts)
- The importance of data modeling, even on modern DBs
Enjoy!
THE SIMPLE STACK AUDIT
Get a 36-point second opinion on your data architecture.
For data leaders on small (or one-person) teams who make every data decision alone.
Know what you got right, what to fix & what to build next.
Schedule a 30-minute intro call to see if it's the right fit for you.
You'll pick a date/time on the next page once submitted.
