#WOW2024 | Week 33 | Can you build the Olympic Medals Table?

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

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!

After you finish your workout, share on Twitter and/or LinkedIn using the hashtag #WOW2024 #Tableau and tag @WorkoutWednsday

Solution

Watch

Read