TheOrthman/nigeria-food-prices

# Nigeria Food Price Analytics Pipeline **Stack**: dbt 1.8, Snowflake, SQL, Power BI, WFP + CBN Data End-to-end analytics engineering project processing 20+ years of humanitarian food price data across North East Nigeria. ## Dashboard Preview ### 1. Executive Summary ### 2. Commodity Analysis ### 3. FX Impact **Download**: Nigeria_Food_Prices.pbix *Requires Power BI Desktop - free download here* ## Architecture ## Key Features - **Ingestion**: WFP price data + CBN FX rates as dbt seeds - **Transformation**: 4-layer dbt project: seeds → staging → facts → marts - **Quality**: 9 dbt data tests, 100% pass rate - **Modeling**: Monthly state-level aggregates with USD conversion - **BI**: Interactive 3-page Power BI dashboard with YoY inflation tracking ## Results - **87,646** price observations processed - **14** states, **43** commodities tracked - **2002-2026** coverage with FX-adjusted USD pricing - YoY inflation calculation + food vs fuel correlation ## Run Locally ```bash # Install dbt pip install dbt-snowflake==1.8.0 # Run pipeline dbt deps dbt seed dbt run dbt test # Generate docs dbt docs generate dbt docs serve #Data Sources WFP: World Food Programme - North East Nigeria Food Prices CBN: Central Bank of Nigeria - Official FX Rates