Cover image for Maji Ndogo Water Project – Part 2 | Data Analysis & Insights...
Maji Ndogo Water Project – Part 2 | Data Analysis & Insights In Part 2 of the Maji Ndogo Water Project, I focused on cleaning and analyzing employee and water source data to understand access, detect patterns, and prioritize interventions. Key Activities: Employee Data Cleaning – Standardized emails, converted to lowercase, and updated phone numbers. Employee Performance – Counted visits per employee and identified top surveyors. Water Source Distribution – Analyzed records by town and province, calculated rural percentages, and total people served. Water Source Usage – Calculated average and total users per source type. Prioritizing Repairs – Ranked water sources by people served to guide repair priorities. This workflow highlights water access, employee activity, and priority areas for intervention.
0
3