OpenSky | Unified Hospital Operations

Integrated Data. Unified View.

Meditech EHR data was integrated with financial and HR systems — including Sage and Workday — providing a single, consolidated view of operational and financial performance for the first time.

Real-Time Operational Insights

Clinicians, managers, and executives gained access to real-time and near-real-time dashboards covering patient flow, theatre utilisation, and admissions management — replacing static, delayed reports.

Self-Sufficient Reporting Teams

Comprehensive training and knowledge transfer equipped hospital staff to independently build, manage, and extend their own Power BI reports and dashboards from day one.

This client is one of Ireland's largest and most established private hospital networks, operating multiple acute hospital sites across the country. With a broad portfolio of clinical services spanning surgical, medical, and specialist care, the organisation serves hundreds of thousands of patients annually.

As part of a significant investment in digital transformation, the network undertook the nationwide rollout of a new Meditech Electronic Health Record system — a programme requiring robust, real-time data infrastructure to support both clinical operations and executive oversight.

The Situation

The organisation's existing reporting capabilities were largely dependent on Meditech's standard out-of-the-box reporting tools. While functional at a basic level, these tools were insufficient to meet the operational reporting demands of a live, multi-site EHR environment — particularly for ad hoc and self-service analytics.

The complexity of the technical landscape added to the challenge. Meditech data resided in SQL Server databases hosted in Google Cloud, and the organisation was also in the process of transitioning from a centralised US-based Microsoft Entra ID tenancy to an Irish tenancy — introducing additional authentication and access considerations that needed to be factored into any new solution.

Unified Healthcare Data & Reporting Platform

Built on Microsoft Fabric and Power BI, the platform unified operational and clinical reporting across multiple hospital systems. Operational data from Meditech Expanse and PIMS was ingested through automated Fabric Data Factory pipelines into a Fabric Lakehouse, and surfaced through Power BI dashboards, paginated reports, and Excel-connected semantic models. Reusable semantic models ensure KPI definitions and metric logic are consistent across all reporting surfaces.

The programme was structured across five delivery phases: (1) MVP delivery of high-priority dashboards; (2) Structured discovery and backlog development; (3) Iterative enhancement aligned to Meditech Expanse go-live milestones; (4) Multi-site rollout and stabilisation; and (5) Advanced reporting, knowledge transfer, and ongoing support.

Governance was embedded throughout - formal change control, user acceptance testing, and stakeholder sign-off were required at every stage.

Key Functionality & Features

Theatre Activity Dashboard - theatre utilisation, session efficiency, consultant activity, procedure volumes, delays, cancellations, overruns, and turnaround time across hospital sites
Admissions Dashboard - inpatient and day-case admissions, patient flow, occupancy, specialty mix, ward and department activity, and throughput trends
Revenue Cycle Dashboard - billed and unbilled debt, bill age, claim category, insurance company performance, specialty and service line revenue, and financial trends
Bed Utilisation Report - bed stays, admissions, utilisation percentages, hospital capacity, and year-on-year comparisons
Executive KPI and Organisational Performance Dashboards - cross-hospital performance trends, organisational metrics, and executive summary views
Compliance-ready architecture aligned to GDPR, NIS2, and HIQA standards

For the First Time, Leadership Had the Full Picture.

The most critical digital transformation in the hospital network's recent history - a nationwide EHR rollout across multiple sites - completed without a single reporting gap. But the impact went well beyond go-live readiness. Executives and operational leaders gained something they had never had before: a single, real-time view of clinical, financial, and workforce performance, across every site, at once.

No blind spots at go-live. Hospital leadership entered each go-live with complete operational visibility -- not managing in the dark during the moments that mattered most.

Board-level clarity on operational performance. For the first time, patient flow, theatre utilisation, and admissions data was available in real time, not as end-of-week summaries. Senior leaders moved from reactive reporting to proactive management - identifying pressure points and resourcing issues before they escalated.

Clinical activity connected to financial outcomes. Integrating Meditech EHR data with Sage financial and Workday workforce systems revealed correlations that had previously been invisible: the relationship between theatre scheduling efficiency, staffing levels, and financial performance. This gave the executive team a genuinely unified basis for resource and investment decisions.

An organisation that owns its data. Through structured training and a deliberate knowledge transfer programme, the hospital's own staff are now able to build, publish, and manage their analytics independently -- without relying on external vendors or specialist IT. The C-suite no longer waits for reports; their teams produce them.

A platform that scales with strategic ambition. The Architecture, Microsoft Purview readiness, and Entra ID migration compatibility mean this is not a static reporting tool -- it is a governed data foundation designed to grow. As the network expands its digital health capabilities, the platform is already positioned to incorporate AI-driven insights, predictive analytics, and new data sources without architectural rework.