cod-dot/kenya-food-price-analysis

The project analysis food prices in Kenya from 2006-2024 using Excel, SQL and Power BI. Kenya Food Price Analysis (2006–2024) **Project Overview** This project analyzes food price trends in Kenya between 2006 and 2024 using Excel, SQL, and Power BI. **Business Questions** * Have food prices generally increased over time? * Which commodities experienced the highest price growth? * How do food prices vary across regions? * What differences exist between wholesale and retail prices? **Data Cleaning** Key cleaning steps included: * Converting text dates to the proper date format * Extracting years for trend analysis * Standardizing units (kg, g, ml, liters) * Creating a standardized price-per-unit metric * Removing rows(latitude and longitude) **Tools Used** * Excel * MySQL * Power BI **Key Findings** * Food prices generally increased over time. * Some commodities experienced significantly higher growth than others. * Regional price differences were evident across the study period. **Author** Linet Gichuki Data Analyst