DATA ANALYTICS • HEALTHCARE
An Excel-based analytics suite examining healthcare expenditure, social health insurance performance, institutional capacity, and infrastructure trends using official Kenyan statistics.
01 — PROJECT OVERVIEW
This project analyzes Kenya's healthcare economy through expenditure, institutional capacity, and social health insurance indicators.
The analysis uses official statistics from the Kenya National Bureau of Statistics Economic Survey and transforms them into an executive reporting workbook.
02 — ANALYTICAL AREAS
Examined national and county-level health budget allocations alongside GDP-related health expenditure.
Tracked insurance fund utilization and premium collection patterns.
Analyzed the distribution and capacity of more than 16,000 healthcare facilities.
Used dual-axis and logarithmic visualizations to communicate complex patterns clearly.
03 — VISUAL ANALYSIS
Healthcare expenditure analysis
SHA / SHIF performance analysis
Healthcare facility capacity
Hospital bed capacity
04 — KEY INSIGHTS
The analysis identified a 158.6% deficit anomaly in the Social Health Insurance Fund category, where benefits utilization substantially exceeded premium collections.
More than 16,000 facilities were analyzed, requiring logarithmic scaling to make differences across facility levels visually interpretable.
The analysis highlighted a significant shift in private-sector hospital bed capacity relative to public-sector capacity.
EXPLORE THE IMPLEMENTATION