Qlik Case Studies Rexam Improves Decision Making with Instant Reports from Qlikview

Edit This Case Study Record

	Rexam Improves Decision Making with Instant Reports from Qlikview Qlik

Rexam Improves Decision Making with Instant Reports from Qlikview

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Functions	Discrete Manufacturing
Use Cases	Predictive Maintenance Real-Time Location System (RTLS)
Services	Data Science Services System Integration
Challenge	Rexam Beverage Can Europe & Asia, the largest can manufacturer in Europe, faced a significant challenge in extracting business data from SAP and other data sources to create ad hoc reports. The company's executives needed to highlight key accounts and drill down into products, countries, and sales offices. The main business challenge was that Rexam had huge business value locked into its data sources but lacked a set of applications to extract it to solve business issues immediately. Reports could take one person five working days to compile which often caused issues for executives working to tight deadlines. The company needed a user-friendly business intelligence (BI) tool to avoid the need for users to download huge quantities of data to produce Excel spreadsheets over which managers had little control. Read More
About Customer	Rexam, headquartered in the United Kingdom is one of the world’s top five consumer packaging companies and the largest global manufacturer of beverage cans making over 60 billion cans a year. With sales in 2011 of £4.7 billion, Rexam is performing well in a challenging economic climate. In presenting the 2011 results, Rexam pointed to a better than expected performance in its beverage can business, especially in Europe, and a new focus on cost management. Rexam`s Beverage Can Europe & Asia business based in Luton has 22 factories in Europe. This business with a reputation for innovation also has manufacturing plants in China, India and Egypt, and a joint venture in South Korea. Read More
Solution	Rexam deployed QlikView initially for its executives to monitor the performance of key accounts by extracting data from SAP, Oracle, and Excel data sources. By the end of 2011 around 10 applications had been created. QlikView can sit on top of any data source including Oracle and Excel as well as SAP and provide instant reports using any parameters needed. It’s easy for QlikView to sit in the middle of a business serving multiple users with data. Once set up, users can build their own reports to business questions with ease, leading to multiple business discoveries. Since its initial deployment of QlikView in 2011 for monitoring key accounts, Rexam IT has worked with two other QlikTech partners Atos and Quick Intelligence on new ways of adding business value to Rexam. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Functions

Discrete Manufacturing

Use Cases

Predictive Maintenance

Real-Time Location System (RTLS)

Services

Data Science Services

System Integration

Challenge

Rexam Beverage Can Europe & Asia, the largest can manufacturer in Europe, faced a significant challenge in extracting business data from SAP and other data sources to create ad hoc reports. The company's executives needed to highlight key accounts and drill down into products, countries, and sales offices. The main business challenge was that Rexam had huge business value locked into its data sources but lacked a set of applications to extract it to solve business issues immediately. Reports could take one person five working days to compile which often caused issues for executives working to tight deadlines. The company needed a user-friendly business intelligence (BI) tool to avoid the need for users to download huge quantities of data to produce Excel spreadsheets over which managers had little control.

About Customer

Rexam, headquartered in the United Kingdom is one of the world’s top five consumer packaging companies and the largest global manufacturer of beverage cans making over 60 billion cans a year. With sales in 2011 of £4.7 billion, Rexam is performing well in a challenging economic climate. In presenting the 2011 results, Rexam pointed to a better than expected performance in its beverage can business, especially in Europe, and a new focus on cost management. Rexam`s Beverage Can Europe & Asia business based in Luton has 22 factories in Europe. This business with a reputation for innovation also has manufacturing plants in China, India and Egypt, and a joint venture in South Korea.

Solution

Rexam deployed QlikView initially for its executives to monitor the performance of key accounts by extracting data from SAP, Oracle, and Excel data sources. By the end of 2011 around 10 applications had been created. QlikView can sit on top of any data source including Oracle and Excel as well as SAP and provide instant reports using any parameters needed. It’s easy for QlikView to sit in the middle of a business serving multiple users with data. Once set up, users can build their own reports to business questions with ease, leading to multiple business discoveries. Since its initial deployment of QlikView in 2011 for monitoring key accounts, Rexam IT has worked with two other QlikTech partners Atos and Quick Intelligence on new ways of adding business value to Rexam.

Impact #1	Reports in near real time that previously took up to 5 days.
Impact #2	Executives are now able to make decisions with a single version of the truth.
Impact #3	User created reports, and self-serving the organisation results in significant cost and time savings.

Impact #1

Reports in near real time that previously took up to 5 days.

Impact #2

Executives are now able to make decisions with a single version of the truth.

Impact #3

User created reports, and self-serving the organisation results in significant cost and time savings.

Benefit #1	100% reduction in reporting from 5 days to real time
Benefit #2	1st QlikView business value reports in less than 30 days

Benefit #1

100% reduction in reporting from 5 days to real time

Benefit #2

1st QlikView business value reports in less than 30 days

Download PDF Version

Overview

Rexam Improves Decision Making with Instant Reports from Qlikview

Operational Impact

Quantitative Benefit