Power BIPostgres
Rent Affordability Radar
Tracks NZ rental stress: Postgres aggregation → embedded Power BI with latest-month KPIs and area comparison.
View →- Design star/snowflake models; create robust, reusable SQL.
- Build KPI dashboards with drill-through and row-level security.
- Partner with stakeholders; ship business outcomes.
Featured Projects
SQLPower BI
Retail Sales Optimization
End-to-end pipeline: schema design, windowed cohort metrics, and a one-page Power BI to cut stockouts.
SQLTableau
NZ Transport Demand
Public transport trips + weather joined in SQL; Tableau story points highlight peak loads.
SQL
ETF Signals (SQL-only)
All in SQL: common table expressions generate rolling signals for GLDM/TLT backtests.
About
SQL-heavy analyst with experience across finance and operations. I enjoy translating messy business questions into clear metrics and simple dashboards. Based in Auckland, open to remote.