Local Warehouse in a Box

Level: beginner · Time: 2-4 hours

Stack

postgres
docker
sql

Artifacts

docker-compose.yml
schema.sql
seed.sql
10_analyst_queries.sql
README.md

Ship requirements

Repo link
Demo or screenshots
Write-up (tradeoffs + what broke + fix)
2 resume bullets

## Outcome Ship a local Postgres “warehouse” with a clean schema, seeded data, and analyst-ready queries. ## Validation - Row counts per table - At least one business query (revenue by day, top products) ## Demo Day (2 minutes) - What I built - Biggest tradeoff - What broke - How I fixed it - What I’d do next