An interactive Power BI dashboard project focused on analyzing historical Olympic Games data from 1896 to 2016. This project transforms raw Olympic athlete data into meaningful visual insights related to participation, medals, countries, sports, and athlete demographics.
The Olympic Games have evolved significantly over the years in terms of participation, competitiveness, and inclusivity. The aim of this project is to analyze historical Olympic data and identify important trends and patterns using data visualization techniques.
This dashboard helps users explore:
- Athlete participation trends
- Medal distribution across sports and countries
- Gender participation growth
- Athlete characteristics such as age, height, and weight
- Seasonal Olympic participation
To analyze Olympic Games data and create an interactive dashboard that provides insights into athlete participation, medal performance, country dominance, and demographic trends from 1896 to 2016.
- Power BI Desktop
- Power Query
- DAX (Data Analysis Expressions)
- CSV Dataset
- Data Visualization Techniques
Dataset Source: Kaggle – 120 Years of Olympic History: Athletes and Results
Dataset includes:
- Athlete details
- Country information
- Sports and events
- Medal records
- Olympic years and seasons
The ETL process was performed inside Power BI using Power Query.
- Removed null values
- Removed duplicate records
- Corrected data types
- Standardized gender values
- Replaced missing medals with "No Medal"
Displays:
- Total Athletes
- Total Medals
- Gold Medals
- Total Countries
- Average Age
- Average Height
- Average Weight
A line chart showing athlete participation growth over time.
Olympic participation increased rapidly after 1950.
Stacked bar chart comparing Gold, Silver, and Bronze medals across sports.
Athletics and Swimming have the highest medal counts.
Bar chart representing countries with highest Olympic success.
United States dominates Olympic medal counts.
Stacked column chart showing male and female participation trends.
Female participation has increased steadily over time.
Scatter plot representing athlete age and weight distribution.
Most athletes fall in the 20–30 age group.
Donut chart comparing Summer and Winter Olympics participation.
Summer Olympics account for the majority of participation.
DAX Total Athletes = DISTINCTCOUNT(athlete_events[ID])
Total Medals = CALCULATE( COUNTROWS(athlete_events), athlete_events[Medal] <> "No Medal" )
Avg Age = AVERAGE(athlete_events[Age])