bonolo-moholo/Maji-Ndogo

# Maji Ndogo ## Table of contents - Project Overview - Tools - Data Cleaning and Preparation - Exploratory Data Analysis - Data Analysis - Findings - Action Plan - References ## Project Overview The project is about using Data analysis to address water crisis in a Country called Maji Ndogo. Data was generated using AI for the purpose of this project to mirror real life challenges .This data was about the state of water sources across Maji Ndogo, how water is collected, gender parity involved in accessing water, the criminal activities involved in water collection and how everyone is affected. The data was then analysed using SQL and insights visualized using PowerBI and reported to inform decisions by relevant stakeholders. ## Tools - Google Sheets (Data Cleaning) - SQL Server (Data Analysis) - PowerBI (Data Visualization and Creating a Report) ### Data Cleaning and Preparation In the initial phase of data cleaning we performed the following tasks: - We imported/loaded the data, inspected it and split it correctly - Handled missing values and duplicates - Data cleaning and formatting ### Exploratory Data Analysis EDA involved to answer these questions: - How much is the poulation size - Investigating ccess to water by population size - Investigating access to water by area - Investigated access to water by income group ### Data Analysis Data Analysis was performed in the following way: ```sql #Exploring the dataset SELECT * FROM md_water_services; #Checking the type of water sources available SELECT type_of_water_source FROM md_water_services.water_sources; #Assessing the quality of water sources SELECT * FROM water_quality WHERE subjective_quality_score = 10 AND visit_count = 2; -- insight showsdata has errorneous entries as top quality sources should not be visited more than ones but data tells a different story and thus needs cleaning ``` ## Findings These are the findings uncovered 1. Most water sources are in rural areas in Maji Ndogo. 2. 43% o …