Abolanle890/Food_price

This is an in-dept analysis on the food prices of commodity in Nigeria from 2002 up on till 2024 # Food Price Analysis in Nigeria ## Table of Contents - project overview - Dataset Information - Datasets Fields - Key Insights - Expository Data Analysis - Recommendations - Tools Used ## Project Overview ----- This project analyzes food prices across various Nigerian regions and markets using Excel, MySQL, and Power BI. The goal is to identify price trends, regional disparities, and data quality issues in food commodities. ### Commodity Price Analysis The bar chart above visualizes the total price distribution across different food commodities. It highlights the top five commodities by total price recorded: Groundnuts (shelled) and Local Rice are the most expensive overall, each surpassing ₦25 million. Cowpeas (white) and Cowpeas (brown) follow closely behind. Yam rounds out the top five. This visualization helps identify which food items contribute most significantly to total food expenditure over the period analyzed. .png) ### Sum of Price Admin_1 (State) This bar chart summarizes total price values at the state level (admin_1). Borno records the highest price sum, with Yobe and Kaduna following. This visualization gives a macro-level overview of which states drive the most value in the dataset. ### Sum of Price by admin_2 (Local Government Areas) This horizontal bar chart breaks down the total price values by local government areas (admin_2). Maiduguri stands out as the highest contributor, followed by Gwandu and Ibadan North, indicating regional concentration of price activity at the LGA level. ### Sum of Price by Year This area chart shows how the total price value has changed over time. There is no activity before 2010, followed by noticeable spikes in 2015 (27M), 2018 (17M), and a peak in 2021 (52M) before dropping to 7M. This trend helps track historical activity and highlight key years of interest. ## Dataset Information The dataset used in this project was sourced from the Humanitarian Data Exchange (HDX), provided by the World Food Programme …