Qlik > Case Studies > QlikView Provides a Pyrotechnic Analysis Display for WECO

QlikView Provides a Pyrotechnic Analysis Display for WECO

Qlik Logo
Customer Company Size
Mid-size Company
Region
  • Europe
Country
  • Germany
  • France
  • Luxembourg
  • Netherlands
  • United Kingdom
Product
  • QlikView
Tech Stack
  • Microsoft Dynamics NAV
  • Microsoft SQL Server
  • Excel spreadsheets
Implementation Scale
  • Departmental Deployment
Impact Metrics
  • Productivity Improvements
  • Cost Savings
Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Consumer Goods
Use Cases
  • Supply Chain Visibility
  • Inventory Management
Services
  • Data Science Services
  • System Integration
About The 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.
The 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.
The 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.
Operational Impact
  • Rapid data assessment
  • Process optimisation in everyday business
  • One single system for analysis, reporting, and dashboards
  • Daily updates of information

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.