“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
