Data & Analytics — Power Pages & Power BI

Streamlining primary care data collection with Microsoft Power Pages and Power BI

Replacing Excel-based data collection for 300 allied health clinicians with Power Pages and Power BI — saving time equivalent to productivity savings of €400,000 per year and enabling consistent area-wide analysis by Community Healthcare Network.

annual productivity saving: €400k
clinical users adopted in under 4 months: 300
allied health disciplines supported: 4

The challenge

Through Sláintecare, the HSE established Community Healthcare Networks as the foundational organisational units for delivering primary and community care. Some services collected data at network level, but approaches were not standardised, there was no consistent area-wide analysis network by network, and reporting data to the Business Intelligence Unit was inefficient.

Activity and waiting time data was collected through Excel workbooks completed by 300 clinicians across four allied health disciplines. The process was time consuming for clinical staff, error prone, and required managers to spend significant time correcting formulas and reconciling submissions. The effort invested returned very limited reporting value, while circulated spreadsheets were not appropriate for patient activity data of this sensitivity.

The Head of Primary Care for Dublin Midlands asked MedModus to work with the team to see how the process could be improved.

Our approach

Excel data collection was replaced with a purpose-built Microsoft Power Pages system, including submission tracking and manager approval workflows.

The data pipeline was automated using Python scripts for ingestion into SQL Server, alongside automated population of the existing Excel reporting templates teams still relied on. A data model was built for analysing demand, activity, waiting times and staffing across networks and disciplines.

Self-service Power BI Embedded reports were embedded in a custom portal developed by MedModus with improved security, in-built help desk ticketing and centralised control of report updates. They were designed and supported by a responsive analyst service for change requests and new views, with a training programme delivered to 300 users across the four allied health disciplines to support adoption from day one.

The solution

MedModus built a secure, easy-to-use Power Pages solution, delivered through a custom MedModus portal that brings together data collection, reporting and support in one place. Clinicians now enter data through structured forms with built-in validation, so submissions are complete and consistent from the start. The portal provides improved security, in-built help desk ticketing and centralised control of updates.

All responses flow into Dataverse, giving the HSE one governed, central source of truth instead of files scattered across teams. Power BI dashboards connect directly to this data, giving managers consistent, real-time visibility of activity and performance across the area, analysed network by network.

“MedModus streamlined a very manual process of data collection and aggregation for our Primary Care clinicians and managers. The new process saves significant time and has improved governance and information security. The resulting dashboard reports on demand, activity, access and staffing have provided significant improvement insights. Their structured roll out approach combined with very responsive managed service support ensured smooth implementation over a short time frame, across multiple disciplines for over 300 clinicians.”

Head of Primary Care, Dublin Midlands Health Region

Outcomes

What changed for the organisation once the platform was live.

100% adoption
by 300 clinical users in under four months
6 WTEs per day
of reporting time saved
~€400,000
productivity saving per year
Area-wide insight
with consistent analysis network by network
40+ changes
design requests delivered by the analyst team
Excel errors removed
along with manager formula corrections
Governed access
for sensitive patient activity data

Facing a similar challenge?

We will walk you through how this engagement was delivered and what the equivalent first phase would look like for your organisation.

More case studies