Ball Logo

“The availability of accurate data for planning provided by our Qlik dashboard has resulted in a 3% improvement in production up-time.”

– Steve Thomason, Business Analyst at Ball

Customer Forecasting at Ball

The Challenge

In 2016 Ball Corporation acquired Rexam, which required the integration of forecasting data for both companies’ manufacturing plants into one IT system.

It was critical to have their customers’ forecasts online almost immediately and gain a consolidated view of stock and production across the combined European plants and warehouses.

As customers provide their forecasts in spreadsheets in a variety of formats and layouts, a solution was needed that could deal with these disparate inputs and deliver a single view of the data.

Our Solution

Rexam were prolific Qlik users, with dashboards created for sales, planning, maintenance and quality control, to name but a few.

It was decided that Qlik offered the only route to bring Ball and Rexam forecasts together in one place.

A data load process was created using Qlik which looped around a folder of spreadsheets, and picked the correct load script for each. This then consumed each spreadsheet and wrote the data out to a single consistent format.

The dashboard then presented a flexible and intuitive way to gain insights and make decisions.

The Results

By blending data from different customers, plants, and warehouses in a single application Ball can accurately plan production and logistics to meet their customers’ demands.

The data provided via the Qlik dashboard allows production planning to coordinate long and short runs of similar products and control the time required to change tools and inks.

The increased productivity translates into a 3% improvement of manufacturing up-time.

This has brought about major cost savings and mitigated out-of-stock risks.

Quick Intelligence

We are a UK-based consultancy organisation that has a 100% focus on delivering inspired solutions using the Qlik Platform. Formed in 2009 with this goal, we are well-known and respected in Qlik circles.

Our managing director, Steve Dark, has been recognised by Qlik as a Qlik Luminary and Qlik Community MVP, for his knowledge and advocacy of the Qlik platform. This is evidenced through his popular blog and his work on a number of Qlik related books.

In 2017 Quick Intelligence were awarded Supply Chain Specialists by Qlik in recognition of our exceptional experience in logistics and B2B solutions.

Talk to the UK’s leading Qlik experts today

Fill in the form to request more information

Ball Sleek Cans