Scorecard for national healthcare performance

data

Objective

An international health organization wanted a tool to track Health KPIs for countries. Each country requires a specific configuration, supporting up to 35 KPIs and 40 regions.

2

Technical solution

  • Excel-based tool, providing individual input sheets for each KPI
  • Aggregation to high-level heatmap and breakdown to the regional level
  • Export to PDF and Word
  • Support "Read-only mode" for distribution and "Admin mode" for data entry and tool configuration
impact

Result

  • Scorecard by now rolled out to 4 countries
  • Central heatmap to highlight the most important and promising health areas in countries, thus supporting the prioritization of resources allocated
Industry
Public Services
Tool type
Dashboards & heatmaps
Project duration
3 weeks
d2i effort
12 MD
Data volume
up to 35 KPIs
up to 40 regions
Tools involved
Excel
Word