This project presents a consulting-style analysis of healthcare efficiency across MENA countries, focusing on how effectively healthcare spending translates into health outcomes.
Rather than measuring spending alone, the analysis emphasizes efficiency, benchmarking, and decision support, following a management consulting mindset suitable for public sector and healthcare transformation initiatives.
- Region: MENA
- Sector: Public Healthcare
- Perspective: Efficiency & outcomes (not spending volume)
- Audience: Policy makers, consultants, and analytics leaders
- Source: World Bank – Health, Nutrition & Population
- Methodology Note:
Due to public-sector reporting lags, the analysis uses the latest available value per indicator for each country, reflecting real-world government analytics practices.
- Health Expenditure per Capita (PPP)
- Life Expectancy at Birth
- Infant Mortality Rate
- Physicians per 1,000 People
- Hospital Beds per 1,000 People
- Cleaned and reshaped World Bank indicators using Python (pandas, numpy).
- Consolidated the latest available value per indicator per country.
- Established regional benchmarks (MENA averages).
- Classified countries into Efficiency Categories:
- High Efficiency
- Best Practice
- Efficiency Gap
- Under-resourced
- Built an Executive Power BI Dashboard, optimized for desktop and mobile viewing.
- Efficiency varies significantly: Higher healthcare spending does not consistently translate into better outcomes across MENA.
- Best practices exist: Some countries achieve strong health outcomes with moderate spending levels.
- Clear priority areas: High-spend, low-outcome countries represent the strongest opportunities for efficiency improvement.
- Target efficiency gaps by focusing on operational and governance improvements.
- Scale regional best practices from high-efficiency countries.
- Strengthen performance monitoring through unified healthcare KPI dashboards.
├── datasets/ │ └── World_Bank_Health_Data.csv ├── images/ │ ├── dashboard_desktop.png │ └── dashboard_mobile.png ├── health_care_analysis.ipynb ├── MENA_Healthcare_Dashboard.pbix └── README.md
- Python: pandas, numpy
- Power BI: DAX, Executive dashboard design
- Data Source: World Bank Open Data
This project demonstrates the ability to:
- Translate raw public-sector data into decision-ready insights
- Apply consulting logic rather than descriptive reporting
- Design executive-level dashboards suitable for leadership and policy discussions