Projects Built on Real Data

End-to-end analytics projects tackling real-world problems from fraud detection to climate-smart agriculture.

SQL · Power BI · Excel

Water Funds Accountability Dashboard

Investigated financial irregularities in Kenya's water infrastructure spending. Used SQL window functions across the water_source, location, and visits tables to surface corruption patterns, then built a Power BI dashboard to tell the story visually.

MySQL Power BI Window Functions JOINs Fraud Detection Data Storytelling
View Case Study →
01
Python · Excel · Agriculture

Climate-Smart Agriculture Analytics

Analysed crop yield data against climate variables to guide smallholder farmers in East Africa. Built a full Python pipeline from raw data ingestion through cleaning, statistical analysis, and visualisation — with an Excel summary for non-technical stakeholders.

Python Pandas Matplotlib Excel Data Pipeline Statistical Analysis
View Case Study →
02