Lil729/Kenya-Health-Facility-Dashboard

A real-world style Monitoring & Evaluation (M&E) dashboard built using health facility data across multiple counties in Kenya. This simulates an M&E analyst's role in an NGO or government health program. # Kenya Health Facility Dashboard 📊 **Kenya Health Facility Dashboard** This dashboard analyzes the distribution and accessibility of health facilities across Kenya. Built to support data-driven decisions in public health and Monitoring & Evaluation (M&E) contexts. --- ### 🎯 Project Objective To evaluate how health services are distributed across counties in Kenya. This helps answer: - Are health facilities fairly distributed by region? - Which counties have service gaps? - What is the public vs. private ownership breakdown? --- ### 📂 About the Data The dataset includes public and private health facilities in Kenya with these key fields: - Facility Name - Facility Type - Level - Bed Capacity - County - Ownership Additional classification (e.g., facility size) was done using Excel formulas. --- ### 🛠️ Tools Used - **Microsoft Excel** — for data cleaning, formatting, and classification - **Power BI** — for creating an interactive dashboard with filters and KPIs --- ### 🔍 Key Insights - 📍 **Nairobi** has the highest facility density — showing strong urban coverage. - 🏜️ **Northern counties** like Wajir and Garissa are underserved. - 🧪 **Service Gaps**: Some counties lack TB testing and maternal care facilities. - 🏛️ **Ownership**: 60% of facilities are public, with private ones mostly in urban centers. --- ### 🖼️ Dashboard Previews #### ✅ Power BI #### ✅ Excel --- ### 📁 Deliverables - 🔗 Excel File (.xlsx) - 🔗 Power BI File (.pbix) - Insight summary (this README) --- ### 👥 Intended Audience - NGO Monitoring & Evaluation Teams - Public Health Program Officers - Data-Driven Donor Reporting Units --- ### 📌 Use Case This dashboard can help identify underserved regions, inform resource allocation, and support equitable health service delivery in Kenya.