Portfolio Projects/dbt Transformation Suite
₹99data engineer · Core Skillbeginner · ~6 Hours

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`.

DatabasePostgreSQL / BigQuery sandbox
Toolchaindbt
Milestones4 Guided Stages
Recruiter OutputVerified GitHub Repo
View 4 Milestones
Full project workspace, live database credentials, AI mentor & verified certificate
Project Deliverables

What You Will Ship to GitHub

Hiring managers don't want to see another cookie-cutter Titanic or Iris tutorial. You will build a professional repository with modular scripts and executive business memos that demonstrate commercial analytical maturity.

github.com/your-username/de-dbt-transformation-suitePortfolio Structure
├── sql/
01_exploratory_profiling.sql // Schema audits, table volume, date ranges
02_revenue_trends.sql // Monthly GMV, order volume & AOV evolution
03_customer_concentration.sql // Pareto 80/20 distribution, repeat buyer cohorts
├── findings/
00_executive_summary.md // 3 core business takeaways for executive stakeholders
01_business_health.md // Detailed breakdown of margins, cancellations, and seasonality
03_customer_segments.md // Customer lifetime spend & cohort concentration
├── README.md // Professional project front-door with data schema diagram
Outcomes

What You Will Master

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
Curriculum

4 Guided Project Milestones

M1

dbt project setup + sources

dbt project boots; sources.yml declares staging inputs.

~30 mins
M2

Staging models + generic tests

Clean staging views with uniqueness/not-null coverage.

~90 mins
M3

Mart models with contracts

Core Milestone

Two marts with enforced contracts + singular tests.

~90 mins
M4

Docs + green build + README

Generated docs, full green build log, portfolio README.

~60 mins
Career Value

ATS Keywords & Resume Ready Bullets

Tools
dbtSQLGit/GitHub
Methods
Common Table Expressions (CTEs)Window FunctionsTime-Bucket AggregationsCohort AnalysisData Profiling & Auditing
Business Concepts
AOV (Average Order Value)Customer ConcentrationRepeat Purchase BehaviorCohort RetentionRevenue Health Metrics
Pre-Written Resume Bullet (Copy & Paste)

"Authored an end-to-end data analytics project on dbt Transformation Suite utilizing dbt, SQL, PostgreSQL / BigQuery sandbox — delivered production-grade queries, cohort distributions, and an executive stakeholder summary published as a portfolio GitHub repository."

Preparation

Reading & References

dbt suite brief
setup guide · Premium Access
dbt starter: sources.yml + mart skeleton
article · Premium Access
dbt suite rubric
markdown · Premium Access

Ready to build and ship dbt Transformation Suite?

Instant access to cloud database credentials, milestones, and starter queries.

Project Overview

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 ₹99 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 ₹99.

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

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.

Join Work Experience
Access
₹99