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, coop eG, 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, coop eG

  • About coop

    About coop

    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, coop eG, 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.

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

    • 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