top of page

120 Years of Olympic History - Excel Dashboard.

In this project, I felt inspired to face the challenge of creating an Excel-only dashboard. I decided to explore historical Olympic medal winners considering a number of variables including sex, location, and age. On Kaggle.com, I discovered a dataset that perfectly aligned with this criteria. From there, I developed the visuals in a way that was engaging, interactive, and clear, to discover insights into the 120 years' worth of data.

Raw Data

Content

The file athlete_events.csv contains 271116 rows and 15 columns. Each row corresponds to an individual athlete competing in an individual Olympic event (athlete-events).

 

The columns are:

  1. ID - Unique number for each athlete

  2. Name - Athlete's name

  3. Sex - M or F

  4. Age - Integer

  5. Height - In centimeters

  6. Weight - In kilograms

  7. Team - Team name

  8. NOC - National Olympic Committee 3-letter code

  9. Games - Year and season

  10. Year - Integer

  11. Season - Summer or Winter

  12. City - Host city

  13. Sport - Sport

  14. Event - Event

  15. Medal - Gold, Silver, Bronze, or NA

Data
Data

Inital design draft

Data
Data

Vlookup NOC by region name

Data
Data

Create Pivot Tables & Charts

Data

Group age category & modify pivots

Introduce global slicers

Dashboard
Dashboard
Dashboard
Female
Archery
Dashboard
My video walk through
bottom of page