Portfolio Projects/Modeling + Warehouse Build
₹99data engineer · Core Skillintermediate · ~8 Hours

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.

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-modeling-warehouse-buildPortfolio 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

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
Curriculum

4 Guided Project Milestones

M1

Source audit + grain statements

Profile sources; state the grain of every planned table.

~30 mins
M2

Dimension DDL with SCD Type II

dim_customer with validity windows + overlap guard.

~90 mins
M3

Fact tables + partitioning rationale

Core Milestone

fact_orders + fact_subscription_events DDL with keys + cost note.

~90 mins
M4

Validation suite + README

Grain/range/freshness checks green; portfolio README.

~60 mins
Career Value

ATS Keywords & Resume Ready Bullets

Tools
SQLdbtGit/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 Modeling + Warehouse Build utilizing SQL, dbt, PostgreSQL / BigQuery sandbox — delivered production-grade queries, cohort distributions, and an executive stakeholder summary published as a portfolio GitHub repository."

Preparation

Reading & References

Modeling + warehouse brief
setup guide · Premium Access
Modeling starter: DDL + overlap-guard skeleton
article · Premium Access
Modeling + warehouse rubric
markdown · Premium Access
Dataset: w7-retail OLTP orders extract (CSV + Generator)
setup guide · Premium Access

Ready to build and ship Modeling + Warehouse Build?

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

Project Overview

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

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

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