This project analyses global development trends using the Gapminder dataset, focusing on the relationship between GDP per capita and life expectancy across countries and regions. The dashboard enables interactive exploration of socio-economic patterns over time.
Interactive Power BI dashboard analysing global GDP, life expectancy, population, and regional development trends using interactive visualisations to compare countries, identify patterns, and support data-driven insights into global economic and social development.
- Analyse the relationship between wealth and health outcomes
- Compare trends across countries and regions
- Build an interactive Power BI report for exploratory analysis
- Power BI
- Power Query (Data Transformation)
- Data Visualisation
- Basic DAX Measures
Gapminder Dataset
Includes:
- GDP per capita
- Life expectancy
- Population
- Country and region classifications
- Yearly data
Includes:
- Total Population = SUM(gapminder[population])
- Avg Life Expectancy = AVERAGE(gapminder[life])
- Avg GDP = AVERAGE(gapminder[GDP])
- Imported dataset into Power BI
- Cleaned and transformed data using Power Query
- Ensured correct data types, particularly for time-based fields
- Structured dataset for time-series analysis
- Created calculated measures where required
Scatter Plot:
- GDP per capita vs Life Expectancy
- Bubble size represents population
Line Charts:
- Trends over time
Slicers:
- Region
- Year
- Built an interactive and user-friendly layout
- Enabled filtering and drill-down capabilities
- Strong positive correlation between GDP per capita and life expectancy
- Significant disparities in development across regions
- Emerging economies show rapid improvement over time
- Demonstrates ability to analyse multi-dimensional datasets
- Highlights strong data storytelling and visualisation skills
- Supports understanding of global economic and health trends
- Handling skewed GDP data (log scale considerations)
- Designing clear and readable scatter plots
- Balancing multiple variables within a single visual
Delivered an interactive Power BI dashboard that effectively communicates global development patterns, showcasing analytical thinking and strong visualisation capabilities.