My Portfolio

Maji Ndogo is a fictional country facing a severe water crisis. This project aimed to tackle the problem through a series of structured steps:

• Data Cleaning: Organized and prepared raw survey data in Google Sheets for analysis.

• SQL Analysis: Used MySQL to investigate water accessibility, queue lengths, contamination levels, and infrastructure challenges.

• Fraud Detection: Uncovered signs of corruption in the survey data using targeted SQL queries.

• Power BI Visualization: Designed interactive reports to explore:

  • Crime rates at water sources and how they affect women, men, and children.

  • The busiest times and days for water collection.

  • Budget needs for each province and across the country.

Dashboards for Different Audiences:

• Public Dashboard: Tracked project progress, funding allocation, and overall impact.

• Funder Dashboard: Offered detailed insights into spending, cost-saving opportunities, and funding shortfalls.