DanielOrjii/Basic-water-access-in-Maji-Ndogo-Ndogo

I conducted a comprehensive analysis to assess the current state of water supply in Maji Ndogo using Power BI and identify areas needing improvement. The dashboard aims to promote transparency in revenue usage, track expenses against the budget over time, and eliminate fund wastage # Maji Ndogo Basic Access to Water **Project Overview** This is a comprehensive analysis to assess the current state of water supply in Maji Ndogo and identify areas needing improvement and also implement data-driven solutions to enhance water access for all residents. The dashboard aims to promote transparency in revenue usage, track expenses against the budget over time, and eliminate fund wastage. The dataset used was provided by ExploreAI for my final project. **Data Source** 1. XLSX file: docs.google.com **DA Technical Skills** - Data Ingestion - Data Assessment - Data Analysis - Data Visualization **Analysis Process:** 1. **Data Ingestion:** - Gather detailed information on current water sources, including wells, public taps and taps in homes. - Collect data on water availability, quality, and distribution efficiency. 2. **Data Assessment:** - Ensured consistent column names and data types with each columns. - Identified and resolved errors in our table to ensure data accuracy and integrity. - Identify areas within Maji Ndogo that lack adequate access to clean water. - Determine the population affected and the specific challenges they face. 4. **Data Analysis:** - Analyze the collected data to pinpoint gaps in the water supply network. - Utilized DAX expressions to calculate various measures, including cumulative cost, percent progress, number of lives improved, and the population with basic access to water. 5. **Data Visualization:*** -Built a Power BI dashboard to effectively visualize insights, track project progress, and monitor for budget mishandling. Link to check out Power BI dashboard- app.powerbi.com **Findings:** - Several regions in Maji Ndogo lack reliable access to clean water. - Existing water infrastructur …