The purpose of this data analysis project is looking at the data set which has been taken from Kaggle entitled Summer Olympics Medals evaluated from 1976 to 2008 to answer some questions using Microsoft Power BI .
To look at specific results, on the left hand side for each page, there are some tools that can help to list values.
https://www.kaggle.com/datasets/divyansh22/summer-olympics-medals
Along the project, some questions were emerged, and they are listed below for each category.
- How many different cities are there in the data set?
- How many different sports are there in the data set?
- How many discipline are there in the data set?
- How many countries are there in the data set?
- How many medals are there in the data set (extract as silver, bronze, gold)
- How many gold medals are there?
- How many silver medals are there?
- How many bronze medals are there?
- How many women are there in the competition?
- How many men are there in the competition?
- Which top countries had how many gold, silver, and bronze medals as Total according to selections?
- Which top athletes had how many gold, silver, and bronze medals as Total according to selections?
- Which low athletes had how many gold, silver, and bronze medals as Total according to selections?
- Add a trend line to show total medals (in all types) over the years.
- Add a stack bar to show all medal types separately in terms of Countries.
- In which sport the most gold medals were collected?
- In which sport the most silver medals were collected?
- In which sport the most bronze medals were collected?
- Who was the most loaded athlete to collect medals?
- Add a table to show each year and each discipline as a general view and underneath of them, show each athlete's performance.
- When a city clicked on main page, show the exact location on a map.
- When a country is clicked on athletes' name, show the exact location on a map.
- Use bar chart to compare gender numbers.
- Use bar chart to compare medal types.
- Add date as a slicer to determine the range.
- Add city as a slicer to determine the city.
- Add discipline as a slicer to determine the discipline.
- Add a table to show each athletes' total gold, silver and bronze medals
- Use pie chart to compare gender numbers.
- Add a table to show each countries' total gold, silver and bronze medals.
This primary page shows the answers of Categorization / Main that are simply visualized below.
For the questions, click the link below:
This page shows the answers of Distributions and some of the distributions in Gender and Total Medal types.
For the questions, click the link below:
This page shows the tasks of Yearly Distributions in terms of Countries and general outline.
For the tasks, click the link below:
This page shows the answers of Comparisons.
For the questions, click the link below:
