Abdurhman-elgrm/Maji-Ndogo-Water-Crisis-Analysis

# Maji Ndogo Water Crisis Analysis A data analysis project exploring water access, gender parity, and sustainable development indicators for **Maji Ndogo** ("small water" in Swahili) — a fictional country used as the setting for the well-known ALX/Data Science data analysis curriculum. The project combines a farm/water survey database, UN Sustainable Development Goal (SDG) data, and gender parity indicators to explore the water crisis from several angles, visualized in Power BI. ## What this project covers This repo is data-first: it holds the datasets, database, and Power BI reports used for the analysis, rather than analysis scripts. It's built around three connected themes: 1. **Water access on the ground** — survey data on water sources, queue times, water quality, and who is affected (`Md_summary.csv`, `Maji_Ndogo_farm_survey_small.db`) 2. **Gender parity and development context** — how water access connects to labor force participation, literacy, and urban/rural population splits by gender (`Gender_parity_2022.csv`, `Gender_Egypt.csv`, `Indicator*.csv`) 3. **Global development benchmarking** — how Maji Ndogo (and comparable countries) measure up against the UN's Sustainable Development Goals (`UN_SDG_dashboard_data.csv`) ## The database: `Maji_Ndogo_farm_survey_small.db` A SQLite database with four related tables, each keyed on `Field_ID` (5,654 records each): | Table | Contents | |---|---| | `geographic_features` | Elevation, latitude/longitude, location, slope | | `weather_features` | Rainfall, min/max/average temperatures | | `soil_and_crop_features` | Soil fertility, soil type, pH | | `farm_management_features` | Pollution level, plot size, crop type, annual yield vs. standard yield | This is designed to be explored with SQL joins across tables on `Field_ID` — e.g. relating soil quality and rainfall to actual crop yield outcomes. ## Key datasets | File | What it contains | |---|---| | `Md_summary.csv` | Field-level water source survey data: locat …