Maji Ndogo Water Project – Part 2 | Data Analysis & Insights In Part 2 of the Maji Ndogo Water Pr...Maji Ndogo Water Project – Part 2 | Data Analysis & Insights In Part 2 of the Maji Ndogo Water Pr...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Thabo's avatar
Thabo Mailula
• Nov 21
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.
Data ModelingData AnalysisPythonSQLdatacleaningqueueanalysis
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started