Projects

Things I'm building

Projects I document as I work on them: Power BI, Python, automation, and analytics. These double as my portfolio.

Featured advanced

Building the whole stack: seven messy sources to a live dashboard

Seven source systems into one live dashboard, built end to end

After owning the business logic of an enterprise footfall model, I built an entire analytics platform myself: synthetic data, medallion pipeline, star schema, and a React dashboard. With AI as the pair-builder and my judgement as the safety net.

  • Claude Code
  • Python
  • PostgreSQL
  • Star schema
  • React
5 Aug 2026
advanced

From one flat Odoo export to a POS dashboard that catches cash errors

~30K row flat export rebuilt into a 4-table star schema

A hierarchical Odoo POS export, nearly 30,000 rows deep, rebuilt into a four-table star schema and two dashboards. Including the measure that catches a cashier whose errors cancel out.

  • Power BI
  • DAX
  • Star schema
14 Jul 2026
advanced

Cutting a two-year cost variance from 48% to under 2%

Margin variance cut from 48% to under 2% after two years unsolved

A root cause analysis across a Medallion data platform. How I traced a long-standing cost gap to two hidden causes and worked with engineering to fix both.

  • SQL
  • Power BI
  • Azure Databricks
  • Medallion architecture
14 Jun 2025