Exploring Eurovision with SAP Lumira2

Father forgive me as it has been about 2 years since my last confession.

Confession via facebok

Well not exactly but it has been some time since my last blog.  Since joining SAP it has been full on and now I’m back in the Analytics world and can lift my head up and get back to the Blog.

Those of you in Europe will know this weekend is the annual spectacle that is Eurovision.

https://eurovision.tv/

This year’s Eurovision Song Contest will be 62nd edition of the Eurovision Song Contest and it is taking place in Kiev, Ukraine.

What is Eurovision?

The Eurovision Song Contest started in 1956 is the longest-running annual international TV singing competition.  It is held primarily among the member countries of the European Union and was based upon the existing Sanremo Music Festival held in Italy since 1951.

Each participating country submits an original song that is performed live on television & radio and then countries casts votes for the other countries’ songs to determine the most popular song in the competition.

The contest is one of the longest-running television programmes in the world and is also one of the most watched non-sporting events in the world (audience figures having been quoted in recent years as anything between 100 million and 600 million internationally)

Why am I interested?

I am always looking out for fun data sets to explore and when I saw in the TV listings that is was Eurovision this weekend I went on the hunt for a data set.  Needless to say, there are data sets out there but they are on an annual basis.  So, after bribing my teenage son to copy and paste from a web page 61 times I have a dataset.

What did I find when looking at the data?

Well surprisingly I found out that the UK are really not that bad.

My recent memory was that we aren’t that great this can be seen in the decline in placing since the late 1990’s.Screen Shot 2017-05-11 at 19.43.31

How did I find this out?

I used a beta release of SAP Lumira 2 to visualise the data.and asked the usual questions, Which country has won the most times?  Which country has been placed 2nd the most times?

As I went through I spotted the UK was on the positive side of the rankings every time!

Conclusion

The UK really aren’t that bad at Eurovision.

How did I come to this conclusion?

Screen Shot 2017-05-11 at 19.14.43Screen Shot 2017-05-11 at 19.14.57Screen Shot 2017-05-11 at 19.15.06Screen Shot 2017-05-11 at 19.15.16Screen Shot 2017-05-11 at 19.15.30

Screen Shot 2017-05-11 at 20.16.32