- Excel File Link: https://docs.google.com/spreadsheets/d/15k74L1s9rXWtwJrsU32Bfo9-561LN0qb/edit?usp=drivesdk&ouid=103214557259220708096&rtpof=true&sd=true
The dataset used in this project, titled "120 years of Olympic history: athletes and results," was obtained from Kaggle. [https://www.kaggle.com/datasets/heesoo37/120-years-of-olympic-history-athletes-and-results]. It comprises information spanning 120 years of Olympic history, including details on athletes, their performances, participating countries, and more. The dataset is provided in CSV format and consists of two main subsets:
- Athlete Data (Data Set 1): Contains information about individual athletes participating in the Olympics. Attributes include ID, name, sex, age, height, weight, team, NOC (National Olympic Committee), games, year, season, city, sport, event, and medal won.
- Noc Country Data (Data Set 2): Provides details about countries and regions participating in the Olympics. Attributes include NOC (National Olympic Committee), region (country/place name), and notes.
| Files | Description |
|---|---|
| Raw Data | This folder houses a comprehensive collection of Olympics raw data sourced from Kaggle. |
| Cleaned Data | This folder houses a comprehensive collection of Olympics cleaned data. |
| Data Ditionary | This folder houses Olympics data set detailed description. |
| Dashboard Images | Contains Dashboard images. |
| [Excel Dashboard File Link] | https://docs.google.com/spreadsheets/d/15k74L1s9rXWtwJrsU32Bfo9-561LN0qb/edit?usp=drivesdk&ouid=103214557259220708096&rtpof=true&sd=true |
| README.md | This is the Readme file of the project. |
The project aims to leverage Excel's powerful features, such as pivot tables and a variety of charting tools, to conduct a thorough analysis of a comprehensive dataset encompassing 120 years of Olympic history. Through the strategic use of pivot tables, we intend to delve into diverse aspects including demographic trends, country-specific performances, and athlete characteristics. By employing a range of Excel chart types including bar graphs, line charts, and scatter plots, the objective is to visually depict these insights effectively. Additionally, Excel's extensive array of functions will facilitate the calculation of metrics such as medal success rates, athlete demographics, and longitudinal trends. Through the utilization of these Excel tools and functions, the project endeavors to provide detailed and insightful analyses of Olympic participation and performance dynamics.
- The dashboard provides insights into the demographics of Olympic participants, highlighting trends and patterns across different attributes such as age, gender, and nationality.
- Analysis of countries' performances reveals dominant nations across various Olympic editions and sports categories.
- Identification of top-performing athletes sheds light on individual achievements and contributions to their respective sports.
- The male vs. female performance ratio offers insights into gender dynamics in Olympic medal victories.
- Analysis of popular sports and their participation rates provides valuable information for sports organizations and policymakers.
- Exploring relationships between medal victory and athletes' age, height, and weight helps understand performance dynamics and trends.
- Visualization of countries' performance trends over the years aids in understanding the evolution of Olympic competitions.
- Comparison of countries' performances in Summer and Winter Olympics highlights seasonal variations in sporting achievements.
- Understanding the relationship between medal victory and athletes' weight and height provides insights into physical attributes influencing performance.
- The player participation index of host countries offers insights into the hosting impact on local sports participation.
- Visualization of dominant countries using a world map enhances geographical understanding of Olympic achievements.
- Displaying top Olympic players overall and top-performing nations provides a comprehensive view of historical achievements in Olympic sports.