Loading…
Build something you can explain, validate, and show. Professional projects appear first; narrative challenges remain available in the full catalog.
10 projects
Event and performance analytics modeling project
A beginner data-modeling exercise: build a simple star schema — player and team dimensions plus a performances fact — and give every column the right data type.
E-commerce orders, inventory, and revenue modeling project
End-to-end e-commerce modeling project: orders, line items, products, customers, and inventory — built into a star schema with revenue and inventory marts.
Scientific-records database design with hierarchical entities
Public-health operations database with case-tracking and resource allocation
Marine-research database design with sensor and survey data
ETL vs ELT pipeline design exercise with a real source-to-warehouse flow
Multi-source ingestion design: APIs, files, and warehouses
Sensor-data analytics and modeling for an IoT-style smart-city dataset
Metric-layer recovery and analytics debugging project (dbt + BigQuery)
A capstone-style portfolio project: recover and rebuild a broken metric layer in a dbt project against BigQuery — diagnose, model, test, and document.
Extended dbt + BigQuery capstone with CI, docs, and exposures
