Olympic Games Analysis Project
Business Problem
“As a data analyst working at a news company you are asked to visualize data that will help readers understand how countries have performed historically in the summer Olympic Games.
You also know that there is an interest in details about the competitors, so if you find anything interesting then don’t hesitate to bring that in also.
The main task is still to show historical performance for different countries, with the possibility to select your own country.”
Data Collection and Table Structures.
The necessary data was first put into a SQL database and afterward transformed using the transformation that you can see below
Transformation in Power Query
This is a view where Power BI was Connected to the SQL database and loaded the data in power query to do these further transformations.
That is, split the Games column into Year and Season, filtered the season column to only Summer, and removed columns that won’t be needed in building the report.
Data Model
As this is a view where dimensions and facts have been combined, the data model that is created in Power BI is one table. The query from the previous step was loaded directly.
Calculations
The following calculations were created in the Power BI report using DAX (Data Analysis Expression).
Number of Competitors
# of Competitors = DISTINCTCOUNT(‘Olympic Games Data’[ID])
Number of Medals
# of Medals =
CALCULATE (COUNTROWS ( ‘Olympic Games Data’ ),
FILTER (‘Olympic Games Data’, ‘Olympic Games Data’[Medal] IN {“Bronze”, “Gold”, “Silver”} ))
Number of Countries
# of Countries = DISTINCTCOUNT(‘Olympic Games Data’[Nation Code])
Number of Sports
# of Sports = DISTINCTCOUNT(‘Olympic Games Data’[Sport])
Olympic Games Analysis
The finished dashboard consists of visualizations and filters that give an easy option for the end-users to navigate the summer games through history. Some possibilities are to filter by period using year, a nation code to focus on one country, competitor, or sports over time.
Click on the link below to have an interactive version of the report