EslamAshraf32/Maji-Ndogo-Water_Crisis

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- …