EslamAshraf32/Maji-Ndogo-Water_Crisis
Domain:
environment and energyRecord type:
project
Creator:
Esl
Host:
the project identifies critical gaps in water resource management and proposes actionable solutions and provides data-driven insights into water access, infrastructure efficiency, and social impacts across Maji Ndogo’s five provinces. By analyzing key metrics—including queue times, crime risks, budget allocation, and rural/urban disparities
💧 Maji Ndogo — Water Access & Infrastructure Dashboard (Power BI)
> **Power BI Project** uncovering hidden patterns in national water data: access inequality, infrastructure gaps, time loss, gender risks, and budget misallocation.
> Designed with a clean layout, deep DAX measures, and storytelling to empower stakeholders.
---
## 🚀 Why This Project Matters
| Real-World Challenge | How I Tackled It |
| ------------------------------------ | ----------------------------------------- |
| National water access below 34% | Visual map + access KPIs + source types |
| Long queues, 1.01M min/week wasted | Queue visualizations by area + time |
| Gender-based safety risks | Drill-throughs on collection hour/gender |
| Budget inefficiency & poor ROI | Cost/improvement + province comparisons |
| Infrastructure prioritization needed | RO filters vs Public taps vs Wells mapped |
This project simulates **data storytelling for a national NGO/government team**: from cleaning and modeling to dashboard design and policy insights.
---
## ✨ Visual Preview
| National Access | Queue Time | Budget & Improvements |
| --------------------------------------------------- | ----------------------------------------------- | ----------------------------------------------------- |
| | | |
| Source Types & Gender Risks | Hawassa Report |
| ------------------------------------------------------- | ---------------------------------------------------------- |
| | |
---
## 🛠️ Tools & Skills Demonstrated
* ✅ Excel Power Query for cleaning and transformation
* ✅ Power BI: Data modeling, slicers, navigation, drill-through
* ✅ DAX for queue metrics, crime risk index, ROI, cost per impact
* ✅ Conditional formatting for red- …