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.

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

  • About Supermärkte Nord Vertriebs GmbH & Co. KG

    About Supermärkte Nord Vertriebs GmbH & Co. KG

    Competition is stiff in the food retailing sector. Nowhere in Europe are the diversity, quality and prices of products more consumer-focused than in Germany. However, while point-of sale (POS) receipts on the goods in consumers’ baskets may offer the retailer insight into their customers’ preferences, in contrast to e-commerce, receipts do not reveal information about the actual customer behind them. Nevertheless, POS receipt data does provide useful information that a company can use to manage its operations.

    It also allows retailers to identify consumers’ needs and benefit from information about items sold, the quantity, the place, the price and the time of sale. 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.

    Industry:Retail & E-Commerce
    Application:Purchasing behaviour analytics, Shopping cart/Assoc.-A.
    Database:EXASOL, Oracle DB
    BI tool:MicroStrategy, Tableau
    ETL ToolPentaho Data Integration
  • Challenge

    Challenges

    • 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
  • Solution

    Why EXASOL?

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

    Benefits for Supermärkte Nord Vertriebs GmbH & Co. KG

    • 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