steven2001-Analyst/Tanzania-Food-Prices-Analysis-Dashboard

# Tanzania Food Prices Analysis — Power BI Portfolio Project > An end-to-end data analytics project analyzing **World Food Programme (WFP) Food Price Database** data for the United Republic of Tanzania, built to showcase intermediate Power BI skills including star-schema modeling, DAX time intelligence, ranking measures, geographic visualization, and dashboard storytelling. # Project Screenshot --- ## Project Overview Food price volatility directly affects household food security, especially in developing economies where staples like maize, rice, and beans can consume a large share of household income. This project analyzes monthly wholesale and retail food prices across Tanzanian markets from **2006 onward**, sourced from the **World Food Programme (WFP) Price Database**, to uncover long-term trends, regional disparities, commodity volatility, and market anomalies. The deliverable is an interactive **Power BI dashboard** designed for analysts, policy reviewers, and food-security stakeholders who need a single view of price dynamics across the country. --- ## Business Problem Tanzania's food markets are geographically dispersed, with prices driven by rainfall, harvest cycles, transport costs, regional production, and cross-border trade. Decision-makers face three recurring questions: 1. **Where** are prices abnormally high or volatile? 2. **When** do price spikes typically occur, and are they worsening? 3. **What** commodities drive inflationary pressure on household food baskets? Without a consolidated analytics layer, these questions are answered ad-hoc in spreadsheets, leading to slow, inconsistent, and non-comparable answers across teams. This project closes that gap with a single, validated, well-modeled Power BI dataset and dashboard. --- ## Objectives | # | Objective | Success Indicator | |---|-----------|-------------------| | 1 | Build a clean, validated star-schema data model from raw WFP data | All fact-dimension relationships verified; r …