xolanintsibande/Maji-Ndogo-Data-Analysis-Dashboard

Data analysis project using Power BI to evaluate water access, service efficiency, safety, crime patterns, and budget allocation in Maji Ndogo. ## 📊 Maji Ndogo Data Analysis Dashboard Data analysis project using Power BI to evaluate water access, service efficiency, safety, crime patterns, and budget allocation in Maji Ndogo. ## 📌 Project Summary This project analyzes water infrastructure and related systems in Maji Ndogo. Focus areas: - Water access - Queue times - Water quality - Crime patterns - Budget allocation The analysis uses Power BI dashboards to support decisions based on data. --- ## Problem Communities face: - Unequal water access - Broken infrastructure - Long queues - Unsafe water sources - Uneven resource allocation Decisions without data lead to inefficient interventions. --- ## Objective Answer key operational questions: 1. Where are water access gaps located 2. Which water sources serve the most people 3. When do queues peak 4. Which areas face unsafe water conditions 5. How resources are allocated across regions 6. Where interventions deliver the highest impact --- ## Dashboard Structure ### 1. Water Infrastructure Focus: access and reliability - Map Provinces: Sokoto, Hawassa, Kilimani, Amanzi, Akatsi - Population split Rural vs Urban - Treemap People served per water source - Bar chart Source distribution: - Well - Tap in home - Tap in home broken - Shared tap - River - Stacked bar Water sources per town Insight: - Infrastructure exists but fails in some areas - Some populations depend on unsafe sources --- ### 2. Queues Focus: service pressure - Line chart Queue time by hour - Bar chart Queue time by day - Doughnut chart Queue distribution by gender - Bar chart Queue time by province Insight: - Queue time varies by time and location - Demand exceeds supply at peak hours --- ### 3. Water Quality Focus: safety - Pie chart - Clean water - Biological contamination - Chemical contamination Insight: - Water access does not ensure safe water --- ### 4. Crime Data Focus: social conditions - Pie chart Crime types by gender - Clustered bar chart Gender distribu …