<aside> <img src="/icons/info-alternate_gray.svg" alt="/icons/info-alternate_gray.svg" width="40px" />

• Title: Understanding the Athlete Participation & Medal Needs for 2028 and 2036 Summer Olympics
• Author: Aaron A. P.
• Last Update: Aug 17, 2025 </aside>

Objective

Use historical Olympic data available online (1986-2020) to showcase the athlete participation, gender distribution, event count, and medal requirements for the upcoming Summer Olympics in 2028 and 2032.

Data Source

• Dataset: Kaggle - 126 Years of Historical Olympic Dataset
• Scope: Summer Olympics only (1896-2020)
• Key Variables:
  • Athletes_bio: AthleteID, Sex
  • Event_details: Country, Event, Sport, Edition, Medal, IsTeamSport

Methodology

The analysis was applied over a dataset of the Summer Olympics Editions from 1896 to 2020. The data cleaning was made exclusively in Excel using a combination of its native functions. The visualizations were made in Tableau, and the dashboard can be reviewed for free use and consultation here.

Data Cleaning

• Removed possible duplicate rows in both tables, the Athletes_bio and Event_details.
• Removal of non-relevant columns:
  • The redundan columns were removed, for example, the columns containing athlete_name and athleteID in the Event_details table were redundant, leaving only ID for the table's relationship.
  • Columns with notes and descriptions were removed.
• Filtered using Edition to include only the Summer Olympic Games.
• Filtered only Athletes with at least one registered participation in any of the events.

Data Preparation

The data preparation starts after the data cleaning process. In this step the data gets imported into Tableau and the aggregation variables are created to make easy the data visualization in further steps and for optimization reasons.

• Aggregation variables created in Tableau: TotalEvents, TotalIndividualEvents, and TotalTeamEvents, EditionYear.

Visualizations