Work
Showcase projects, rebuilt on public data.
Client work stays confidential. Each showcase rebuilds a problem we solve for clients on a public dataset, so every number can be checked against its source.
Projects
- RetailWhen the weekly report and the monthly report disagreeWeekly totals rolled into months misstate monthly figures on public card-spending data from 2022 to 2025. Why it happens, how large it gets, and how a shared date dimension removes it.Open the project
- EnergyOne year of electricity, 81 or 325 terawatt-hoursFinland's national consumption series switched from hourly to 15-minute values. Summed the obvious way, 2024 comes out four times too large. What goes wrong, on which days, and how the pipeline gets every daily total right.Open the project