Qlik Case Studies Hella brings transparency to business data with QlikView

Edit This Case Study Record

	Hella brings transparency to business data with QlikView Qlik

Hella brings transparency to business data with QlikView

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Automotive Retail
Applicable Functions	Sales & Marketing
Use Cases	Inventory Management Supply Chain Visibility
Services	Data Science Services
Challenge	Hella Handel Austria, a leading worldwide partner of the automotive industry, was facing challenges with its data management. The company generates vast quantities of new data every day, with 45,000 active items, 900 active customers, and approximately 20,000 orders per month. To evaluate this data, the company needed a powerful analysis tool that would allow ad-hoc analyses of its extensive data inventory while conserving employee resources. Previously, only a few specially-trained Hella experts had suitable programming skills to evaluate the business data stored in the DB2 and Oracle databases. Several employees were busy almost full-time programming queries and manually processing the results in Excel or Access. The multitude of different tools and the high percentage of manual work meant that errors were inevitable. Read More
About Customer	Hella Handel Austria GmbH is a subsidiary of the internationally renowned automotive industry supplier. The company is a leading worldwide partner of the automotive industry, ensuring the supply of parts and accessories to repair shops and garages, particularly in the areas of lighting, electrical systems, electronics, and air conditioning. With 45,000 active items, 900 active customers, and approximately 20,000 orders per month, the company generates vast quantities of new data every day. The company operates in the retail and wholesale distribution industry and is based in Austria. Read More
Solution	Hella Handel Austria deployed QlikView to 30 users across a number of functional areas and at all levels of the organization within just 1 week. With QlikView, Hella Handel now analyzes key metrics across sales orders, pricing management, margin control, merchandising, category management, inventory stock, and finance. With QlikView Connector, Hella Handel is able to free the invaluable data locked in its SAP ERP system and Lawson (M3). Through QlikView Server and Publisher, Hella Handel easily manages the performance and visibility across the large data volume. QlikView was implemented quickly and without complications within a 1-week period. The centralized solution was installed and all of the future user groups were ‘trained’. Today, Hella Handel Austria is using QlikView in a wide range of departments and across all management levels – from administration and office functions to the logistics manager, controller, product manager, marketing manager, and sales office and field services. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Automotive

Retail

Applicable Functions

Sales & Marketing

Use Cases

Inventory Management

Supply Chain Visibility

Services

Data Science Services

Challenge

Hella Handel Austria, a leading worldwide partner of the automotive industry, was facing challenges with its data management. The company generates vast quantities of new data every day, with 45,000 active items, 900 active customers, and approximately 20,000 orders per month. To evaluate this data, the company needed a powerful analysis tool that would allow ad-hoc analyses of its extensive data inventory while conserving employee resources. Previously, only a few specially-trained Hella experts had suitable programming skills to evaluate the business data stored in the DB2 and Oracle databases. Several employees were busy almost full-time programming queries and manually processing the results in Excel or Access. The multitude of different tools and the high percentage of manual work meant that errors were inevitable.

About Customer

Hella Handel Austria GmbH is a subsidiary of the internationally renowned automotive industry supplier. The company is a leading worldwide partner of the automotive industry, ensuring the supply of parts and accessories to repair shops and garages, particularly in the areas of lighting, electrical systems, electronics, and air conditioning. With 45,000 active items, 900 active customers, and approximately 20,000 orders per month, the company generates vast quantities of new data every day. The company operates in the retail and wholesale distribution industry and is based in Austria.

Solution

Hella Handel Austria deployed QlikView to 30 users across a number of functional areas and at all levels of the organization within just 1 week. With QlikView, Hella Handel now analyzes key metrics across sales orders, pricing management, margin control, merchandising, category management, inventory stock, and finance. With QlikView Connector, Hella Handel is able to free the invaluable data locked in its SAP ERP system and Lawson (M3). Through QlikView Server and Publisher, Hella Handel easily manages the performance and visibility across the large data volume. QlikView was implemented quickly and without complications within a 1-week period. The centralized solution was installed and all of the future user groups were ‘trained’. Today, Hella Handel Austria is using QlikView in a wide range of departments and across all management levels – from administration and office functions to the logistics manager, controller, product manager, marketing manager, and sales office and field services.

Impact #1	Enabled fast, easy and flexible analysis and report generation
Impact #2	Delivered platform requiring no programming skills
Impact #3	Integrated a wide range of different data sources

Impact #1

Enabled fast, easy and flexible analysis and report generation

Impact #2

Delivered platform requiring no programming skills

Impact #3

Integrated a wide range of different data sources

Benefit #1	Payback in less than 1 year

Benefit #1

Payback in less than 1 year

Download PDF Version

Overview

Hella brings transparency to business data with QlikView

Operational Impact

Quantitative Benefit