Data Analytics Portfolio, NZ

Luigine
Chan

Regulatory professional pivoting into data-driven governance and compliance analytics. Lawyer · Registered Nurse · Master's Graduate (IPU New Zealand) · Based in Palmerston North.

Python SQL pandas matplotlib SQLite Jupyter Git
health governance education income housing

Background

Law meets data. Nursing meets analytics.

I'm a lawyer, registered nurse, and data analyst based in Palmerston North, New Zealand. My career has spanned litigation, public procurement, city government, and clinical nursing, and I've seen firsthand where data-driven decision-making can transform governance.

After completing a Master's in Contemporary International Studies at IPU New Zealand, I pivoted into data analytics, not to abandon my regulatory background but to add a technical layer to it. Every project in this portfolio combines real NZ government data with the institutional knowledge that comes from working inside legal and health systems.

I am actively seeking data analyst, policy analyst, or compliance analytics roles in the NZ public sector or health sector.

⚖️
Philippine Bar · 2015 Litigation · City Attorney · Bids & Awards Committee (BAC)
🏥
Registered Nurse (BSN) Southwestern University, Cebu City · Clinical practice
🎓
Master's in Contemporary International Studies IPU New Zealand, Palmerston North · 2024–2025
📊
Google Data Analytics Certificate Coursera · In progress

Portfolio

Projects that caught my interest

I keep coming back to the same habit I picked up in years of legal practice: don't trust a claim until the evidence backs it up. Most of these projects put that habit to work on real government data, and the same pattern keeps showing up: Pacific and Māori communities are carrying a heavier load in health, housing, income, and education than the rest of the country. A couple of projects wander further out, chasing questions I couldn't let go of, like whether a growing economy actually makes people happier. Different topics, same instinct: check the source before you believe the story it's telling.
↗
01 · Health
NZ Health Waitlist Analysis
A decade of Te Whatu Ora FSA waitlist data (44,735 rows) analysed by region, specialty, and ethnicity. Covers 2015–2025.
Pacific patients wait at 45.9% vs European at 34.2%, an 11.7 percentage point equity gap.
Python pandas matplotlib Jupyter
↗
02 · Governance
NZ Government Procurement Transparency
$14.9 billion in MBIE GETS contract data (2019–2025) analysed for supplier concentration and competition rates.
Fulton Hogan appears under 4 name variants, a combined 108 contracts that mask true market concentration.
Python SQL SQLite pandas
↗
03 · Income & Housing
NZ Census Income & Housing Inequality
2023 Census data combining median personal income and housing tenure rates by ethnicity across New Zealand.
Pacific Peoples: $35,200 income, 30.1% home ownership, vs European $42,700 and 59.3%.
Python pandas Stats NZ matplotlib
↗
04 · Education
NZ Education Inequality Analysis
Highest qualification by ethnicity from the 2013, 2018, and 2023 Censuses, tracking whether education gaps are closing.
22% of Pacific Peoples hold no qualification vs 9.3% of Asian communities. The gap is not closing.
Python pandas matplotlib Census 2023
↗
05 · Migration
NZ Migration: The Post-COVID Surge & Correction
Stats NZ Infoshare migration data (2004–2025) analysed by visa type, tracking the COVID collapse, the 2023 surge, and the rapid correction.
Work visa arrivals hit 180,878 in 2023, nearly double the pre-COVID high, before falling 50% in a single year.
Python pandas matplotlib Stats NZ
↗
06 · Happiness
Does Economic Condition Predict Happiness? A Cross-Country Analysis
Merged the World Happiness Report with a global poverty & inequality dataset across 39 countries (2015–2023) to test whether GDP, poverty, and inequality actually predict happiness, including a data quality audit that caught a synthetic dataset before trusting it.
GDP per capita predicts happiness (r = 0.84, p < 0.001) even after controlling for inequality and poverty rate, but a built-in audit found the poverty data itself was synthetic, not official statistics.
Python pandas statsmodels seaborn
↗
07 · Sports
Which Nationalities Race Fastest in Ironman Triathlons?
Over 800,000 Ironman 140.6 finisher records (2002–2024) analysed by nationality, with every split time converted to a percentile within its own race to control for course and weather differences.
Belgium ranks top 3 in swim, bike, and run for both men and women. Getting there meant resolving close to 600 inconsistent entries in the nationality field first.
Python pandas matplotlib Kaggle

Toolkit

Skills & tools

Languages
  • Python 3
  • SQL (SQLite)
  • R (basic)
  • HTML / CSS
Libraries
  • pandas
  • matplotlib
  • numpy
  • openpyxl
Tools
  • Jupyter Notebook
  • VS Code
  • Git / GitHub
  • Power BI (basic)
Domain
  • Health data analysis
  • Procurement analytics
  • Regulatory compliance
  • Policy analysis
Data Sources
  • Te Whatu Ora (ESPI)
  • MBIE GETS
  • Stats NZ Census
  • data.govt.nz
Professional
  • Legal research
  • Feature writing
  • Stakeholder reporting
  • BAC / Procurement law