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.