Hello!
On this post we are going to check on another football dashboard, but this time featuring the german football league: Bundesliga!
For this analysis we have a long time range, with data from 1993 to 2018, but a shorter number of columns to analyze, being them:
- Date and Season
- Games: Home Team and Away Team
- Scores: Goals from home, goals from away, game winner (Home, Away or Draw)
Tools used: MS Excel – Charts, Pivot Table
Analyzing the mistakes
Before Q&A, we should take a look at the mistakes I made when creating this board.
As it was one of my first works, I wasn’t aware of the impact of good color and chart type choices. I committed to a theme (the german flag) and ended up making the board a bit too strong.
Notes to remember when you want to create a thematic board:
- It’s ok to follow your theme, but make sure to choose more appropriate shades for your elements. Colors like the shiny red/black in this board gather more attention than the actual information in yellow.
- Not every analysis needs a pie chart. You can actually deliver better visualization using other types of charts instead of it.
Questions & Answers
Now, looking at what we can take from this board, the bar charts and informative cards show that there are very dominant teams in Bundesliga, such as: Bayern München, Borussia Dortmund, Bayer Leverkusen, Werder Bremen and Schalke 04.
We also see how much “easier” it has been to win at home ground in Bundesliga, can we attibute it to the passionate german football fans who make their stadiums full every game?
Fun fact: You need to enter some kind of Draw in order to try buying tickets to Bayern München games, meaning that you might not get it even if you have the money and want to buy months before the game.
Now, looking at the number of goals per season:
The numbers oscilate from year to year, but follow a somehow straight path. The difference between the highest and lowest numbers are of only around 160 goals. What can we take from this?
If we compare to the brazilian line (last post), we see this one is more straight. Maybe one of the causes could be the football style played in Germany, which is more careful/controlled than in Brazil, while also more defensive and tactical. Besides, players from everywhere around the world try their chances in Germany, making the dynamics of the competition different from in Brazil, where foreigners are from countries that have similar playstyle (Argentina, Uruguay, Colombia).
With more data available, for sure we could dig deeper on the reasons. Anyway, fun practice. 🙂
Artisting Data 