Pyramid Explore #7 - Milano Cortina Edition - Challenge Detail
The Challenge
Weโre giving you access to Winter Olympics data โ medal counts, athlete stats, country performance, historical trends, host city details, and more. Your mission? Put your analytics skills to the test by creating reports and dashboards using the Pyramid platform to uncover trends, insights, and powerful stories hidden in the data.
From the slopes to the skating rink, thereโs a goldmine of insights waiting to be discovered.
What to Explore (just a few ideas!)
Medal trends over time โ which countries are rising or declining?
Country performance by sport โ who dominates the ice vs. the snow?
Breakout athlete performances or record-breaking moments
Host country impact โ does home advantage really exist?
Historical comparisons across decades
Any surprising patterns hidden in the numbers?
Get creative โ thereโs no single โrightโ answer. The most compelling insights and visually engaging dashboards will stand out.
Whether youโre a seasoned analytics champion or just warming up, this challenge is all about discovery, creativity, and a little friendly competition.
Ready to go for gold?
Let the analytics games begin โ and may the best dashboard win!
Drop a comment if youโre in, and keep an eye out for the dataset and submission details.
4 replies
-
You will find the model in the Explore Server. Create a report or dashboard and you should be able to see the IMDB below, ready for you to use. Have fun!
-
I have two comments on the data model:
- In pair competitions, e.g., in figure skating, two medals are awarded per pair, but these are only counted once in the medal table, as is the case with all other team competitions.
- In the data model, the join to the countries appears to be incorrect; winter sports nations such as Switzerland and Germany are not "matched." The total number of medals in this data set is 3,274, but if you add the countries in the query, the number drops to only 2,242.
- In pair competitions, e.g., in figure skating, two medals are awarded per pair, but these are only counted once in the medal table, as is the case with all other team competitions.
-
Hi , thanks for catching those!
What I found through my research is that for medal count, regardless of how many people won/did the event (individual v pair v team sport), it only counts as 1 medal for gold/silver/bronze for that country.
And big thanks for catching the error on the country - _I have now fixed it and the model now has more consistent data!-
- THANKS for the quick repair!
I don't want to be petty, but even though you figured out exactly what I was trying to express regarding the medal count, this aspect has not yet been corrected in the data model.
Example:
For Chamonix 1924, the data model still shows a total of 52 medals, although only 49 were actually awarded (16 events with 3 medals each + 1 x 2 bronze medals at speed skating). The three surplus medals result from the fact that the data model for pairs figure skating still shows 6 medals โ and not three, as would be correct. The names of the pairs athletes would have to be combined, as shown in my screenshot.
This applies not only to figure skating but also to (at least) ice dancing, which has been an Olympic sport since 1976. Incidentally, the figures for 2018 correctly count the pairs medals, so the names of the two athletes are not listed here, but rather a team name, such as "Canada 1."
Okay, although that probably doesn't skew the overall data set that much โ it shows about 100 too many medals โ I was being pretty petty after all. Sorry about that. I would call it data-driven.
-