erickgathinji/Restoring-Water-Access-SQL-Part-2

SQL analysis of Maji Ndogo water access: cleaned data, honored top surveyors, mapped rural sources, showed 43% rely on shared taps, and found queues average 120+ mins, peaking Sat mornings/evenings. ## Maji Ndogo Water Accessibility and Infrastructure Analysis This project delves into a comprehensive dataset to uncover the underlying issues contributing to Maji Ndogo's water crisis, transforming raw data into actionable insights and a strategic plan for intervention. --- ### Introduction The mission of this project is to thoroughly analyze a reservoir of data concerning water access in Maji Ndogo. Moving beyond isolated data points, the goal is to discern larger patterns and trends, clustering data to gain a panoramic understanding and unearth broader narratives and hidden correlations within the rich dataset. The survey aimed to **identify water sources**, **determine total and average users** for each source, and **examine the duration citizens typically spend in queues** to access water. This effort is crucial for uncovering solutions to Maji Ndogo's water crisis. --- ### Context: The Maji Ndogo Water Crisis President Aziza Naledi emphasized the importance of data-driven solutions. Initial data inconsistencies were identified by Chidi Kunto, prompting the decision to bring in an independent auditor to ensure accuracy and trust in the data. The insights gained from this analysis will be used to formulate a plan to restore water access. --- ### Data Overview The analysis utilized several tables within the `md_water_services` database, including: * `auditor_report` * `combined_analysis_table` * `data_dictionary` * `employee` * `global_water_access` * `incorrect_records` * `location` * `project_progress` * `visits` * `water_quality` * `water_source` * `well_pollution` **Key Data Points:** * **Total People Surveyed:** Approximately **27.6 million citizens** were surveyed. * **Survey Duration:** The data collection spanned **924 days**, roughly 2.5 years. This highlights the extensive effort involved in gathering the data. * **Location Distribution:** * The entire country was properly surveyed, ensuring the dataset accura …