cheenasar/Nigeria-Food-Price-Analytics-Dashboard

Real world food price analysis across 14 Nigerian states using WFP data analyzing price trends, volatility and supply chain disruptions 2002-2026 using Power BI and MySQL. # Nigeria Food Price Analytics Dashboard 2002-2026 ## Project Overview This project analyzes real world food price data across 14 Nigerian states using data collected by the World Food Programme (WFP) and Food and Agriculture Organization (FAO). The analysis covers 60,816 price records across 38 food commodities from 2002 to 2026. ## Problem Statement Food insecurity remains a critical challenge in Nigeria. This analysis identifies the key supply chain factors driving food price volatility and unaffordability across Nigerian markets providing data driven insights for policy makers, humanitarian organizations and supply chain professionals. ## Tools Used - Microsoft Power BI — Dashboard building and visualization - MySQL — Data storage and querying - DAX — Calculated measures in Power BI - Data Source — WFP/FAO Nigeria Food Prices Dataset ## Dashboard Pages - Page 1 — Overview — national food price trends and key metrics - Page 2 — State Analysis — price comparison across 14 Nigerian states - Page 3 — Commodity Analysis — price volatility and commodity trends - Page 4 — Recommendations — key findings, recommendations, data limitations and data source. ## Key Findings - Nigerian food prices peaked in 2022 at ₦868 average per kg driven by global food crisis and Naira devaluation. - Three major price shocks identified :2016 recession, 2020 COVID-19 and 2022 global food crisis. - Borno and Yobe record highest food prices, conflict driven supply chain disruption is the primary cause. - Perishable commodities show highest price volatility due to poor cold chain infrastructure. - Imported commodities like milk powder and rice are consistently most expensive reflecting Nigeria's import dependency. - Jigawa is most affordable state due to strong local agricultural production and shorter supply chains. ## Recommendations - Invest in cold chain infrastructure to reduce perishable food price volatility. - Prioritize supply chain restoration in conflict affected North Eas …