Bernadine05/Access-to-water-services

A project Identifying the availability of clean drinking water from various water sources such as wells, taps and rivers for residents in an African country. The project also looks into their ease of access and problems people encounter while trying to access the water sources. Possible solutions and recommendations are also communicated. # Access-To-Water-Services ## Table of Contents - Project Overview - Data Sources - Tools Used - Data Wrangling - Exploratory Data Analysis - Data Analysis - Findings - Recommendations - Limitations ## Project Overview A project Identifying the availability of clean drinking water from various water sources such as wells, taps and rivers for residents in an African country. The project also looks into their ease of access and problems people encounter while accessing water sources. I'd also like to let you know about possible solutions and recommendations. ### Data Sources Md-water-services-data: The primary dataset used in this data analysis project is the "md-water-services-data.csv" file, which comprises different tables that give detailed information about water services in the country. Auditor-report-data: The secondary dataset used in this analysis is the "auditor-report.csv" file which contains an audit report on the database by an independent auditor and gives insights into inconsistencies in the database and records that need reviewing. ### Tools Used - Excel and Google Sheets - Data Cleaning and creating Mock Dashboards - SQL Server (MySQL) - Data Analysis - Power BI - Creating Reports and Visualizations ### Data Wrangling In the initial data preparation step, I performed the following steps: 1. Data loading and inspection 2. Identifying null and missing values and utilizing data replacement methods to handle the values 3. Data cleaning and formatting ### Exploratory Data Analysis EDA involved exploring the water services data to answer key questions, such as: - What are the factors contributing to the water crisis? - What types of water sources are mainly used and how many people does each type of water source serve? - What is the average queue time for water and peek queueing times? - Which water sources have broken infrastructure? - What is the cost of repairing each type of water source? ### Data Analysis Code and features I worked w …