Data analytics · Python · World Bank API · Power BI

Nigeria at 66 — a World Bank data story in Python and Power BI

An end-to-end analytics project: a Python extractor pulls seven World Bank indicators for Nigeria and three peer countries, pandas validates and reshapes them, and a single-page Power BI report tells the story of 66 years since independence.

StackPython · requests · pandas · Jupyter · Power BI
DataWorld Bank Open Data API, 7 indicators × 4 countries
Output1,848-row Power BI-ready dataset and a .pbix report
StatusCompleted portfolio analysis (October 2026)
Nigeria at 66 Power BI dashboard: KPI cards for population 237.53M, GDP 290.79bn, GDP per capita 1.22K, life expectancy 54.6 and internet users 41.2, a 1960 to 2025 trend line, a GDP per capita peer comparison with South Africa, Ghana, Kenya and Nigeria, and a short commentary
The Power BI report, from the repository image. Source: World Bank Open Data; latest observations 2024–2025.

Problem

Headline figures about a country’s growth are easy to quote and easy to misread. The question here was how Nigeria has changed since 1960 across population, the economy and quality of life, and whether economic scale has translated into better outcomes per person, presented so a non-technical reader can follow it in one page.

Solution and architecture

World Bank API (v2, JSON)
      ↓  src/fetch_world_bank.py  (requests, retries with back-off)
Raw CSV  data/raw/world_bank_indicators.csv
      ↓  pandas validation and reshaping (Jupyter)
Power BI-ready CSV  data/processed/nigeria_at_66_powerbi.csv
      ↓
Power BI single-page report  dashboard/naija_powerbi.pbix

The extractor requests each indicator per country for 1960–2026, retries failed calls up to three times with increasing waits, and writes tidy rows of country, year, indicator and value. The processed file adds a Nigeria flag and a decade field for the report.

Technologies

Python (requests, pandas), Jupyter for exploration, Power BI for modelling, KPI cards, an indicator slicer and a peer benchmark, and Git for version control.

Results

Nigeria: first and latest observations in the dataset
IndicatorEarliestLatest
Population45.1M (1960)237.5M (2025)
GDP, current US$$4.2bn (1960)$290.8bn (2025)
GDP per capita, current US$$93 (1960)$1,224 (2025)
Life expectancy37.2 years (1960)54.6 years (2024)
Internet users≈0% (1990)41.2% (2024)
Inflation5.4% (1960)23.0% (2025)

Population grew by roughly 427% and life expectancy rose by about 17.4 years. The GDP per capita comparison with Ghana, Kenya and South Africa shows why national economic scale and individual economic outcomes should not be treated as the same thing.

Limitations

  • GDP figures are in current US dollars, so they are affected by inflation, exchange rates and data revisions; they are not measures of real growth on their own.
  • The latest available year differs by indicator (mostly 2024–2025).
  • Missing observations were kept as missing rather than imputed.

What this project demonstrates

  • API integration: resilient extraction from a public REST API.
  • Data preparation: validation and reshaping into a BI-friendly long format.
  • Power BI storytelling: a single executive page with KPIs, trend, slicer and peer view.
  • Analytical honesty: explicit caveats on nominal values and data coverage.

Written by Emmanuel Abolade, Data Analyst, Business Intelligence Developer and Full-Stack Software Developer based in Hull, UK. Every figure on this page comes from the linked public repository or live demo.