Qlik Case Studies Toshiba TEC reduces inventory differences at EDEKA Hessenring with QlikView

Edit This Case Study Record

	Toshiba TEC reduces inventory differences at EDEKA Hessenring with QlikView Qlik

Toshiba TEC reduces inventory differences at EDEKA Hessenring with QlikView

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Retail
Applicable Functions	Sales & Marketing
Use Cases	Predictive Waste Reduction Fraud Detection
Services	Data Science Services System Integration
Challenge	EDEKA Hessenring, part of the EDEKA Group, was facing significant inventory discrepancies amounting to €4.5 billion annually across the German retail industry. These discrepancies were largely due to organizational weaknesses and employee crime. The company's auditing department, consisting of only four people, was responsible for auditing approximately 4,300 employees. The auditing process was heavily reliant on the experience of the employees and required a significant amount of effort. With a data volume of more than 36 million lines of accounting data per month for 73 markets and branches, this was a near impossible task. EDEKA Hessenring needed an analytical tool that could evaluate all the transaction data according to various criteria both systematically and quickly. Read More
About Customer	TOSHIBA TEC Europe is one of the leading manufacturers of information systems for business and industry. They offer a comprehensive service package to their customers, which includes consultation, system development, system installation, operation, and management of cashier systems, cash registers, scales, barcode printers, peripheral, and software information systems. One of their clients is the EDEKA Hessenring Group, part of Germany's number one food retailer, the EDEKA Group. EDEKA Hessenring focuses on north and central Hessia, western Thuringia, and southern Lower Saxony. The EDEKA Group has a large and varied range of equipment and a highly varied system landscape. Read More
Solution	TOSHIBA TEC introduced an efficient auditing tool, storeMate loss prevention, based on QlikView, to permanently reduce costs associated with improper postings and differences in inventory. The solution was implemented within the EDEKA Group quickly and easily, and the transactions are now evaluated at the click of a mouse without special database knowledge or training thanks to the intuitive user interface. The solution can rapidly analyze enormous amounts of data ranging from 15 to 20 terabytes, and spontaneously add additional dimensions and indexes to change the analytical perspective at any time. Conventional review criteria such as cancellations, empty packages, or personnel purchases are already predefined in “storeMate loss prevention” and can be supplemented at any time with additional criteria. Since all the data is continuously being loaded into the working memory, all the data from the branch level can be efficiently analyzed down to individual receipts using just one application. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Retail

Applicable Functions

Sales & Marketing

Use Cases

Predictive Waste Reduction

Fraud Detection

Services

Data Science Services

System Integration

Challenge

EDEKA Hessenring, part of the EDEKA Group, was facing significant inventory discrepancies amounting to €4.5 billion annually across the German retail industry. These discrepancies were largely due to organizational weaknesses and employee crime. The company's auditing department, consisting of only four people, was responsible for auditing approximately 4,300 employees. The auditing process was heavily reliant on the experience of the employees and required a significant amount of effort. With a data volume of more than 36 million lines of accounting data per month for 73 markets and branches, this was a near impossible task. EDEKA Hessenring needed an analytical tool that could evaluate all the transaction data according to various criteria both systematically and quickly.

About Customer

TOSHIBA TEC Europe is one of the leading manufacturers of information systems for business and industry. They offer a comprehensive service package to their customers, which includes consultation, system development, system installation, operation, and management of cashier systems, cash registers, scales, barcode printers, peripheral, and software information systems. One of their clients is the EDEKA Hessenring Group, part of Germany's number one food retailer, the EDEKA Group. EDEKA Hessenring focuses on north and central Hessia, western Thuringia, and southern Lower Saxony. The EDEKA Group has a large and varied range of equipment and a highly varied system landscape.

Solution

TOSHIBA TEC introduced an efficient auditing tool, storeMate loss prevention, based on QlikView, to permanently reduce costs associated with improper postings and differences in inventory. The solution was implemented within the EDEKA Group quickly and easily, and the transactions are now evaluated at the click of a mouse without special database knowledge or training thanks to the intuitive user interface. The solution can rapidly analyze enormous amounts of data ranging from 15 to 20 terabytes, and spontaneously add additional dimensions and indexes to change the analytical perspective at any time. Conventional review criteria such as cancellations, empty packages, or personnel purchases are already predefined in “storeMate loss prevention” and can be supplemented at any time with additional criteria. Since all the data is continuously being loaded into the working memory, all the data from the branch level can be efficiently analyzed down to individual receipts using just one application.

Impact #1	The solution enabled flexible analysis of all data from the branch level down to the level of individual receipts.
Impact #2	Increased identification of irregularities and improved response times to fraud.
Impact #3	Provided a platform for future cross-functional analyses.

Impact #1

The solution enabled flexible analysis of all data from the branch level down to the level of individual receipts.

Impact #2

Increased identification of irregularities and improved response times to fraud.

Impact #3

Provided a platform for future cross-functional analyses.

Benefit #1	Reduced costs arising from incorrect accounting and differences in inventory.
Benefit #2	Managed the data volume from over 36 million lines of accounting data per month for 73 markets and branches.

Benefit #1

Reduced costs arising from incorrect accounting and differences in inventory.

Benefit #2

Managed the data volume from over 36 million lines of accounting data per month for 73 markets and branches.

Download PDF Version

Overview

Toshiba TEC reduces inventory differences at EDEKA Hessenring with QlikView

Operational Impact

Quantitative Benefit