CASE STUDY
Maji Ndogo Water Crisis Analysis
Using data analytics and business intelligence to evaluate water accessibility, infrastructure performance, and service delivery.
ROLE
Data Analyst
PLATFORM
Python · SQL · Power BI
FOCUS
Data Analytics · Business Intelligence · Infrastructure Planning
The Real Problem
Water service providers often struggle to identify where infrastructure investments will have the greatest impact. Without reliable analysis, issues such as long queue times, broken infrastructure, and unequal access remain difficult to prioritize and address.
The Approach
Transform raw survey and operational data into actionable insights using SQL, Python, and interactive Power BI dashboards.
The project involved cleaning and validating multiple datasets, analyzing water infrastructure and service performance, identifying accessibility gaps, and visualizing the findings through an executive dashboard to support evidence-based infrastructure planning.
What I Built
- Cleaned and transformed water utility datasets using SQL and Python
- Analyzed water source performance, accessibility, service coverage, and infrastructure reliability
- Identified high-priority intervention areas through exploratory data analysis
- Designed an interactive Power BI dashboard for monitoring key infrastructure and service indicators
- Developed data-driven recommendations to improve water accessibility and infrastructure investment
What Changed
- Revealed critical disparities between urban and rural water access
- Identified infrastructure failures affecting thousands of residents
- Prioritized interventions based on population served, queue times, and infrastructure condition
- Delivered an interactive decision-support dashboard that communicates complex findings through clear, actionable visualizations