Qlik Case Studies iSi is turning data into knowledge with QlikView

Edit This Case Study Record

	iSi is turning data into knowledge with QlikView Qlik

iSi is turning data into knowledge with QlikView

Qlik

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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 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.

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.

Impact #1	Improved data quality by enabling staff to quickly find anomalies
Impact #2	Alleviated stress on IT staff by reducing ad-hoc report requests
Impact #3	Sales personnel are no longer dependent on the IT department for information

Impact #1

Improved data quality by enabling staff to quickly find anomalies

Impact #2

Alleviated stress on IT staff by reducing ad-hoc report requests

Impact #3

Sales personnel are no longer dependent on the IT department for information

Benefit #1	Saved between $45,000 and $60,000 with the first two clicks of the mouse in QlikView
Benefit #2	Identified unprofitable products and customers through margin analysis

Benefit #1

Saved between $45,000 and $60,000 with the first two clicks of the mouse in QlikView

Benefit #2

Identified unprofitable products and customers through margin analysis

Download PDF Version

Overview

iSi is turning data into knowledge with QlikView

Operational Impact

Quantitative Benefit