Oscardumai/maji-ndogo-water-project

SQL analysis of Maji Ndogo's water crisis data # Maji Ndogo Water Crisis Analysis ## Project Overview This project analyzes water source data for Maji Ndogo using SQL to identify patterns in water accessibility, infrastructure issues, and queue times. ## Files Structure - `sql-scripts/` - Contains all SQL queries for data analysis - `documentation/` - Project slides and documentation - `README.md` - This file ## SQL Scripts - **SQL Project 2.sql**: Initial data exploration and employee data cleaning - **SQL Project 3.sql**: Advanced analysis including water quality and audit reports ## Key Insights - 43% of population uses shared taps - 31% have home water infrastructure (45% non-functional) - Average queue time: 120+ minutes - Saturdays have the longest queue times ## Technologies Used - MySQL - Data Analysis - SQL Window Functions - Data Cleaning