Design & Data Integration

Power BI Health Reports

Interactive Power BI reporting that put live health data in front of decision-makers on both desktop and mobile.

Power BI Health Reports — screenshot of the delivered system
Role
Report designer
Organization
Niagara Region — Public Health
Audience
Program leads & management
Stack
Power BI, SQL, Dataverse

The problem

Health program data sat across several systems. Answering a simple question meant requesting an extract and waiting, so decisions were made on whatever number was closest to hand.

What I did

Integrated the sources into one model, then designed the report around the questions people were actually asking — with drill-through for detail and a layout that holds up on a phone.

The outcome

Live access to health data on any device, multiple sources reconciled into intuitive visuals, and far fewer one-off extract requests.