johnoe0710/nigeria-food-security-analytics

End-to-end data analytics project investigating regional contributions to food security in Nigeria using Python, SQL, SQLite, and Power BI. # Regional Contributions to Food Security in Nigeria **Data Analytics Portfolio Project** An end-to-end agricultural and food-security analytics project examining how production, regional patterns, trade exposure, food prices, and welfare indicators interact in Nigeria. ## Research Question > **What are the regional contributions to food security in Nigeria, and what structural factors drive food-security outcomes across production, trade, and welfare dimensions?** ## Project Overview The project integrates five major data domains: - Nigeria LSMS Wave 4 household/agricultural survey data - FAOSTAT crop production and food-balance data - UN Comtrade bilateral trade data - Nigeria retail food-price data - World Bank World Development Indicators The analytical workflow is: ```text Source Data ↓ Cleaning & Standardisation ↓ Cleaned Staging ↓ 15-Table SQLite Database ↓ 17 Analytical SQL Queries ↓ Power BI Dashboard ↓ Executive Reporting ``` ## Key Findings | Indicator | Project finding | |---|---| | Composite Food Security Score | 77.2 / 100 average, 2010–2023 | | National crop production | +45%, from 160 MT in 2010 to 232 MT in 2022 | | Caloric supply | 2,520 kcal/capita/day in 2022 | | Food import bill | USD 9.57 billion in 2022 | | Undernourishment | 18.7% in 2022; 19.9% latest WDI estimate used for 2023 | | Leading crop by household adoption | Maize, over 69,000 survey households | | Leading state in survey harvest volume | Kano, approximately 22 million kg | ### The food-security paradox The project observes a divergence between rising aggregate crop production and worsening undernourishment indicators. Production increased by approximately 45% between 2010 and 2022 while undernourishment increased from 10.4% in 2010 to 18.7% in 2022. The project interprets this divergence as evidence that food security cannot be assessed from aggregate production alone. Access, prices, trade exposure, distribution, and welfare conditions also require attention. This …