Olympics Data Analysis
This project involves analyzing historical data from the Olympic Games to uncover various insights, such as the number of games held, participating nations, top-performing athletes and countries, and much more.
Table of Contents
Project Overview
The goal of this project is to analyze data from past Olympic Games to answer key questions about participation, performance, and trends. This analysis is conducted using SQL queries to extract valuable insights from the dataset.
Dataset Description
The dataset used in this project contains information on the following:
Olympic Games: Year, Season (Summer/Winter), City, and Country.
Athletes: Name, Gender, Age, Country, Sport, and Event.
Medals: Type (Gold, Silver, Bronze), Athlete, Country, Sport, and Event.
Participating Nations: List of countries that participated in each Olympic Games.
The dataset is assumed to be stored in a relational database with the following tables:
olympic_games
athletes
medals
events
Analysis Questions
The following are the key questions addressed in this project:
How many Olympic Games have been held?
List all Olympic Games held so far.
Total number of nations that participated in each Olympic Game.
Which year saw the highest and lowest number of countries participating in the Olympics?
Which nation has participated in all of the Olympic Games?
Identify the sport that was played in all Summer Olympics.
Which sports were played only once in the Olympics?
Fetch the total number of sports played in each Olympic Game.
Fetch details of the oldest athlete to win a gold medal.
Find the ratio of male to female athletes who participated in all Olympic Games.
Fetch the top 5 athletes who have won the most gold medals.
Fetch the top 5 athletes who have won the most medals (gold/silver/bronze).
Fetch the top 5 most successful countries in the Olympics. Success is defined by the number of medals won.
List total gold, silver, and bronze medals won by each country.
List total gold, silver, and bronze medals won by each country corresponding to each Olympic Game.
Identify which country won the most gold, most silver, and most bronze medals in each Olympic Game.
Identify which country won the most gold, most silver, most bronze medals, and the most medals in each Olympic Game.
Which countries have never won a gold medal but have won silver/bronze medals?
In which sport/event has India won the most medals?
Break down all Olympic Games where India won a medal for Hockey and how many medals in each Olympic Game.
Setup and Installation
To run the analysis, follow these steps:
Clone the repository: git clone https://github.com/Boluyimika/olympics-data-analysis.git cd olympics-data-analysis
Contribution
Contributions are welcome! If you have any suggestions or improvements, please submit a pull request or open an issue.
License
This project is licensed under the MIT License - see the LICENSE file for details.
