Elvis: dbt + DuckDB Portfolio
Elvis takes free open data about the Las Vegas Valley, loads it into a DuckDB warehouse, models it with dbt, and serves it through a Streamlit app. Every number on every page is a dbt model queried live, so the whole thing runs on the same extract, load, model, test, and serve workflow a data team uses in production. I built it to learn analytics-engineering patterns by shipping them end to end: modular transformations, a test on every model, and dimensional modeling.
What it proves
Production analytics engineering, an extract, load, model, test, and serve pipeline run the way a data team runs it.
How it was built
Claude Code, analytics-engineering patterns, with dbt tests on every model.
What is real, and where I was learning
What is real: the pipeline runs, every model is tested, and the app is live. Where I was learning: this is portfolio work built to practice dbt patterns, not a system with production traffic behind it.