Ochieng-sys/kenya-healthcare-analytics-dashboard

An Excel data analytics suite tracking Kenya's healthcare economy using official KNBS data (2021-2025). Features multi-tab financial models, dual-axis SHA insurance deficit tracking, and logarithmic facility capacity visualization. Showcases advanced data modeling and executive reporting. # kenya-healthcare-analytics-dashboard An Excel data analytics suite tracking Kenya's healthcare economy using official KNBS data (2021-2025). Features multi-tab financial models, dual-axis SHA insurance deficit tracking, and logarithmic facility capacity visualization. Showcases advanced data modeling and executive reporting. # Kenya Healthcare Financing & Infrastructure Dashboard (2021–2025) ## 📊 Project Overview This repository contains a comprehensive, multi-tab Microsoft Excel analytics suite tracking macroeconomic health expenditures, institutional capacity shifts, and social health insurance fund utilization. The data was extracted, transformed, and modeled using official statistics from the **Kenya National Bureau of Statistics (KNBS) Economic Survey**. ## 🛠️ Tech Stack & Skills Demonstrated * **Tool**: Microsoft Excel * **Skills**: Data Transformation, Financial Modeling, Data Storytelling, Dual-Axis Tracking, Logarithmic Scale Adjustments. ## 📂 Repository Structure * 📄 `Kenya_Healthcare_Financing_Data_Analytics.xlsx` - Full interactive spreadsheet workbook containing data models, calculated matrices, and chart sheets. * 📁 `images/` - High-resolution exports of dashboard assets for executive reporting. ## 📈 Executive Insights & Visualizations ### 1. Macroeconomic Expenditures * **Insight**: Successfully mapped National vs. County health budget allocations. Shows the steady scaling of devolved health funding alongside national GDP health tracking. * ### 2. Social Health Authority (SHA) Performance * **Insight**: Uncovered a 158.6% deficit anomaly within the Social Health Insurance Fund (SHIF) category, where benefits utilization drastically outpaced premium collections. * ### 3. Institutional Expansion & Bed Capacity * **Insight**: Deployed a base-10 logarithmic scale to visualize 16,000+ facilities, ensuring tiny Level 5 & 6 metrics remained visible alongside massive Level 2 dispensary volumes. Revealed that private sector hospital bed capacity has r …