Skip navigation
Skip
2020
Founded
Food
Brands
Elmshorn
Headquarters
> 1,200
Employees
> 3 million
Active customers
Initial Situation

Central data strategy with Databricks on AWS at TQG

Scalable lakehouse architecture for real-time analytics & BI in eCommerce

The Quality Group (TQG), with brands such as ESN and More Nutrition, is one of the fastest-growing companies in the Nutrition & Social Commerce sector. With sales of over 680 million € and over 100,000 orders per day during peak times, the existing infrastructure reached its limits.Ruhrdot. implemented a centralized Databricks platform on AWS to build a scalable data strategy from self-service BI to real-time analytics for fulfillment and logistics. The goal was a unified analytics platform that supports analysts, BI teams, and data scientists at the same time.

Challenges

Data integration & real-time analytics for E-Commerce

The rapid growth and variety of systems made a robust data infrastructure essential for business intelligence and machine learning.

  • Complex system landscape with multiple ERP systems, shops, warehouse systems and marketing platforms
  • Lack of real-time data for operational management and decision making
  • No technical foundation for streaming analytics and scalable ML models
  • Need for a central platform for BI, data science and automation
  • No consistent data integration for reports, KPIs and forecasting

Employees in warehouse
Added values

Solution

We solve these problems.

Digital transformation for businesses

Heading

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Heading

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Heading

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Heading

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Heading

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.

Data platform with Databricks on AWS

Integrate all operational, financial, and logistical data sources into a scalable data lakehouse for future growth

Visualize operational KPIs in real time

Critical metrics such as fulfillment quotas across multiple warehouses in a central Tableau interface - based on Delta Lake

BI & ML combined in one architecture

Databricks provides a unified analytics platform for analysts (e.g. aggregated reports) and data scientists (e.g. access to raw data & model training)

Automation through MLflow & MLOps

End-to-end control of the machine learning lifecycle is introduced - including deployment, monitoring and versioning

Streaming analytics prepared

The architecture now also allows future expansions for streaming data - such as live forecasting and real-time alerts

Team enablement through workshops

Interactive training for the data team to enable self-service analytics and self-optimization from now on

“With the support of our implementation partner, ruhrdot., we now have a unified data warehouse based on Databricks, which enables us to centralize our data and get real-time insights across our entire company. This transformation was the basis for creating a holistic view of all key business KPIs and optimizing our logistics and operational processes, which led to greater transparency, significantly improved order processing performance, and the agility to adapt seamlessly to peak requirements. ”

Dr. Peter Massuthe
Head of Data Warehouse

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.
Conclusion

Unified analytics and machine learning as a competitive advantage in E-Commerce

With the introduction of a Databricks Data Intelligence Platform on AWS, TQG has centralized its data infrastructure, enabled real-time control and laid the foundation for future-oriented applications. The new architecture combines business intelligence, ML and streaming capabilities in one platform. Ready for further growth.

Note: The images used are symbolic photos and do not show real rooms or employees of our customers.

Modernize data strategy and implement innovations?

Make an appointment directly - we provide non-binding advice for an optimal data solution.

Success-Stories

Related services

We see ourselves as a full-service provider for Xentral and Odoo ERP software. As an official Xentral and Odoo Silver Partner, you can expect the following services from us:

Logistics group

Leading logistics company revolutionizes data infrastructure

> 5
Source systems
100%
Cloud-native solution
5
More independent teams

The Quality Group

Artificial intelligence in warehouse & sales

2020
founded
Food
Brands
Elmshorn
Head Office

The Quality Group

Revolutionizing Invoicing in E-Commerce

2020
Founded
Food
Brands
Elmshorn
Head Office
All Success-Stories