Executive Dashboard for a Healthcare Network

A private hospital group operating five facilities across Kenya had data scattered across separate systems — patient records in one, billing in another, HR in a third, and procurement in spreadsheets. Leadership had no consolidated view of performance. Board reports were assembled manually over several days, and by the time they were presented, the data was already weeks old.

We built a data warehouse that pulls from all existing systems through automated ETL pipelines, then designed role-based dashboards for executives, department heads, and facility managers. We partnered with a local healthcare consultancy who ensured the metrics and KPIs aligned with industry standards and regulatory requirements.

• Audited all data sources across five facilities
• Designed a central data warehouse with automated data pipelines
• Built role-based dashboards for executives, department heads, and finance
• Defined clinical and operational KPIs with healthcare domain experts
• Implemented automated board reporting with drill-down capability

The platform provides real-time dashboards showing patient volumes, bed occupancy, revenue by department, outstanding receivables, staff utilization, and procurement spend. Facility managers see their own performance against group benchmarks. The CEO has a single screen showing the health of all five facilities, with the ability to drill into any metric.