Independent analysis · public data
Projects Dashboard.
Six independent analyses of real public datasets, each built around a question a hiring manager in that industry would ask. Each one is worked end to end with SQL and Python, and you can query the data live in your browser below.
All data is public and cited; nothing here is client or employer data.
Case studies
Six questions, worked end to end.
Live SQL
Query the data yourself.
Runs DuckDB in your browser; nothing is sent to a server. Pick a table or a sample query to get started, or write your own.
Tables
Sample queries
Methods
How this was built.
Stack
Each case is prepared offline with Python and DuckDB, then published as a small chart-ready JSON file plus a trimmed Parquet file for the live console. The page itself is one static HTML file: Observable Plot and D3 draw the charts, and DuckDB-WASM runs full SQL queries against the Parquet files directly in your browser, with no server involved.
Every chart is built from a tidy, pre-aggregated table so it stays small and fast; the underlying row-level Parquet file is what powers the Live SQL console above. No analytics, no cookies, nothing saved to your browser.
Sources & licenses
Loading source list…