Geoffrey-lab/Power-BI-Water-Access-and-Safety-Analysis-Maji-ndogo-dataset-

Uncover Maji Ndogo's water trends with Power BI. Dhahabu leads tap_in_home, Mondays have queues, and Thursdays at 15:00 are optimal. Akatsi faces contamination. Repository holds Power BI files. #WaterAnalysis #PowerBI #Insights # Power-BI-Water-Access-and-Safety-Analysis-Maji-ndogo-dataset- ## Overview: This GitHub repository houses a comprehensive Power BI project focused on analyzing water access and safety data in Maji Ndogo. The project explores various aspects, including tap sources, queue dynamics, crime data, and pollution statistics, providing valuable insights for decision-makers and policymakers. # Click link to view interactive dashboard app.powerbi.com ## Key Findings: 1. **Town with Highest Tap_in_Home Sources:** - Identified Dhahabu as the town with the highest tap_in_home sources, enhancing accessibility to clean water. 2. **Average Percentage of Men in Queues:** - Calculated the average percentage of men in queues, revealing that approximately 40% of individuals in queues are men. 3. **Consistently Longer Queue on Mondays:** - Determined that Mondays have a consistently longer queue in Maji Ndogo, highlighting a specific challenge for water access on this day. 4. **Optimal Time for Shortest Queue on Thursdays at 15:00:** - Advised citizens seeking the shortest queue time to visit water sources on Thursdays at 15:00. 5. **Percentage of Children in Shortest Queue in Maji Ndogo:** - Discovered that at the time of the shortest queue, approximately 3% of individuals in the queue are children. 6. **Province with Most Chemically Contaminated Wells:** - Identified Akatsi as the province with the highest number of chemically contaminated wells, raising concerns about water quality. 7. **Hour with Lowest Crimes Against Children:** - Analyzed crime data for every day of the week, pinpointing 12:00 as the hour with the lowest number of reported crimes against children. 8. **Largest Disparity in Sexual Assault Cases on Fridays:** - Investigated the data and found that Fridays have the largest disparity between women and me …