InsightByFrank/Healthcare-Access-Facility-Distribution-Analysis-Africa-
Domain:
healthcareCreator:
Ins
Host:
This project delivers a data-driven Power BI dashboard aimed at examining healthcare facility distribution, funding efficiency, emergency response times, and patient satisfaction across 12 African countries. It explores both rural and urban disparities in healthcare infrastructure, providing strategic insights to government agencies, glo
# 🏥 Healthcare Facility Access & Distribution Intelligence Dashboard
## 📌 Project Title
**Healthcare Access Facility Distribution Analysis (Africa)**
---
## 📖 Description
This project delivers a data-driven Power BI dashboard aimed at examining healthcare facility distribution, funding efficiency, emergency response times, and patient satisfaction across 12 African countries. It explores both rural and urban disparities in healthcare infrastructure, providing strategic insights to government agencies, global health partners, and policy makers.
Through intuitive visualizations and DAX-powered metrics, this report sheds light on the dynamics of funding, population-health resource ratios, and regional needs.
---
## 📂 Table of Content
- Description
- Key Performance Indicators
- Processes
- DAX Measures
- Business Questions Answered
- Observations and Data Highlights
- Visuals and Analytics Used
- Actionable Insights
- Expected Outcomes
- Conclusion
- Contact Me
---
## 📊 Key Performance Indicators
| KPI | Value |
|----------------------------------|------------------|
| Total Facilities | 2,000 |
| Total Funding | $231.1 million |
| Doctor-Patient Ratio | 540 |
| Avg. Distance to Facility (km) | 10.6 |
| Avg. Patient Satisfaction (%) | 77.5% |
| Facility Distribution (Rural) | 94% |
| Facility Distribution (Urban) | 6% |
| Avg. Emergency Response Time | 32.4 minutes |
---
## ⚙️ Processes
1. **Data Collection & Exploration**
- Sourced data from African health facility registries and open datasets.
- Focused on 12 countries across Sub-Saharan Africa.
2. **Data Cleaning & Preparation**
- Used Power Query for null handling, type conversion, and renaming.
- Created structured fact and dimension tables.
3. **Data Modeling**
- Defined relationships between regional, funding, facilit …