timiczn/Water-Access-And-Sanitation-In-Africa

An analysis of water and sanitation availability in selected African countries. # Water Access And Sanitation In Africa ## Table of content - Project overview - Data Source - Tools - Data Cleaning - Exploratory Data Analysis - Data Analysis - Results/Findings - Recomendations ### Project Overview This project analyzes water access and sanitation across various communities in multiple African countries. By examining key patterns and trends within the dataset, the analysis aims to uncover disparities, identify critical areas for improvement, and provide data-driven recommendations. The insights generated will help governments, policymakers, and stakeholders implement effective strategies to enhance water accessibility and sanitation infrastructure in these communities. ### Data Source Axia Africa : The primary data used for this analysis is the Water supply & sanitation in Africa dataset containing details about water availability and sanitation in several communities in selected african countires. ### Tools - Power query - SQL ### Data Cleaning The dataset used in this analysis was provided in a clean and consistent format. An initial assessment was conducted to check for missing values, duplicate entries, and data type inconsistencies. No data cleaning or preprocessing steps were required. The data was determined to be ready for immediate analysis. ### Exploratory Data Analysis - What is the average water availability (litres per capita per day) for each country? - Communities with at least one non-functional water points - The top five communities with the highest annual sanitation maintenance costs. - Total number of functional and non-functional water points per country - Communities with a high incidence of waterborne diseases (>20%) - average distance to the water source per region - Communities that receive both government and NGO support - Community with the highest population per country ### Data Analysis SQL was used to query the dataset to extract valuable insights and arrive at actionable recommendation. Here are the queries de …