Oluwadamilola-Oni/Water-Access-Infrastructure-Public-Safety-Analysis-Maji-Ndogo-

This project explores water access challenges in Maji Ndogo, focusing on infrastructure availability, queue behavior, gender disparities, and associated safety risks. Using SQL and Power BI, the analysis uncovers patterns that highlight how limited water infrastructure impacts both access and public safety. # Water-Access-Infrastructure-Public-Safety-Analysis-Maji-Ndogo- This project explores water access challenges in Maji Ndogo, focusing on infrastructure availability, queue behavior, gender disparities, and associated safety risks. Using SQL and Power BI, the analysis uncovers patterns that highlight how limited water infrastructure impacts both access and public safety. 📂 Dataset Description The dataset consists of survey and observational data collected across multiple locations, including: Population & Access Data: Number of people served, location type (urban/rural), water source type Queue Data: Time in queue, hour of day, day of week Demographic Composition: Percentage of men, women, and children in queues Infrastructure Data: Functional vs broken water systems Crime Data: Type of crime, victim gender, time and location of incidents 🛠️ Tools Used SQL – Data extraction and initial analysis Power BI – Data visualization and dashboard development 📊 Key Insights A significant portion of the population relies on shared water sources, placing pressure on limited infrastructure Average queue times exceed 120 minutes, with peak congestion on weekends Women and children are disproportionately responsible for water collection Infrastructure failures are geographically concentrated, not evenly distributed Increased queue times and crowding may contribute to higher exposure to safety risks, particularly for vulnerable populations 📈 Dashboard Features National Overview: Population distribution and water source usage Geospatial Analysis: Identification of regions with broken infrastructure Queue Analysis: Time-based patterns in water collection behavior Demographic Insights: Gender and child participation in queues Risk Analysis: Exploration of crime patterns near water access points 💡 Key Takeaway Water access is not only an infrastructure challenge but also a social and safety issue. Improving access could reduce wait times, ease the burden on vulnerable group …