Qlik > Case Studies > QlikView provides an “aha” experience for drapery specialist ADO

QlikView provides an “aha” experience for drapery specialist ADO

Customer Company Size

Large Corporate

Region

Europe

Country

Germany

Product

QlikView

Tech Stack

ERP system
In-memory-based analysis tool

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Productivity Improvements
Cost Savings

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Consumer Goods

Applicable Functions

Sales & Marketing
Business Operation

Use Cases

Predictive Quality Analytics
Inventory Management

Services

Data Science Services

About The Customer

ADO Gardinenwerke is a leading manufacturer of drape material and decorative fabric in Germany. The company was founded in 1954 and has since grown to become the largest German manufacturer in its industry, with annual sales approaching €130 million. ADO employs 1,350 workers worldwide, with approximately half of them working at the headquarters in Aschendorf, where more than 90 percent of the drapes and decorative fabrics are produced. The company also has a plant in the USA, a sewing factory in Poland, and a small production facility for voile fabric in Indonesia. In Germany alone, ADO supplies around 6,000 warehouses, interior design outlets, and other resellers with drape material and decorative fabrics from its product line of 50,000 different articles.

The Challenge

ADO Gardinenwerke, a leading manufacturer of drape material and decorative fabric in Germany, was facing challenges with its existing business intelligence tool integrated in the ERP system. The tool was unable to handle the high volume of data that needed to be analyzed for ADO’s sophisticated reporting system. Questions such as sales trends for specific customers, big sellers in various countries or regions, seasonal deviations in sales, and overall sales trend for individual models could not be answered efficiently. The tool required a massive amount of in-house and outside development to create reports and answer new questions. Additionally, data consistency was not always guaranteed and there was insufficient capacity to process mass data, leading to extremely long response times. The system was also inflexible and slow, failing to provide the necessary benchmarks and reports at the level of quality required for optimum data analysis.

The Solution

ADO Gardinenwerke decided to implement QlikView, an in-memory-based analysis tool, to overcome the challenges with its existing business intelligence tool. QlikView loads all the data into the main memory from the start, carrying out all calculations and logical links in the main memory, which minimizes response times for queries and analyses. This allows questions to be altered at any time by adding new dimensions or benchmarks. The system was up and running in the company within a matter of weeks, with new QlikView applications being systematically introduced for areas such as quality management, sales controlling, and logistics. The IT department now presents operative data from the ERP system in QlikView files that contain all the necessary dimensions, allowing employees to independently analyze them as desired and continue to work on the individual queries flexibly using the integrated bookmark function.

Operational Impact

With QlikView, ADO Gardinenwerke was able to quickly and flexibly convert data into information. The tool enabled ad-hoc analyses with any number of selection options at the disposal of end users rather than IT. This resulted in a reduction in the IT workload and an improvement in data quality. The tool also provided the ability to analyze data on a laptop even offline while traveling, and to print it out as a report, save it as a PDF, or export it to Microsoft Excel or other Office applications.

Quantitative Benefit