Workflow Explanation – Part 1 Here’s what I did in this first part of the Maji Ndogo Water Projec...Workflow Explanation – Part 1 Here’s what I did in this first part of the Maji Ndogo Water Projec...
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
Workflow Explanation – Part 1
Here’s what I did in this first part of the Maji Ndogo Water Project:
1.Understand the Data
First, I looked at the types of water sources in the dataset: rivers, wells, shared taps, home taps, and broken taps. I noted which sources are generally safe versus which are high risk. This step helped me know what “normal” data should look like.
2.Identify Anomalies in Queue Times
I checked for visits where people waited more than 8 hours (500 minutes). This flagged water sources that may have access problems or data errors.
3.Check Water Quality Records for Invalid Revisits
I focused on records with perfect water quality scores (10) but multiple visits. According to the survey rules, only shared taps should have multiple visits. This step identified invalid or duplicated records in the database.
Data VisualizationData AnalysisProduct Data AnalyticsSQLdatacleaning
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