Download PDF
iSi is turning data into knowledge with QlikView
Technology Category
- Analytics & Modeling - Real Time Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Functions
- Sales & Marketing
- Business Operation
Use Cases
- Predictive Quality Analytics
- Real-Time Location System (RTLS)
Services
- Data Science Services
- System Integration
The Challenge
iSi North America, a multi-national provider of specialty pressure cylinders for industrial and consumer applications, was facing several challenges. The company was data-rich but information-poor. Sales analysis was a tedious, time-consuming process, and the company was losing money on unprofitable customers and products. The company lacked a clear view of the profitability of specific customers or products, and the burden of report generation was heavy on the small, stressed IT staff. The company made a significant investment in Lawson’s M3 or Movex ERP system, but still found itself struggling with data analysis.
About The Customer
iSi North America is a part of iSi International, a multi-national provider of specialty pressure cylinders for industrial and consumer applications. The company's product lines span commercial and home kitchen equipment, automotive, and industrial markets. In North America, iSi made a significant investment in Lawson’s M3 or Movex ERP system. Despite this, the company found itself 'data-rich' but 'information-poor.' Sales analysis was a tedious, time-consuming process, and the company was losing money on unprofitable customers and products.
The Solution
To better understand its operations, iSi implemented a new decision support system using QlikView. With QlikView, users now have the ability to view and analyze data from the Movex database through a user-friendly interface. They are no longer limited to standard reports and can ask questions they could not predict in advance. As a result, sales personnel are no longer dependent on the IT department for information, and the company has taken steps to improve customer and product profitability. The application allows iSi to analyze and explore sales data from every conceivable angle – margin rates per customer, sales per quarter by salesperson, sales per product code by district and salesperson and so on. The application is distributed via the QlikView Server, making it possible for company personnel to access information through the company Intranet.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Leading Tools Manufacturer Transforms Operations with IoT
Stanley Black & Decker required transparency of real-time overall equipment effectiveness and line productivity to reduce production line change over time.The goal was to to improve production to schedule, reduce actual labor costs and understanding the effects of shift changes and resource shifts from line to line.
Case Study
IoT Data Analytics Case Study - Packaging Films Manufacturer
The company manufactures packaging films on made to order or configure to order basis. Every order has a different set of requirements from the product characteristics perspective and hence requires machine’s settings to be adjusted accordingly. If the film quality does not meet the required standards, the degraded quality impacts customer delivery causes customer dissatisfaction and results in lower margins. The biggest challenge was to identify the real root cause and devise a remedy for that.
Case Study
Jaguar Land Rover Speeds Order-to-Cash Cycle
At Jaguar Land Rover, vehicles physically move around the facility for testing, configuration setting, rework and rectification, leading to a longer search time to get each vehicle to its next process facility. The main goal is to minimize the vehicles' dwell time between end of line and the delivery chain which was previously a manually intensive process. Jaguar Land Rover's goal was to build on the success of an earlier RFID project and improve the efficiency of delivering vehicles to meet dealer orders.
Case Study
Improve Postal Mail and Package Delivery Company Efficiency and Service
Postal mail and package delivery company wanted to replace legacy yard management system, increase inbound and outbound yard velocity, improve priority parcel delivery time and accuracy, reduce workload and overtime, reduce driver detention and measure performance and utilization of yard resources.
Case Study
Hospital Management Solution
The Oncology Diagnosis and Treatment Center of Brasov wanted to give patients as much freedom to roam as possible, while at the same time ensuring optimal patient safety and security. The centre was in need of an adequate wireless voice communication and messaging solution that would give patients the confi dence that medical staff is always on call, and reduce stress levels of nurses and doctors when called in case of urgent need.
Case Study
Worker Tracking & Safety Monitoring in Construction
One of the main challenges facing the technology was to create a network within underground tunnels and another was to provide products that can withstand harsh working environment. The team used amplifiers to enhance bandwidth and Litum produced IP67-rated hardware that is durable for harsh working conditions.
