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

QlikView provides an “aha” experience for drapery specialist ADO

Qlik Logo
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
  • 80% of sales queries can now be solved ad-hoc, saving an enormous amount of time.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.