Analytics Engineering with dbt: Model Data the Way Software Ships
Instructor: Cognosco Learning · Duration: Full Day, 9:00 AM–5:00 PM · In-Person
One-day, in-person course — $795 per person · 3–4 seats save 10% · 5+ seats save 20%


About This Course
Model warehouse data the way software ships: declare sources under contract, build the staging, intermediate, and mart layers at declared grains, write tests and documentation as the project's two contracts, ship through environments, an integration gate, and freshness checks that fail loudly — and define every metric once, in the semantic layer.
What You'll Learn
What you will learn
- Hold the analytics-engineering seat: state what the discipline owns, what it refuses, and how its work differs from pipeline engineering and warehouse operation.
- Take raw sources in under a contract: declare them, name what you rely on, and absorb upstream change without silent breakage.
- Build the three modeling layers — staging, intermediate, marts — each with one job, and keep business logic in exactly one layer.
- Design models a team can run: one declared grain per model, conventions for naming and structure, and joins that cannot silently multiply rows.
- Write tests as contracts — uniqueness, referential integrity, accepted values, and custom checks — placed where each failure is cheapest to catch.
- Document a project so a stranger can answer what a model is, who owns it, how fresh it is, and whether to trust it, without asking its author.
- Work in version control the way software ships: branches, reviewed changes, and a history that explains itself.
- Separate development from production with environments, and promote changes along a path that never lets an experiment overwrite the numbers the business runs on.
- Run continuous integration for data: build and test the change and what it touches before it merges, at a cost the team can sustain.
- Deploy on purpose: scheduled jobs, model selection, and freshness checks that fail loudly when data stops arriving.
- Read lineage to answer the only two questions that matter in a crisis — what feeds this, and what breaks if this changes — before you change it.
- Declare exposures and ownership, so every important downstream use is known, named, and has a person answerable for the model behind it.
- Define metrics once, in a semantic layer, so revenue and margin mean the same thing in every report, dashboard, and answer.
- Refactor a growing project safely, respond to data incidents without guessing, and hold the standard when deadline pressure argues for skipping it.
What's Included
- A full day of in-person learning — 9:00 AM–5:00 PM, seven learning hours — led by a Cognosco Learning instructor
- A printed participant manual for every attendee
- All course materials, exercises, and practice scenarios
- Guided practice and small-group work throughout the day
- Group savings built in: 3–4 seats save 10%, 5+ seats save 20%
How the Day Runs
9:00 AM – 5:00 PM
A full day in the room — seven learning hours — led by a Cognosco Learning instructor.
Practice, not lectures
Guided practice and small-group work throughout the day, with all course materials, exercises, and practice scenarios provided.
Take it with you
A printed participant manual for every attendee — yours to keep, and to keep working from after the day.
Who It's For
Individuals who want to work, and live, with more focus, resilience, and intention.
Your session’s location, date, and start time are set by Cognosco and confirmed with you after registration — the scheduling is handled for you.
Looking to bring learning to a whole team? See corporate learning →
Enroll in This Course
In-person · Full day · Taught by Cognosco Learning instructors
Add 2 more seats to save 10%.
No account required · Secure checkout
What happens next
- Choose your seats and enroll — no account required.
- Cognosco sets your session location, date, and start time, and confirms them with you.
- Check out securely; your confirmation is sent immediately.
Prefer to learn at your own pace?
Analytics Engineering with dbt: Model Data the Way Software Ships is also a Signature AI Socratic Coaching Course — the same material, taught one learner at a time by the Lighthouse Coach, whenever it suits you. Introductory price $195.
Finish the AI course and you earn a completion certificate that anyone can verify online.
Before You Enroll
What's included in a course day?
A full day of in-person learning — 9:00 AM–5:00 PM, seven learning hours — led by a Cognosco Learning instructor, a printed participant manual for every attendee, and all course materials and exercises. One flat rate per person — no proposal required.
How are the location, date, and start time set?
They are set by Cognosco. When you register, we confirm your session’s location, date, and start time with you directly — you don’t need to propose or hold dates on your own.
How do the group savings work?
Automatically, at registration: 3–4 seats save 10%, and 5 or more seats save 20% off the $795 per-person rate. The discount is applied in the seat selector before you check out — no code, no negotiation.
Can we bring learning to a large group or a whole department?
Yes. Online registration handles up to 50 seats per course. For a larger group, a multi-course plan, or sessions across several locations, email us at hello@cognoscolearning.com and we’ll plan it with you.
What if we need to change our date?
Email us at hello@cognoscolearning.com as soon as you know — we’ll work with you to move your session to a date that works.