Modeling +
Warehouse Build
Design a star schema for orders + subscriptions (grain statements, SCD Type II dims, partition/cluster keys with cost rationale) and implement it as commented DDL + dbt marts that run in a scratch schema.
What you'll learn
- —Write grain statements every table is judged against
- —Implement SCD Type II dims with validity windows
- —Choose partition/cluster keys with a cost rationale
- —Validate marts with grain + overlap + range checks
The 4 milestones
Each milestone is reviewed before you advance.
- 01
Source audit + grain statements
Profile sources; state the grain of every planned table.
- 02
Dimension DDL with SCD Type II
dim_customer with validity windows + overlap guard.
- 03
Fact tables + partitioning rationale
fact_orders + fact_subscription_events DDL with keys + cost note.
- 04
Validation suite + README
Grain/range/freshness checks green; 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 Modeling + Warehouse Build portfolio project — with AI review
Build a real modeling + warehouse build 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 modeling warehouse build walkthrough included) and issues a verifiable certificate on completion.
Is the Modeling + Warehouse Build 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 Modeling + Warehouse Build 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 Modeling + Warehouse Build 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