Pauline-Njogu/maji-ndogo-sql-analysis

In this project SQL is used to understand a water crisis and plot a way forward . # Maji Ndogo Water Analysis Project ## Project Overview This project explores a water scarcity catastrophe in the fictional country *Maji Ndogo*. Using SQL, the project uncovers inefficiencies in water allocation and highlights potential misuse of resources. ## Dataset - Source: [Synthetic dataset provided for learning purposes] - Size: contains 13 tables ## Workflow 1. Data Cleaning– removed duplicates, handled nulls, standardized formats. 2. Exploratory SQL– joined multiple tables to uncover relationships. 3. Advanced SQL Queries– used CTEs, views, and temporary tables. 4. Analytical SQL– applied window functions for ranking and trend analysis. 5. Visualization – exported cleaned/joined data for plotting (in a separate project). Skills & Tools - SQL (Joins, CTEs, Window Functions, Views) - Data Cleaning & Preparation - Analytical Problem Solving - Jupyter Notebook - Git & GitHub Notebooks - Data Cleaning Notebook - SQL Analysis Notebook - Visualization Notebook Key Insights - Discovered the major water source in each province . - Identified the water sources that needed repair and ranked them based on urgency. - Uncovered corrupt individuals.