dbt has become the de-facto standard for the transformation layer of the modern data stack.
DXP — DBT eXperience Program
From analyst to dbt lead in 36 weeks.
A blended dbt Core learning journey across three certification-aligned modules: Ignite, Apply, and Lead.
Build analytics engineers who know your warehouse, your data, and your standards.
Why dbt — and why a program?
dbt is the transformation standard. Analytics engineers are still hard to hire.
DXP closes the gap between SQL analyst and production-ready analytics engineer through cohort learning, real project work, certification alignment, and internal multiplication.
Analytics engineers fluent in SQL, Git, and modeling remain scarce on the open market.
A structured cohort reaches usable project output faster than self-study.
The DXP journey
36 weeks. Three modules. Twelve blocks.
DXP translates the proven BXP cohort model to dbt Core: blended learning, labs, self-paced work, real capstones, and certification-aligned progression.
Weeks 1-12
01 Ignite
Analyst to confident dbt practitioner.
- Foundations and quick start
- Modeling and materializations
- Trust through tests, freshness, and docs
- Ship an end-to-end dbt project
Weeks 13-24
02 Apply
Practitioner to certified Analytics Engineer.
- Jinja, macros, packages, hooks, and operations
- Dimensional modeling, snapshots, and SCD2
- CI/CD, slim CI, promotion, and orchestration
- Performance, observability, contracts, and SLAs
Weeks 25-36
03 Lead
Analytics Engineer to dbt lead and multiplier.
- dbt Mesh and multi-project architecture
- Governance, quality strategy, and project audits
- Internal packages, macro libraries, and scaffolding
- Architecture reviews, PR coaching, and cohort facilitation
Audience
Designed for the analyst becoming an engineer.
Entry
Analyst with SQL
- Comfortable writing SQL against a warehouse
- Basic Git literacy: clone and commit
- Owns reports or dashboards but ships transformations through tickets
- Curious about modeling, without formal dbt exposure
Exit
dbt Lead & Multiplier
- Designs dbt project architecture for a domain or organization
- Owns CI/CD, governance, contracts, and quality strategy
- Mentors analytics engineers and reviews PRs
- Runs internal cohorts as a certified DXP Multiplier
Outcomes
Every module ends with proof.
| Module | Certification | Proof of work |
|---|---|---|
| Ignite | dbt Fundamentals · dbt Labs | End-to-end dbt project shipped on a real dataset |
| Apply | dbt Analytics Engineering Certification · dbt Labs | Production-grade domain mart with CI/CD |
| Lead | DXP Multiplier · Ultratendency Academy | Design a dbt practice and deliver a workshop to the next cohort |
Next steps
Let's run your first DXP cohort.
Three short steps from this conversation to a running cohort.
Start now