Another Wednesday, another Just KNIME It! challenge! This week is especially “game-y” too, since the 2024 Summer Olympics start this Friday in Paris!
To celebrate it and get in the right mood for the Games, how about some data-driven Olympic trivia?
Here is the challenge. Let’s use this thread to post our solutions to it, which should be uploaded to your public KNIME Hub spaces with tag JKISeason3-11.
Need help with tags? To add tag JKISeason3-11 to your workflow, go to the description panel in KNIME Analytics Platform, click the pencil to edit it, and you will see the option for adding tags right there. Let us know if you have any problems!
Here’s my solution. I intentionally did not update countries whose names have changed on the grounds that the original country won the medals at the time of the games.
Tonight, Jakarta time, I have completed version 1.0 of my solution for the JKISeason3-11 challenge. You can access the solution through this link, JKISeason3-11 arief_rama – KNIME Community Hub
Here is my submission for this challenge. It actually requires a simple approach, but I wanted to challenge myself to create a dynamic dashboard. I’ve been inspired by @skybe077 submission on Challenge 6. Learning by doing is a must!
The trivia questions can be answered using the nodes marked in green. The remaining nodes are for the dynamic dashboard. There are many surprises during exploring the data. Finally I can provide to you my works
In the first question, I tabulated the data into two categories: NOC and region. The aggregation results for the regions were visualized on a Choropleth Map.
olympictriviapart3 – KNIME Community Hub
I found the oldest medal winner in the Olympics was Charles Jacob, and the other two persons were female. , found the images from the Olympic data and downloaded them.
Interesting! I would personally consider both as the same, and preprocess the data to handle it by replacing, e.g., SGP with SIN. @michele_bassa Any suggestions here, as the author of this challenge?
Singapore has two different codes, each representing a different meaning:
SIN:
SIN is the IATA three-letter code for Singapore Changi International Airport. IATA codes are commonly used for communication between airlines and airports in flight identification and reservation systems. Changi Airport is the main international airport of Singapore and one of the busiest airports in the world.
SGP:
SGP is the ISO 3166-1 alpha-3 country code for Singapore. ISO 3166-1 is an international standard that defines a set of codes for every country and region in the world. SGP is used in various international contexts, such as sports events (like the Olympics), international trade documents, internet domain names, geostatistics, etc.
To summarize:
SIN is mainly used in the aviation industry, specifically referring to Changi International Airport.
SGP is used to represent the country of Singapore itself and is used in various international settings.
PS：The original dataset provided on Kaggle also has this problem, but the data provider has not corrected it either.
Hello everyone,
My workflow is similar to @RBre’s using heatmap to get an overview of the years in which each sport was held. The first year was marked in dark red. Thanks.
Another Wednesday, another Just KNIME It! challenge! 
in Paris! 
To celebrate it and get in the right mood for the Games, how about some data-driven Olympic trivia? 
Need help with tags? To add tag JKISeason3-11 to your workflow, go to the description panel in KNIME Analytics Platform, click the pencil to edit it, and you will see the option for adding tags right there. 
Let us know if you have any problems!
.
