orkhan-sari/ssa_dashboard

Sub-Saharan Africa: Food Security, Poverty & Growth Dashboard # Sub-Saharan Africa: Food Security, Poverty & Growth Dashboard An interactive Excel dashboard exploring the relationship between economic growth, food security, and poverty across Sub-Saharan African countries (2000–2024), built to demonstrate data cleaning, data modeling, and dashboard design skills in Excel. --- ## 📌 Project Overview This project combines three publicly available datasets — **FAOSTAT** food security indicators and **World Bank World Development Indicators (WDI)**, and ** World Bank Poverty and Inequality** indicators — into a single, clean, analysis-ready dataset for Sub-Saharan African countries. The result is an interactive Excel dashboard that lets a user select a country via a slicer and compare GDP, food security, and poverty trends over time. The project was built to showcase practical Excel skills relevant to data analyst roles: data cleaning, merging multi-source data, Pivot Tables, Power Query and dashboard/report design. --- ## 🎯 Objectives - Combine three real-world, publicly available datasets - Build pivot tables to summarize and explore the merged data - Design an interactive dashboard with country slicers to compare development and food security trends over time --- ## 🗂️ Data Sources | Source | Content | Link | |---|---|---| | FAOSTAT | Suite of Food Security Indicators | fao.org | | World Bank WDI | GDP (constant 2015 US$) | databank.worldbank.org | | World Bank Poverty and Inequality | poverty headcount ratio, poverty gap, poverty severity, and GINI index | pip.worldbank.org | **Scope:** Sub-Saharan African countries, 2000–2024 --- ## 🧹 Data Cleaning Process Raw data from all three sources required cleaning before they could be merged and analyzed. Key steps included: - Standardizing country names to enable joining across sources - Reshaping data between wide and long formats - Handling missing values and inconsistent year coverage - Removing duplicate records - Converting the cleaned dataset into a str …