PORTFOLIO
Sample Projects &
Case Studies
The following projects showcase the type of healthcare data solutions I build. These are demonstration projects created using simulated datasets — representative of real healthcare scenarios and reporting needs.
AGED CARE · DASHBOARD
Patient Flow & Admission Dashboard
An interactive Power BI dashboard tracking monthly admissions, discharges, average length of stay, bed occupancy rates, and seasonal trends for an aged care facility with 80 residents.
Power BI
DAX
Excel Source
DISABILITY SUPPORT · ROSTERING
Staff Rostering & Hours Tracker
An advanced Excel workbook automating staff scheduling across a disability support team, tracking hours, overtime, leave balances, and generating weekly cost summaries for management with a single click.
Advanced Excel
Power Query
Pivot Tables
PRIMARY CARE · COMPLIANCE
Compliance & Quality KPI Dashboard
A Power BI dashboard tracking compliance scores, open incident statuses, audit pass rates, and client satisfaction scores — designed for monthly management reporting and accreditation preparation in NZ.
Power BI
DAX
SQL Feed
AGED CARE · RESOURCE MANAGEMENT
Bed Utilisation & Resource Report
A SQL-driven report combined with an Excel dashboard tracking bed occupancy rates by care type, site-by-site utilisation, and capacity planning trends across multiple aged care locations.