aumamercyline/Maji-Ndogo-Infrastructure-Insights

Data-driven insights on water accessibility, crime trends, and budget allocation to support decision-making in Maji Ndogo. # Data-Driven Infrastructure Planning: Improving Water Access & Public Safety in Maji Ndogo Using Power BI This project focuses on analyzing water accessibility, infrastructure distribution, and public service challenges in Maji Ndogo using Power BI. The visualizations provide insights into water source availability, population coverage, and regional disparities to support data-driven decision-making. # Maji Ndogo Water Access & Infrastructure Visualizations ## Overview This project explores water access patterns across provinces and towns in Maji Ndogo using interactive Power BI visualizations. The analysis focuses on: - Distribution of water sources across provinces - Population served by each water source type - Urban vs rural access disparities - Town-level dependence on specific water systems - Infrastructure gaps affecting reliable water access The visualizations help identify underserved regions and support strategic planning for infrastructure improvements. ## Tools Used - Microsoft Excel – Data Cleaning & Preparation - Power BI – Data Visualization & Analysis ## Dataset The dataset used in this project is hosted externally. [Download Dataset]docs.google.com # Water Access Visualizations ## 1. Water Sources by Province This visualization shows the count of water sources distributed across different provinces in Maji Ndogo. ![Water Sources by Province]github.com ### Insights - Some provinces contain significantly higher numbers of water sources than others - Water infrastructure distribution varies widely across regions - Provinces with higher water source counts may still experience service pressure depending on population size ## 2. Population Served by Water Source Type This visualization highlights the number of people served by each ty …