ComfortHamese04/municipal-service-delivery-analytics

A data analytics and Power BI project investigating municipal service delivery, infrastructure performance and intervention outcomes in South Africa. # Municipal Service Delivery and Infrastructure Performance Analytics An enterprise-style data analysis and business intelligence project examining municipal service access, operational performance, financial alignment and intervention outcomes in South Africa, with the City of Cape Town as the detailed case study. ## Current status **Phase 2 — data validation and repository foundation** - Project charter completed - Public sources and publication frequencies validated - Reproducible ingestion foundation created - Data quality and source registers created - Raw datasets intentionally excluded from Git - Power BI, warehouse and intervention application planned for later releases ## Business objective Connect household service access, municipal finance, geographic context and operational interventions so that decision-makers can answer: 1. Where are service gaps concentrated? 2. Which services and areas experience repeated problems? 3. Which factors are associated with slower resolution? 4. Is spending aligned with service need and outcomes? 5. Which groups experience the greatest disadvantage? 6. Do completed interventions improve the selected KPIs? The project distinguishes observed facts, statistical associations, likely contributing factors and untested hypotheses. It does not treat correlation as proof of causation. ## Planned architecture ```mermaid flowchart TD A["Treasury, Stats SA and Cape Town data"] --> B["Python ingestion and validation"] B --> C["Bronze raw layer"] C --> D["Silver cleaned layer"] D --> E["SQL warehouse and Gold marts"] E --> F["Power BI reports"] G["C# intervention API"] --> E ``` ## Repository structure | Path | Purpose | |---|---| | `config/` | Versioned, non-secret source configuration | | `data/` | Local Bronze, Silver, Gold and quarantine data; contents ignored by Git | | `docs/` | Charter, source register, quality assessment and decisions | | `src/ingestion/` | Reproducible public-data ingestion code | | `src/analysis/` …