Fresenius Logo

Football data analytics for a Bundesliga soccer team

bekumoo - Embedded Analytics with Power BI
The company
Top club in the Bundesliga
Technologies
Microsoft Azure, Snowflake, dbt Labs & Tableau
The challenge
Processing, analysis and visualization of a high volume of live data.
Result
Data Platform, which can retrieve, store and visualize millions of data points live.
"Thanks to its good performance with high data volumes, Snowflake is the ideal data platform for football analytics."
Arjan van Staveren
Country Lead Germany / Snowflake

Initial situation

As a result of the digital transformation, data is being generated in all areas and is available for analyzing performance, trends and developments. The use of player performance data by the coaching staff has also become established in professional soccer in recent years. The particular challenge here lies in the live analysis of match data.

For our customer, a top club in the German Bundesliga, we have created a high-performance tech stack based on Azure and Snowflake. It forms the core of the taod Football Data Platform. Thanks to the special data preparation, the analysis can be started directly in Tableau and thus quickly generate added value for the coaching staff and team alike.

Fresenius Logo

How does the analysis of live data work?

How can extremely high data volumes be processed?

How is a cloud-based technology stack put together?

Download full case study

Our detailed procedure for the top Bundesliga club

Analysis of available data sources and creation of an initial ETL process

A high-performance ETL process in Python handles data retrieval, quality checks and initial transformations. Orchestrated via Logic Apps and executed in Docker containers via Azure Container Instances, it ensures consistent deployment and needs-based scaling - crucial for processing with minimal latency during live games.

Development of the central data platform in Snowflake

The data platform is based on Snowflake in combination with Azure and offers a stable, scalable and low-maintenance foundation. Multi-level data storage allows different versions to be managed. Live data and quality-assured raw data are processed separately - even peak loads with millions of events per match day are handled reliably.

Data modeling with dbt Labs

dbt Cloud is used to develop and orchestrate the data models. All transformations are transparently implemented, versioned and tested in SQL. Thanks to a direct connection to Snowflake, an agile workflow with integrated documentation and data lineage is created - ideal for a scalable and maintainable data model.

Visualization of the data using Tableau dashboards

Interactive analyses and dashboards are carried out via Tableau Server in a self-service approach. The live connection to Snowflake enables real-time analyses that are accessible to a wide range of stakeholders via an intuitive user interface. Teams can create their own dashboards and derive data-driven decisions directly from the tool.

Football Data Platform for data-based decisions

Today, football analytics is a key success factor for sporting and economic development. With the new technology stack, the club analyses every game based on data, enriches the raw data in context and visualizes it as animations. In this way, tactical knowledge is communicated in an understandable way - from the analyst to the coaching team.

Result

From the starting line-up to the match plan to the analysis of live data on match days

In the project, over 3.6 million Bundesliga data points were retrieved per match in real time and stored in a database. The KPIs calculated from this were visualized and made available for analysis. By setting up its own data platform, the club laid the foundation for a powerful analytics department - with direct added value for the team's sporting performance. The platform now enables well-founded tactical decisions, detailed opponent analyses and targeted performance evaluations of individual players.

3.6
Each Bundesliga match delivers millions of data points, which are recorded, stored and analyzed in real time via a scalable Snowflake architecture.
24h
The initial ETL process, including the data pipeline, was set up close to production in just 1 day - thanks to modular Azure architecture and containerization.
<5 Sek
Delay in live data visualization. The analyzed KPIs are provided almost in real time via a Tableau dashboard.
100%
individual KPIs. The platform makes it possible to define specific key performance indicators per game philosophy and player profile.

More about Tech Stack, BI & Analytics and Snowflake

Tableau vs. Power BI Whitepaper
Service

Data Engineering Consulting

From analysis to cloud implementation: we boost your data management strategically and technologically.

To the service

Technology

Snowflake
Consulting

We'll show you how easy it is to manage your data with Snowflake.

More info
BI & Data Analytics Consulting taod Consulting
Whitepaper

Modern Data Stack

What components does a professional tech stack for analytics consist of?

Read now
taod Consulting GmbH Logo
Stay up to date with our monthly newsletter. All new white papers, blog articles and information included.
Subscribe to our newsletter
Get exclusive knowledge for your data projects. In our print magazine data!, experienced data experts report directly from the world of data.
subscribe to data!
Company headquarters Cologne

taod Consulting GmbH
Oskar-Jäger-Str. 173, K4
50825 Cologne‍
Hamburg location

taod Consulting GmbH
Alter Wall 32
20457 Hamburg‍
Stuttgart location

taod Consulting GmbH
Schelmenwasenstraße 32
70567 Stuttgart
© 2025 all rights reserved