peter-ngamau/Kenya-Agricultural-Market-Price-Analysis

Excel + Power Query analysis of real Kenyan agricultural market prices (2024–2026) — from messy raw government data to a clean, interactive dashboard with real findings on price volatility, seasonality, and county-level trends. # Kenya Agricultural Market Price Analysis (2024–2026) **An end-to-end Excel analytics project exploring how food prices behave across Kenyan counties — built from raw government data, cleaned by hand, and turned into an interactive dashboard with real, actionable findings** --- ## Why I built this I studied Agribusiness Management before moving into data analytics, and I wanted a portfolio project that actually used both sides of that background — not another generic Titanic or Superstore dataset, but something grounded in a market I understand and care about: Kenya's agricultural economy. So I went straight to the source: **KAMIS**, the Kenyan Ministry of Agriculture's own market price system, and pulled real wholesale and retail price data for seven commodities across eleven counties, covering January 2024 to June 2026. Then I did what any analyst actually has to do with real-world data — I found out it was messy, inconsistent, and full of surprises. This project is as much about *how I handled that mess* as it is about the final dashboard. --- ## What's in this project - **Raw data extraction** from KAMIS's live market search tool (7 commodities × 11 counties) - **Power Query ETL pipeline** — combining, cleaning, and transforming ~10,800 raw price records - **A proper star-schema data model** in Excel's Data Model (Power Pivot), not just a flat spreadsheet - **DAX measures** for volatility, margins, and data-quality checks - **An interactive dashboard** with slicers for County, Region, and Year - **A full findings & recommendations report**, written for both technical and non-technical readers --- ## The data cleaning story (the part I'm proudest of) Real data doesn't arrive clean, and this project leaned into that instead of hiding it. A few things I found and had to solve along the way: - **Some counties simply weren't in the system.** I originally planned to cover Kiambu, Machakos, Mombasa, and Kajiado — but testing showed zero price records fo …