Product / data analyst. I work in SQL and Python, and I care most about the step most write-ups skip: turning a number into a decision someone can act on, and being able to say why the number is trustworthy.
Every repository below runs. Tests are green in CI, the numbers in each README were produced by the code in that repository, and each project ends with a recommendation rather than a metric.
| The decision it answers | Stack | |
|---|---|---|
| retail-analytics — live dashboard | Where should a wholesaler's win-back budget go? Not to the 1,556 largest lapsed accounts — to 352 smaller ones that ordered 7.7 times before going quiet. 1.07M invoice lines, warehouse to dashboard. | DuckDB · dbt · Evidence · GitHub Pages |
| ab-test-analysis | Should a mobile game move its progression gate from level 30 to 40? No — it costs 0.82 pp of 7-day retention (95% CI [−1.33, −0.31]). 90,189 players, statistics written by hand. | pandas · numpy · scipy |
| bank-marketing-ml | Which bank clients are worth a call? Targeting the top 28.5% earns €48,400 against €15,370 for calling everyone. Threshold from unit economics, not from a grid search. | scikit-learn · FastAPI · drift monitoring |
| macro-nowcast | Can euro-area inflation be nowcast from public ECB data without accidentally using the future? 16.3% better than a random walk, with an ablation proving the gain is not look-ahead. | requests · pandera · DuckDB · scikit-learn |
| news-topic-classifier | Which topic is this text, which words decided it, and when should the model decline to answer? 85.1% accuracy on the 67% of posts it accepts. | TF-IDF · logistic regression · Streamlit |
| analytical SQL | Ten queries that run rather than illustrate: cohort retention, funnels, sessionization, gaps-and-islands, as-of joins, data-quality gates. python sql/run.py --all checks every result against hand-counted expectations on a fixture warehouse. |
SQL · SQLite |
| algorithms-practice | 108 solved problems across 17 topics, plus an ml_and_data block that rebuilds what the projects rely on — ROC-AUC, Welford, PSI, bootstrap, k-means — from scratch. |
Python |
Five minutes: the retail dashboard, then the A/B walkthrough notebook — GitHub renders it with every chart and output already in place.
If you are looking for SQL specifically, start at
sql/ instead — ten
analytical queries and python sql/run.py --all, which builds the fixture warehouse in memory
on the standard library, so there is no database to install before reading them.