Sire6715/Maji-Ndogo-
Domain:
environment and energyRecord type:
project
Creator:
Sir
Host:
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 …