Solutions to “Just KNIME It!” Challenge 18 - Season 4

:sun_with_face: New Wednesday, new Just KNIME It! challenge! :sunny:

:microphone: Eurovision is full of surprises—not just in performances but also in how different countries score. A song might be a fan favorite with high televote support yet receive low jury points, or certain musical styles might consistently have higher energy levels than others. In this week’s challenge, you’ll explore key aspects of Eurovision scoring and song characteristics using KNIME. Among all songs that qualified for the final, which style has the highest average BPM? :dancer:

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 JKISeason4-18 .

:sos: Need help with tags? To add tag JKISeason4-18 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. :blush: Let us know if you have any problems!

1 Like

Real nice challenge! I checked the two songs and I really liked KEiiNO - Spirit In The Sky :smiley: My solution to the challenge:

I kept it simple:

  • Downloaded the CSV from the HUB
  • Calculate the GAP and keep just the first row
  • Keep just the biggest average BPM
  • Visualize the two songs details

I really like the versatility these challenges, every week something new :slight_smile:

6 Likes

Find my submission for the Eurovision song challenge : https://hub.knime.com/s/bU8ir-pBk4w8O6CH

3 Likes

4 Likes

Hi all,

Here is my solution: https://hub.knime.com/s/lXkNt8fNTXlXyM2_

3 Likes

Here’s my solution. Analyzed annually rather than aggregating everything. I excluded 2013 since it had very incomplete data.

2 Likes

It’s nice to get a decent challenge that keeps things simple when I compare to last week’s challenge :grinning_face:

Here is my solution:

JKISeason4-18

Looks like Norway takes the lead and Pop has the highest average BPM.

Cheers

2 Likes

:globe_showing_europe_africa: Eurovision Insights – Challenge 18

For this week’s challenge, I wanted to keep things structured and clear while still leaving room for a bit of playful discovery :musical_notes:.

My solution to JKI4-18

:small_blue_diamond: Step 1 – Data preparation
Imported the dataset, converted key columns to numeric, and made sure dates and numbers behaved properly (because nothing ruins a party like misbehaving data :man_dancing:) corrected some wrong qualified_10 missing (thanks Maneskin for reminding me your victory).

:small_blue_diamond: Step 2 – Biggest televote vs. jury gap
Calculated the difference between final_televote_points and final_jury_points. After sorting, the country with the widest/lowest gap stood out clearly — proving once again that the jury and the public don’t always listen to the same tune. :microphone:

:small_blue_diamond: Step 3 – BPM insights for finalists
Filtered for qualified_10 = 1, grouped by style, and computed average BPM. This revealed which style keeps the tempo the highest when it matters most. Let’s just say… some genres really know how to keep the audience on their feet :woman_dancing:.

:small_blue_diamond: Step 4 – Visual storytelling
Wrapped everything into a component with tables and bar charts, so results are easy to explore. I also added some extra KPIs (like average televote/jury scores per country, and distributions of BPM by style) for more context.

:sparkles: Takeaway
The exercise was a great reminder that Eurovision isn’t only about the music on stage, but also about the fascinating dynamics behind the numbers.


Looking forward to hearing how others approached this — I’m sure there are some creative “remixes” out there! :musical_notes::bar_chart:

1 Like

:sun_with_face: Our solution to last week’s JustKNIMEIt challenge is out!

:microphone: We loved the unique spins our community added to their own solutions, with users implementing their filtering techniques to get to the highest scoring song and genre in different ways. :woman_dancing:

:video_game: Join us tomorrow for a challenge that combines our beloved Pokémon with database management and API handling. :left_right_arrow: And by the way: this challenge is courtesy of our amazing Just KNIME It! KNinja @KNIMEST!