Noura-awad/Water-Access-Infrastructure-Impact-Analysis-Maji-Ndogo-Project

Data-driven analysis of water accessibility and infrastructure efficiency to identify service gaps and optimize resource allocation. # Water-Access-Infrastructure-Impact-Analysis-Maji-Ndogo-Project Data-driven analysis of water accessibility and infrastructure efficiency to identify service gaps and optimize resource allocation. ## 📌 Overview This project analyzes water accessibility, infrastructure investments, and service delivery across different provinces in Maji Ndogo. The goal is to uncover key gaps in water access and evaluate how infrastructure spending impacts service quality and population coverage. --- ## 🎯 Business Problem Access to clean water remains a critical challenge in many regions. Decision-makers need to understand: - Which locations are most underserved - How infrastructure investments are distributed - Whether spending translates into real improvements --- ## 🎯 Objectives - Analyze water access levels across provinces and locations - Identify regions with the highest number of affected people - Evaluate the effectiveness of different improvement initiatives - Provide data-driven insights to support better resource allocation --- ## 🛠 Tools & Technologies - Power BI (Data Visualization & Dashboarding) - SQL (Data Analysis & Querying) - Excel (Data Cleaning & Preparation) --- ## 📂 Dataset The dataset includes: - Population by province and location type (Urban/Rural) - Water access sources (well, river, tap, etc.) - Infrastructure improvements (RO filters, drilling wells, repairs, etc.) - Budget allocation and costs --- ## 📊 Key Insights - Certain provinces (e.g., Sokoto, Kilimani) show higher populations affected by limited water access - Rural areas are significantly more impacted compared to urban areas - Shared water sources (e.g., shared taps) serve the largest population but may indicate infrastructure gaps - Infrastructure investments vary widely, with some solutions delivering higher impact at lower cost - Budget allocation does not always align with areas of highest need --- ## 📈 Dashboard Features - Interactive filters by province and date - KPIs for bud …