Download PDF
QlikView provides an “aha” experience for drapery specialist ADO
Technology Category
- Analytics & Modeling - Real Time Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
- Consumer Goods
Applicable Functions
- Business Operation
- Sales & Marketing
Use Cases
- Inventory Management
- Predictive Quality Analytics
Services
- Data Science Services
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.
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 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
Quantitative Benefit
Related Case Studies.
.png)
Case Study
Improving Vending Machine Profitability with the Internet of Things (IoT)
The vending industry is undergoing a sea change, taking advantage of new technologies to go beyond just delivering snacks to creating a new retail location. Intelligent vending machines can be found in many public locations as well as company facilities, selling different types of goods and services, including even computer accessories, gold bars, tickets, and office supplies. With increasing sophistication, they may also provide time- and location-based data pertaining to sales, inventory, and customer preferences. But at the end of the day, vending machine operators know greater profitability is driven by higher sales and lower operating costs.
Case Study
Series Production with Lot-size-1 Flexibility
Nobilia manufactures customized fitted kitchens with a lot size of 1. They require maximum transparency of tracking design data and individual processing steps so that they can locate a particular piece of kitchen furniture in the sequence of processes.
Case Study
American Eagle Achieves LEED with GE LED Lighting Fixtures
American Eagle Outfitters (AEO) was in the process of building a new distribution center. The AEO facility management team decided to look at alternate options for lighting layout that could provide energy and maintenance savings. AEO would need a full-time maintenance employee just to replace burned-out fluorescent tubes.
Case Study
Revolutionizing Rodent Control
From pet- and child-safe traps, to touch-free and live-catch rodent control solutions, Victor continues to stay committed to producing superior products that meet the varying needs of today’s pest control professionals. And, with a long standing history supporting customers in the food processing, service, and retail settings, Victor knew that strict regulations were costing organizations thousands of dollars in excess overhead trying to manage their rodent-control solutions. Trap inspections in these environments are often difficult and time consuming, requiring personnel to manually check a trap’s status multiple times per day, amounting to over six hours of manual labor. Victor is looking for an innovative way to increase operational efficiencies with the use of technology.
