Portfolio-ready problems with real data.
Each project is a self-contained scenario — finish in an afternoon, push it to your Github, talk about it in an interview.
Multi-step SQL investigations against realistic datasets.
SQL Alien Invasion Challenge: Defend Earth
Time-series SQL analysis on a crisis-response dataset
An advanced SQL challenge framed as a crisis-response analysis. Uses joins, window functions, and time-series aggregation against realistic event data.
advanced · open →SQL Mystery Challenge: The Case of the Vanishing Artifacts
Investigative SQL analysis over an inventory and audit-log dataset
A multi-step SQL investigation: follow the evidence across an inventory, transaction log, and personnel dataset to find the missing items.
intermediate · open →SQL Survival Challenge: Last City on Earth
Operations and supply-chain SQL analysis with prioritization logic
Operations-flavored SQL project: triage limited supply against demand with priority scoring, conditional aggregation, and ranked outputs.
intermediate · open →SQL Exercise: The Volcano Eruption Emergency
Emergency-operations SQL analysis with geospatial-style prioritization
Emergency-response themed SQL exercise: identify affected populations, prioritize evacuations, and aggregate resources against a multi-table dataset.
intermediate · open →
Design exercises — turn a brief into a normalized schema.
Data Modeling: The Great Dimension Quest
Dimensional-modeling exercise: build a star schema from a relational source
Hands-on data modeling exercise: take a normalized OLTP-style source and design a star schema with conformed dimensions and a fact table.
intermediate · open →Data Modeling: Pizza Planet Party
Restaurant-ops data modeling: orders, inventory, and shifts
intermediate · open →Ocean Adventure: Deep Sea Data Modeling
Marine-research database design with sensor and survey data
intermediate · open →Data Forge: The Lost Metrics
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.
intermediate · open →Data Forge: The Lost Metrics - Premium
Extended dbt + BigQuery capstone with CI, docs, and exposures
advanced · open →
Ingest, transform, and load patterns you'd ship in production.
Cross-discipline projects that don't fit one bucket.
Zombie Virus - Part 1: Stopping the Release
Data-quality SQL forensics on transactional pipelines
advanced · open →Zombie Virus - Part 2: Aftermath of the Virus Release
Incident-response analytics with rolling aggregates
advanced · open →Zombie Virus - Phase 3: The Cure
Cohort analytics and A/B-style effectiveness modeling
advanced · open →Skyland Dragon Riders
Event and roster data modeling for a multi-entity sports-style domain
intermediate · open →Champion Fantasy League
Event and performance analytics modeling project
Model an event-and-performance dataset for a fantasy sports product: players, matches, scoring rules, league standings, and weekly performance facts.
intermediate · open →Sports Equipment Pro Shop
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.
intermediate · open →Cosmic Observatory Database
Scientific-records database design with hierarchical entities
intermediate · open →Monster Hunter’s Guild: Bestiary Database Design
Catalog and classification database design with many-to-many relations
intermediate · open →Archaeological Expedition Database: Ancient Discoveries
Field-research database design with provenance tracking
intermediate · open →Global Pandemic Response Center: Emergency Database Design
Public-health operations database with case-tracking and resource allocation
intermediate · open →EcoSphere: Sustainable Smart City Data Lab
Sensor-data analytics and modeling for an IoT-style smart-city dataset
intermediate · open →