courage-analytics-glitch/WDI_Digital_Economy_Ghana
Domain:
digital infrastructuresocioeconomicRecord type:
dataset
Creator:
cou
Host:
Comparative analysis of Ghana's digital economy vs regional peers using World Bank WDI data. Power BI dashboard + PDF report - AnalystLab Africa Batch B capstone
# Ghana's Digital Economy: A Comparative Analysis
Capstone project for the AnalystLab Africa Data Analytics Internship (Batch B, May-July 2026).
## Objective
Measure Ghana's digital economy against 5 regional peers using World Bank World Development Indicators (WDI) data, and identify where Ghana leads or lags on connectivity, digital finance, digital trade, and the relationship between infrastructure and adoption.
## Data Source
World Bank World Development Indicators (WDI), bulk CSV download: datatopics.worldbank.org
Raw files are not included in this repository due to file size. Download `WDI_CSV.zip` from the link above to reproduce.
## Indicators Used
- Individuals using the Internet (% of population)
- Mobile cellular subscriptions (per 100 people)
- Fixed broadband subscriptions (per 100 people)
- Secure Internet servers (per 1 million people)
- Account ownership at a financial institution or mobile-money-service provider (% age 15+)
- ICT service exports (% of service exports)
- GDP per capita (current US$)
- Population, total
## Countries Compared
Ghana, Nigeria, Kenya, Cote d'Ivoire, Senegal, South Africa, Sub-Saharan Africa (aggregate), World (aggregate).
## Repository Contents
- `WDI_Digital_Economy_Ghana.pbix` - Power BI dashboard file. Contains the full data cleaning pipeline (Power Query) and all DAX measures.
- `WDI_Digital_Economy_Ghana_Report.pdf` - full report: findings, correlation and trend analysis, dashboard documentation, insights, recommendations.
- `WDI_Digital_Economy_Cleaned.xlsx` - reference copy of the cleaned dataset.
- Dashboard screenshots.
- drive.google.com
## Data Cleaning (Power Query, inside the .pbix)
All cleaning was performed in Power BI's Power Query Editor, not in an external script:
- Filtered the WDI master CSV down to 10 target indicator codes.
- Unpivoted year columns into a Year/Value pair (wide to lon …