The primary goal is to enhance the usability of the dataset by cleaning the data and solving the following questions using MySQL:
- Analyze gender ratio in winning teams.
- Identify gender distribution in medals.
- Determine which country has won the maximum Olympic medals.
- Find the country with the minimum Olympic medals.
- Extract distinct events and their count information.
- Identify which city hosted the most Olympic Games year-wise.
- Discover the city that hosted the most events.
- Understand event variations based on Sport, Discipline, and Event.
- Find the athlete who has won the most medals during this period.
- Track which country has won the most medals in each year.
- Determine if any country has dominated a specific sport (e.g., Wrestling).
This dataset contains all medal winners in the Summer Olympics from 1976 (Montreal) to 2008 (Beijing). It includes every awarded medal within this period. The dataset is ideal for beginners who want to explore advanced Excel functions or use SQL for analysis. It can also serve as a basis for predictive modeling—such as forecasting which country is likely to secure the highest number of gold medals in a particular sport.
- City: Location of the Olympics.
- Year: The year of the event.
- Sport: The general sports category.
- Discipline: A subcategory within the sport.
- Event: Specific event within a discipline.
- Athlete: Name of the participant.
- Gender: Athlete's gender.
- Country_Code: Country abbreviation.
- Country: Full country name.
- Event_gender: Gender classification of the event.
- Medal: Type of medal won (Gold, Silver, Bronze).
- MySQL Workbench 8.0.41
- Data Analysis
- Data Cleaning
- Query Handling
- Download the dataset from the provided link.
- Import the dataset into MySQL Workbench.
- Run SQL queries to analyze various aspects of Olympic medals.
- Gain insights and visualize data for better understanding.
🚀 Happy Analyzing! If you have any questions or suggestions, feel free to contribute or reach out.