A data platform for Europe's largest music retailer
From scattered data sources to one central platform with more than 100 dashboards, forecasting models for purchasing and an in-house data team.
- Client
- Thomann
- Industry
- Retail and e-commerce
- Scope
- Data platform, business intelligence, forecasting
- Duration
- Five years of collaboration
- dashboards for the business units
- 100+
- central data platform instead of scattered sources
- 1
- of build, operation and further development
- 5 years
Starting point
Musikhaus Thomann is a family business from Upper Franconia, founded in 1954, and Europe's largest music retailer. Its range covers musical instruments, studio, lighting and PA equipment and accessories, for beginners and professionals alike.
Thomann worked with a wide range of data, from transactions and inventory to purchasing and marketing. There were many sources, a highly branched business structure and no specialised data team.
The key question came from purchasing: how can a business with such a broad assortment buy more efficiently and profitably? The solution had to keep pace with growth, fit into Thomann's own tools and must not interrupt day-to-day operations.
What we built
We built a serverless data platform on Google Cloud Platform that became the central place to store and retrieve all company data.
- Central data warehouse in Google BigQuery
- Documented, versioned data pipelines with Dataform
- More than 100 dashboards in Looker Studio for the business units
- A dedicated permission manager for data access
- AutoML forecasting models for purchasing and sales trends
- Automated alerts when metrics move out of range
Architecture
Sources
- Shop and transactions
- Inventory and purchasing
Marketing and web analytics- Logistics
Platform
Google BigQuery
- Dataform pipelines
- Permission manager
Outcome
100+ dashboards
Purchasing forecasts- Automated alerts
Inventory and purchasing, daily overview
Active items
48,200
+3.2%Stock value
€12.4m
+1.8%7-day turnover
3.1
+0.4Stock and orders per product group
Moving stock turnover
Outcome
Data is accessible across the company, and decisions in purchasing, warehousing and sales rely on the same numbers. Thomann has built an in-house data team that carries the platform forward today.
„Thanks to datadice, we have revolutionised our data management and achieved concrete business results. The solution enabled us to make precise data-driven decisions, which is crucial for our position in the dynamic e-commerce market.“
Could your project be the next case?
The initial consultation is free. Afterwards you receive a short playbook with our assessment and the next step.
Discuss your project