blekyz-njugush/maji-ndogo-project

## **The Maji Ndogo Water Crisis Project** ### **A Data-Driven Approach to Transforming Water Access, Quality, and Equity in Maji Ndogo** The Maji Ndogo Project utilizes **SQL and data analytics** to uncover the root causes of the water crisis in the Maji Ndogo region. By analyzing a rich, simulated dataset that mirrors real-world challenges, the project identifies critical issues—from **water accessibility** and **infrastructure failures** to potential **corruption patterns**—and proposes actionable, sustainable solutions. This initiative is directly aligned with **UN Sustainable Development Goal 6: Clean Water and Sanitation**. ## **Project Goals** Our data-driven analysis aims to achieve the following: * **Quality & Safety:** Assess the quality and safety of different water sources. * **Equity:** Analyze water accessibility and distribution inequalities across the region. * **Infrastructure:** Detect critical infrastructure failures and primary sources of contamination. * **Governance:** Identify potential fraud or corruption in water service delivery. * **Intervention:** Recommend targeted interventions to improve water management and public safety. ## **Major Water Sources in Maji Ndogo** Understanding the sources is key to solving the crisis. | Source | Description | Safety Profile | | :---- | :---- | :---- | | **1 River** | Open water source. | **Least Safe:** Very high risk of biological and chemical contamination. | | **2 Well** | Closed community water source. | **Unstable:** Safer than rivers but often contaminated due to aging systems and historical corruption. | | **3 Shared Tap** | Publicly shared access point. | **Operational Challenges:** Common issues include long queue times and maintenance delays. | | **4 Tap in Home** | Functional taps installed inside homes. | **Ideal Access:** Usually serves $\\approx$ 6 people per household. | | **5 Broken Tap in Home** | Non-functional taps in homes. | **Infrastructure Failure:** Caused by pipe bur …