dbt Transformation
Suite
Turn raw staging tables into tested, documented dbt marts: sources with freshness checks, staging models, two mart models with contracts, generic + singular tests, and generated docs — with a green `dbt build`.
What you'll learn
- —Declare sources with freshness + loaded_at checks
- —Build staging + mart models with contracts
- —Write singular tests for dedup, grain, and SCD overlap
- —Ship a green `dbt build` with generated docs
The 4 milestones
Each milestone is reviewed before you advance.
- 01
dbt project setup + sources
dbt project boots; sources.yml declares staging inputs.
- 02
Staging models + generic tests
Clean staging views with uniqueness/not-null coverage.
- 03
Mart models with contracts
Two marts with enforced contracts + singular tests.
- 04
Docs + green build + README
Generated docs, full green build log, portfolio README.
Reading & references
Build your portfolio & get certified
Want more projects like this? Join our Data Analyst Work Experience Program to complete 5+ guided industry projects, gain real experience, and earn an internship certificate.
Free dbt Transformation Suite portfolio project — with AI review
Build a real dbt transformation suite project for your data analyst portfolio in your own public GitHub repo — free brief, starter template, and milestone guides. When your code is ready, the Free pass gets every milestone reviewed against a fixed rubric (de dbt transformation suite walkthrough included) and issues a verifiable certificate on completion.
Is the dbt Transformation Suite project free?
The full project brief, milestone guides, and starter template are free to audit. The AI-powered review pass and verified certificate unlock at Free.
Can I add the dbt Transformation Suite project to my resume and GitHub?
Yes — that is the point. You build in your own public GitHub repo, every milestone is reviewed against a fixed rubric, and the certificate links to the repo employers can inspect. Only list what is visible in your repo.
How long does the dbt Transformation Suite project take?
Most students finish the 4 milestones in 2–4 weekends. Milestones unlock in order, and you can re-submit any milestone that needs work.
Rubric-reviewed · Plagiarism-checked · Verifiable certificate