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
The dashboard then presented a flexible and intuitive
way to gain insights and make decisions.