cheenasar/Nigeria-Food-Price-Analytics-Dashboard
Domaine:
agriculturesocioeconomicType de record:
project
Créateur:
che
Hôte:
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 …