CDS2210/South-African-District-Health-Performance-Explorer-Power-BI-

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 …