sharlynmuturi/Kenya-Health-Spending-Efficiency-Analysis

# Government Spending Efficiency Analyzer ### Evaluating Health Expenditure Efficiency Across Kenyan Counties ## 1. Project Overview This project analyzes how efficiently Kenyan counties convert public health spending into measurable healthcare outcomes. It answers a key policy question: > **Are counties using public funds efficiently to improve health outcomes?** Using **PySpark, Databricks, and a Medallion Architecture**, the project builds a scalable data pipeline, constructs an interpretable efficiency model, and generates actionable insights for policy and planning. _For a detailed analysis, methodology, and visual insights, see the full report included in this repository. `Report - Government Health Spending Efficiency Analysis.pdf`_ ## 2. Objectives * Measure **efficiency of health spending** at the county level * Compare **resource allocation vs actual outcomes** * Identify **high-performing and underperforming counties** * Generate **data-driven policy recommendations** ## 3. Problem Statement > **Which counties in Kenya are most efficient in converting health expenditure into improved healthcare outcomes?** ## 4. Key Insights ### 1. Spending Does Not Guarantee Efficiency Higher spending does not consistently translate into better outcomes. Several high-spending counties achieve only moderate results, suggesting **diminishing returns** at higher budget levels. ### 2. Efficient Use of Limited Resources Some counties deliver strong outcomes despite moderate or low spending, indicating **better resource utilization and operational efficiency**. ### 3. Structural Challenges in Low-Performing Counties Counties such as Turkana, Wajir, and Mandera show persistently low efficiency, likely due to Geographic constraints, Limited infrastructure or workforce shortages ### 4. Clear Performance Segmentation Clustering reveals distinct groups: * **Efficient:** Strong outcomes relative to spending * **Inefficient:** High spending, weak outc …