Sophia-stack446/Capsule-Project-at-AnalystLab-Africa-Internship-programme

Africa GDP and Economic Performance Dashboard # Capsule-Project-at-AnalystLab-Africa-Internship-programme Africa GDP & Economic Performance Dashboard Data Analytics Capstone Project — AnalystLab Africa Internship (Batch B, June–August 2026) Project Overview This project analyzes GDP growth and economic performance across 53 African countries from 2000 to 2023, using the World Bank’s World Development Indicators (WDI) dataset. It follows a full data analytics workflow: data cleaning, exploratory analysis, and an interactive Power BI dashboard. Objective To identify trends, disparities, and key economic indicators (GDP growth, GDP per capita, inflation, unemployment) across African economies, and translate the findings into insights and recommendations for stakeholders. Data Source • World Development Indicators (WDI), World Bank datatopics.worldbank.org • Files used: WDICSV.csv (main indicator data), WDICountry.csv (country/region metadata) Project Workflow 1. Data Cleaning (Google Colab / Python / pandas) • Filtered to 53 African countries (Sub-Saharan Africa + Algeria, Egypt, Libya, Morocco, Tunisia) • Narrowed to 8 GDP/economic indicators • Reshaped data from wide to long format • Identified heavy missingness pre-2000 and trimmed the dataset to 2000–2023 • Interpolated remaining missing values within each country-indicator series (4.5% → 1.4% missing) • Verified no duplicate records • Exported cleaned data to CSV 2. Dashboard (Power BI) • KPI cards: Average GDP Growth, GDP per Capita, Inflation, Unemployment • Trend line: GDP growth over time (2000–2023) • Bar chart: GDP growth by country (2023) • Filled map: GDP per capita by country • Interactive slicers: Country, Year Tools Used • Python (pandas) — data cleaning, Google Colab • Power BI Desktop — dashboard and visualization • World Bank WDI — data source Author Sophia — Data Analytics Intern, AnalystLab Africa (Batch B) Acknowledgment This project was completed as part of the AnalystLab Africa Data Analytics Internshi …