The Olympic Games - What factors impact on medal counts and which countries can we expect to do well in Paris 2024?
For this project, I created a Tableau storyboard which explores the medal tally of countries around the world since the year 2000, and how different geopoltical, social and economic factors can influence performance in the games. I then used the Tableau function MODEL_QUANTILE to experiment with predicting the likely range of medals each country will be awarded in the upcoming Paris 2024 games. 🔵 🟡 ⚫ 🟢 🔴
You can find the final storyboard here on Tableau Public!
If you enjoy the project please consider nominating it for Viz of the Day!
You can find the Tableau file and csv data files in this repo (zipped). To try out this viz for yourself simply download the files, save them all in one place and load up Tableau desktop. When you open the Tableau file you will be asked to reconnect to the datasources - just select the relevant file names when prompted.
All data files are .xslx or .csv
The PNG files for the images in the dashboard are also saved in the zip file.
- Limited analysis to show only Olympics held from the year 2000. This is because of changing geopolitics in the 1990s meaning a lot of historic countries no longer exist!
- Normalised a lot of the data to be per person/number of people, for example medals per 10M people or GDP per person. This is so population does not skew the analysis of the other factors.
- However this normalisation did come with some drawbacks, namely small countries and terrorories creating anomalous results. An example of this is San Marino, a nation taht has only won two medals since the year 2000, however because of its small population this is normalised to +100 medals per 10 M people per games - which is not sensible! Therefore the medals per 10M people measure has been capped at 20, where 98% of the results lie below.
- Aimed to put a lot of the detail in to the tooltips to keep the main visuals easy to read and tidy.
- Used the Tableau colour-blind friendly colour palette.
- Predicting the medal count per country using historic data about GDP, Population, Military Spending and Education Spending.
- The modelling does not take 2024 specific factors into account, e.g., France potentially gaining a host country advantage.
- Russia and Belarus are excluded from the modelling as athletes are banned from entering under either country's banner in Paris 2024.