MercyObasi/Solving-Maji-Ndogo-water-crisis-
Domain:
environment and energyRecord type:
project
Creator:
Mer
Host:
End-to-end data analytics project focused on understanding and improving water access in Maji Ndogo. Using SQL for data exploration and Power BI for visualization, the project highlights water source conditions, population impact, infrastructure needs, and budget priorities to support sustainable planning and resource allocation.
# 🌍💧 Maji Ndogo Water Crisis — Data-Driven Insights and Sustainable Solutions
*A SQL-powered analysis revealing the reality behind water access, infrastructure failures, and the path toward clean water for all.*
---
## 🚀 Project Summary
This project investigates the water access crisis in **Maji Ndogo**, using SQL and Power BI to uncover the real issues affecting millions of residents across the country.
Through structured analysis, dashboards, and clear visual storytelling, the project highlights contamination risks, infrastructure breakdowns, corruption patterns, and the resources needed to fix these challenges.
The goal is simple:
**Turn raw data into clear insights that help leaders make better decisions for sustainable, equitable water access.**
---
## 🎯 Objectives
- Understand where clean water is available and where it has failed.
- Identify towns facing contamination, long queues, or broken infrastructure.
- Estimate the budget required to repair and expand water access.
- Provide government leaders with a clear roadmap for action.
- Share findings through a publicly accessible Power BI dashboard.
---
## 🛠️ Tools & Technologies
| Tool | Purpose |
|------|---------|
| **SQL (MySQL Workbench)** | Data cleaning, querying, transformation, and validation |
| **Power BI** | Visual storytelling, dashboards, geospatial insights, metrics, and KPI tracking |
| **Excel (initial data)** | Raw dataset provided from Explore AI academy for the ALX data analytics program |
---
## 🗂️ Project Structure
- ├── data/
- │ └── raw/
- │
- ├── sql/
- │ ├── analysis/
- │ └── transformations/
- │
- ├── powerbi/
- │ ├── datasets/
- │ └── documentation/
- │
- ├── measures/
- │ └── DAX_measures.md
- │
- ├── reports/
- │ └── maji_ndogo_dashboard.pbix
- │
- ├── screenshots/
- │
- └── README.md
---
## 📊 What the Analysis Revealed
The story behind the data paints a clear picture of life in Maji Ndogo:
- **Many rural communities rely on broken or unreliable ta …