This project analyzed the impact of the Teachers Service Commission (TSC) raising the minimum qualification for the P1 to Junior Secondary School (JSS) World Bank upgrade programme from KCSE C plain to C+.

In this case study, I applied SQL to analyze real-world restaurant data as part of the 8 Weeks SQL Challenge by Danny Ma. I built the dannys_diner database from scratch, created core tables for members, menu items, and sales, and performed analyses to uncover customer behavior patterns.

Food prices touch every Kenyan household, but what’s really driving the squeeze on the kitchen budget? In this case study, I analyzed World Food Programme market price data to track how the cost of an everyday basket — maize flour, cooking oil, sugar, milk, sukuma wiki, tomatoes, and onions — changed between June 2024 and June 2025.

A case study on DAP fertilizer prices in Kenya — examining national averages, county-level differences, and recent trends to assess whether maize farmers can realistically afford DAP this planting season.

This study compares dry maize plus milling versus packaged flour during Kenya’s 2025 price hikes, showing that milling can save up to Ksh40 if milling losses are ignored, but packaged flour is slightly cheaper once milling losses are accounted for.

A data-driven analysis using the ChickWeight dataset to explore how experimental diets affect early-stage chick growth. Backed by t-tests, ANOVA, effect sizes, and post-hoc analysis, the report highlights which diets deliver the strongest growth outcomes.

Safaricom’s 5G rollout is gaining pace—but remains concentrated in a narrow urban corridor. This analysis maps every known 5G-enabled estate in Kenya, revealing a sharp geographic imbalance. With Nairobi far ahead of the rest, the data offers a glimpse into where digital infrastructure is landing—and where it isn’t.