CDS2210/South-African-District-Health-Performance-Explorer-Power-BI-
Domaine:
healthcareType de record:
tools
Créateur:
CDS
Hôte:
An interactive Power BI report that tracks district-level health system performance (access, quality, outcomes) and disease surveillance signals, normalised by population, with maps, trends, and benchmarking.
# South African District Health Performance Explorer (Power BI)
**An interactive Power BI report that tracks district-level health system performance and disease surveillance in South Africa.**
It benchmarks provinces/districts, normalises by population, and highlights outliers over time.
---
## ✨ Highlights
- National overview KPIs (PHC headcount per capita, antenatal visit If you see field warnings, it just means the sample data isn’t there yet — continue to **Step 2** of this guide (to be added).
---
## 🗂️ Data Sources (links added in Step 2)
- District Health Barometer (latest)
- Stats SA Mid-Year Population Estimates (latest)
- NICD Notifiable Medical Conditions monthly reports
- Optional facility locations (for map tooltips/nearest-facility demo)
*Note:* This project uses public, aggregate data. No personal/identifiable information is included.
---
## 🧱 Data Model (star-ish)
**Facts:** `Fact_DHB`, `Fact_NMC`, `Fact_Pop`
**Dimensions:** `Dim_Geography`, `Dim_Time`, `Dim_Indicator`, `Dim_Condition`
A small, ready-to-run sample will ship in **Step 2**.
---
## 📊 Pages
1) Overview • 2) Benchmark • 3) Disease • 4) Map • 5) Equity & Spend • 6) About (definitions & sources)
---
## 🔒 Production Considerations (for interviews)
- Scheduled refresh with parameters for year/URL.
- Row-Level Security (RLS) by province/district.
- Data quality panel (late/missing months).
- Facility-level layers where permitted; always aggregate & de-identify.
---
## 🗺️ Roadmap
- [ ] Add sample data CSVs (Step 2)
- [ ] Publish `.pbit` with Power Query steps
- [ ] Add screenshots & short demo GIF
- [ ] Optional Deneb visuals (boxplot) for distribution view
---
📊 **Overview**
This Power BI project explores district health indicators and notifiable medical conditions in South Africa.
It uses sample data from DHB, Stats SA and NICD (2024 demo).
⚙️ **Features**
- National average vs district performance (±5% threshold)
- Best and worst performing districts
- District compari …