Qlik Case Studies QlikView provides an “aha” experience for drapery specialist ADO
Edit This Case Study Record
Qlik Logo

QlikView provides an “aha” experience for drapery specialist ADO

Qlik
Analytics & Modeling - Real Time Analytics
Consumer Goods
Sales & Marketing
Business Operation
Predictive Quality Analytics
Inventory Management
Data Science Services
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.
Read More
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.
Read More
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.
Read More
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.
80% of sales queries can now be solved ad-hoc, saving an enormous amount of time.
Download PDF Version
test test