Case Study

Supermärkte Nord Vertriebs GmbH & Co. KG

Granular analysis of POS receipt data that delivers more transparency for grocery retailers

By tailoring its range of products more efficiently to the changing needs of its customers, Supermärkte Nord Vertriebs GmbH & Co. KG, Germany’s largest consumer cooperative in the food retailing industry, is now able to maintain its competitive edge. It does so by relying on Exasol’s in-memory analytic database.

Download success story

We have managed to dramatically accelerate our analytic queries; now, some run up to 100 times faster. We can now invest the time we save into other important tasks in the company.

Torsten Rehder Head of Business Intelligence, Supermärkte Nord Vertriebs GmbH & Co. KG
Industry
Retail & E-Commerce
Application
Purchasing behaviour analytics
Shopping cart/Assoc.-A.
Database
Exasol
Oracle DB
BI Tool
MicroStrategy
Tableau
ETL Tool
Pentaho Data Integration

The Challenge

  • Speed: Departments needed faster access to their reports
  • Coop needed a solution that was capable of centralizing customer and company data, cutting order and supply chain times and optimizing marketing activities by reducing costs
  • A single source of truth for all subsystems
  • As little maintenance and administration overhead as possible

The Solution

  • High performance levels without the need to redesign analysis parameters
  • Limitless linear scalability
  • Maintenance-free
  • Fast response times and great communication from Exasol support

Proven Benefits

  • Decision-makers profit from greater levels of transparency made possible by the extensive amounts of information and highly granular analyses (such as in annual supplier interviews)
  • Departments are now able to create reports much faster than in the past
  • Analysis of POS receipt data is now based on hard facts instead of gut feeling
  • Deployment capacity and product management are optimized, and financial losses from product recalls can be assessed instantly