Dashboard Week Day 2 - Bundesliga

For our second day of dashboard week we had the unique task of web scraping the Bundesliga website for data on different teams performance in the last 20 years. As a result a lot of the time we used today was just using Alteryx to download and scrape the data I needed with RegEx. Moreover, because we were looking for data in multiple years and seasons it was necessary to use a batch macro to extract data from different years as the URL of the Bundesliga website changed depending on the selected season.

Once I had built the macro I needed only to insert it into a 3 tool workflow that allowed me to update the URL’s with the years I was interested in, giving me a great deal of data from 2000-2023.

With the data I had extracted I wanted to answer the question of not only how teams were performing but how can I compare teams in a given season to one another and what teams perform similarly to the ones I selected? How also did the teams I were interested in compare to the year or season before? To this end I created a quick sketch of how I envisioned my dashboard. What I wanted to use the table for was a set action that would highlight the team a user selected then showing the nearest 4 teams in terms of performance.

Author:
Christian Vincent Curcurato
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab