Introduction
Apologies for the late challenge this week but we are sticking with the Olympic theme, this week we are building the Olympic Medal Table. I wanted to replicate as close as possible the medal table from this website.
Note: The data for China is Incorrect but this is based off of the source I got the data from.
Requirements
- Dashboard Size 1000 x 800
- Max 3 worksheets
- Create a Table shows the total medal count for each country, with the ability to drill down into each of the disciplines, followed by a tooltip of each athlete.
- Country Flag can be created using this URL: https://gstatic.olympics.com/s1/t_original/static/noc/oly/3×2/180×120/[Country Code].png
- Medals Image can use the following calculation:
- IF [Medals] = “Gold Medal” THEN “https://gstatic.olympics.com/s1/t_original/static/srm/paris-2024/medalGold_selected.svg”
ELSEIF [Medals] = “Silver Medal” THEN “https://gstatic.olympics.com/s1/t_original/static/srm/paris-2024/medalSilver.svg”
ELSEIF [Medals]= “Bronze Medal” THEN “https://gstatic.olympics.com/s1/t_original/static/srm/paris-2024/medalBronze.svg”
ELSE ‘https://gstatic.olympics.com/s1/t_original/static/srm/paris-2024/medalAll.svg’ END
- IF [Medals] = “Gold Medal” THEN “https://gstatic.olympics.com/s1/t_original/static/srm/paris-2024/medalGold_selected.svg”
Dataset
This week uses data from Kaggle about the olympic medals, you will need the Medals Total and Medalists csvs. These can be accessed here.
Attribute
When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration. Also include the hashtag #WOW2024 in your description to make it searchable!
![](https://workout-wednesday.com/wp-content/uploads/2024/01/Screenshot-2024-01-16-at-12.48.56.png)
Share
After you finish your workout, share on Twitter and/or LinkedIn using the hashtag #WOW2024 #Tableau and tag @WorkoutWednsday