Sire6715/Maji-Ndogo-

A comprehensive Power BI data analysis project examining water access, quality, safety, and improvement planning across the five provinces of Maji Ndogo. # 💧 Maji Ndogo — National Water Access & Infrastructure Analysis > A comprehensive Power BI data analysis project examining water access, quality, safety, and improvement planning across the five provinces of Maji Ndogo. --- ## Project Overview This project presents a multi-page Power BI dashboard analyzing the water crisis in the fictional nation of **Maji Ndogo**, covering: - Population distribution and water source types - Queue times and gender dynamics at water collection points - Water quality and contamination testing results - Crime and safety data around water collection - Province-level infrastructure improvement plans and budget allocation The goal is to identify the most critical interventions needed to bring **basic water access** to the ~66% of the population currently underserved, within a **total national budget of ~$147M USD**. --- ## Dashboard Pages ### Page 1 — National Improvement Plan Summary > **Overview page** — start here for a high-level summary of the entire project. The consolidated national plan for infrastructure upgrades: | Metric | Value | |---|---| | Current population with basic water access | **34%** | | Projected improvement after interventions | **+66%** | | Total national budget required | **$147M USD** | | Total improvement actions planned | **25,398** | **Top improvement types by count:** | Improvement | Quantity | Budget | |---|---|---| | Install RO filter | 7,093 | $39,965,100 | | Drill well | 3,379 | $38,862,000 | | Install UV and RO filter | 5,374 | $22,332,800 | | Install public tap(s) | ~3,696 | ~$19,157,000 | | Diagnose local infrastructure | 5,856 | $2,554,475 | --- ### Page 2 — Water Sources Overview An introduction to water access across three highlighted provinces (Akatsi, Amanzi, Hawassa). Key findings: - **18M people (63.85%)** live in rural areas; **10M (36.15%)** in urban areas - The most common water source is the **well** (~17,000 count), followed by tap-in-home and shared taps - **Shared t …