Qlik Case Studies QlikView Provides a Pyrotechnic Analysis Display for WECO

Edit This Case Study Record

	QlikView Provides a Pyrotechnic Analysis Display for WECO Qlik

QlikView Provides a Pyrotechnic Analysis Display for WECO

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Consumer Goods
Use Cases	Supply Chain Visibility Inventory Management
Services	Data Science Services System Integration
Challenge	WECO Pyrotechnische Fabrik, a leading fireworks producer in Europe, faced challenges in managing its multi-stage in-house production system and purchasing merchandise from abroad. The company required accurate logistics planning to ensure all branch outlets received their stocks in time for New Year’s Eve sales. The same level of accuracy was needed for planning production and import schedules. For a long time, data analysis was done using Microsoft Dynamics NAV business management software coupled with individually programmed reports. However, this procedure proved to be time-consuming and error-prone. The data was first exported from the inventory management system into various different Excel worksheets and then collated. This process led to errors and could only assess and optimise processes in retrospect. Read More
About Customer	WECO Pyrotechnische Fabrik is a manufacturer and distributor of fireworks based in North Rhine-Westphalia, Germany. Founded in 1948, the company employs around 450 people across three sites. WECO is the leading fireworks producer in Europe, with subsidiaries in France, the United Kingdom, Luxembourg, and the Netherlands, as well as a partner company in Austria. The company sells its products to both the general consumer (95 per cent) and professional pyrotechnic display firms. WECO operates three manufacturing sites in Germany at Eitorf, Kiel, and Freiberg, and also imports products from the Far East. The company adheres to the principle that fireworks should be an ideal combination of safety and fun, and thus maintains high quality demands and controls. Read More
Solution	WECO Pyrotechnische Fabrik deployed QlikView to 10 employees for product analyses, profit margin calculations, and production planning. The company wanted information to be available significantly faster to various departments, including purchasing, production, distribution, and controls, as well as to the executive board. The data needed to be collated, assessed, and made available in reports via one single system without prior aggregation or intermediate steps. During a three-day QlikView workshop called “Seeing is Believing”, WECO ordered a first application for the company’s purchasing department. Further analysis programs for production, distribution, and the executive board were handled by QlikTech partner CBS Consulting Business Solutions, which supervised the installation and implementation of QlikView. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Consumer Goods

Use Cases

Supply Chain Visibility

Inventory Management

Services

Data Science Services

System Integration

Challenge

WECO Pyrotechnische Fabrik, a leading fireworks producer in Europe, faced challenges in managing its multi-stage in-house production system and purchasing merchandise from abroad. The company required accurate logistics planning to ensure all branch outlets received their stocks in time for New Year’s Eve sales. The same level of accuracy was needed for planning production and import schedules. For a long time, data analysis was done using Microsoft Dynamics NAV business management software coupled with individually programmed reports. However, this procedure proved to be time-consuming and error-prone. The data was first exported from the inventory management system into various different Excel worksheets and then collated. This process led to errors and could only assess and optimise processes in retrospect.

About Customer

WECO Pyrotechnische Fabrik is a manufacturer and distributor of fireworks based in North Rhine-Westphalia, Germany. Founded in 1948, the company employs around 450 people across three sites. WECO is the leading fireworks producer in Europe, with subsidiaries in France, the United Kingdom, Luxembourg, and the Netherlands, as well as a partner company in Austria. The company sells its products to both the general consumer (95 per cent) and professional pyrotechnic display firms. WECO operates three manufacturing sites in Germany at Eitorf, Kiel, and Freiberg, and also imports products from the Far East. The company adheres to the principle that fireworks should be an ideal combination of safety and fun, and thus maintains high quality demands and controls.

Solution

WECO Pyrotechnische Fabrik deployed QlikView to 10 employees for product analyses, profit margin calculations, and production planning. The company wanted information to be available significantly faster to various departments, including purchasing, production, distribution, and controls, as well as to the executive board. The data needed to be collated, assessed, and made available in reports via one single system without prior aggregation or intermediate steps. During a three-day QlikView workshop called “Seeing is Believing”, WECO ordered a first application for the company’s purchasing department. Further analysis programs for production, distribution, and the executive board were handled by QlikTech partner CBS Consulting Business Solutions, which supervised the installation and implementation of QlikView.

Impact #1	Rapid data assessment
Impact #2	Process optimisation in everyday business
Impact #3	One single system for analysis, reporting, and dashboards

Impact #1

Rapid data assessment

Impact #2

Process optimisation in everyday business

Impact #3

One single system for analysis, reporting, and dashboards

Download PDF Version

Overview

QlikView Provides a Pyrotechnic Analysis Display for WECO

Operational Impact