Use SAP Lumira Desktop to compare soccer data of the top 5 European soccer leagues for seasons from 1993 until 2013


The following blog post shows the try to get some insights of the similarities and differences of some top European national soccer leagues:

  • Does the data support some common assumptions (in regards to home strength, high number of goals per match, increased match draws etc.)?
  • Or, in contrast to it, is the assumption somehow challenged by the analysis results?

I will show a few charts for different questions which came into my mind.


The tool for the analysis is SAP Lumira Desktop version 1.20. The data consists of match results for the seasons from 1993/1994 to 2013/2014 for the top leagues in Germany (“1.Bundesliga” – D1), England (“Premier League” – E0), Italy (“Serie A” – I1), France (“Ligue 1” – F1), and Spain (“Primera Division” – SP1).[1]

The data has been extracted with an Excel file for each season consisting of various sheets for the different countries and leagues. Each sheet contained date, home/away team, and the goals scored. This is how the raw data looked like:

/wp-content/uploads/2014/12/2014_12_05_151354_602697.png

The Excel files and sheet have been combined manually to one big Excel sheet containing all the necessary data for further analysis within SAP Lumira.


Question 1: How did develop and compare the average goals per match by season and by league for the last 20 years?

lum_01_avg goals per match.png

The line chart shows that goals/match really varies season by season but nevertheless the German Bundesliga always scores the highest average and the French Ligue 1 always the lowest. Actually, this result didn’t surprised me I was always convinced of the German soccer attitude that a 5:4 is appreciated more than a 1:0 😉


Question 2: How do compare number of Home wins vs. Away wins vs. Draws between the different leagues for the last 20 years?

lum_02_home-draw-away by league_2.png

Unfortunately I didn’t get it to work that the bar chart shows the percentage distribution by each league, so I just normalized the size of the bars by using the settings. Anyway, although there were different number of matches per league it is still obvious that roughly the distribution between the leagues is quiet similar. Actually, this surprised me a lot.


Question 3: How did develop Home wins vs. Away wins vs. Draws in total for all leagues by season?

lum_03_home-draw-away by season.png

Here you can see that the number of Home wins is quiet stable whereas the number of Draws steadily decreases in favour of Away wins.



Question 4: Which are the top 5 results for all leagues during the last 20 years?

lum_04_top 5 results.png

Pretty interesting and intuitive chart, isn’t it?! Bet on a 1:1 draw and you right in more than 12% of the cases 😉 Unfortunately, this chart is a little fake by using custom grouping in the preparation room because currently Lumira doesn’t calculate an “Others” pie piece.

Lumira_Pie_Chart.png


Unfortunately I could not spend some more time on further questions and a nice Lumira story, especially to show some more comparison charts between the leagues. Maybe I will dig deeper into the data and get some more nice charts and answers 😉 In case you have some interesting question just let me know…


[1] Data has been downloaded from Football-Data.co.uk

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply