Centralised data model with Qlik

IMA DAIRY & FOOD

Initial situation

Lots of people deal with IMA DAIRY & FOOD products on a daily basis without even knowing. From yoghurt pots to mustard sachets, many packages for food and dairy products come from one of the IMA Group’s machines. The specialists for tailor-made products ensure that no design request remains unfulfilled. But the more customised the packaging, the more complex it is to develop the machine. Therefore, instead of standard components, IMA DAIRY & FOOD often installs custom machine parts, which is a challenge for the entire supply chain.

The machine components are procured on the global market by the brands ERCA, GASTI, HAMBA, HASSIA and INTECMA, which all belong to IMA DAIRY & FOOD. Almost 3,000 suppliers service the companies in Germany, Italy, France and Spain. In such a market, it is impossible to maintain a group-wide overview and strategically optimise procurement without using digital tools.

Challenge

Within the IMA DAIRY & FOOD Group, several companies worked in their own organisational structures with different suppliers and different ERP systems. A uniform view of the entire supply chain was therefore not possible. Due to the spread-out locations and systems, a comprehensive evaluation of the data was not performed. Potentials regarding the cooperation with suppliers remained unutilised as a result – and these are of particular importance for IMA DAIRY & FOOD. It is part of the company’s philosophy to see suppliers as partners and to maintain long-term business relationships in order to work with them to mutually optimise quality and processes.

Solution

In order to get a uniform view of their supply chain, IMA DAIRY & FOOD developed a central data model together with adesso. The technological basis for it was the Qlik platform. Different data sources were merged using the data analysis tool Qlik Sense Enterprise for Windows. Data from ERP systems from SAP, Sage and RPS, as well as from other systems, such as PLM (product lifecycle management) systems, were connected via interfaces.

The centralised data model provides the packaging machine manufacturer with a consolidated representation of its supplier structure, outgoings and savings. The information is displayed in a customised dashboard, which means everyone involved has a quick overview of everything that is important – across systems and companies. The dashboard, which is updated daily, not only provides rigid reports, but it is also the starting point for performing flexible analyses and more in-depth evaluations, for example, according to commodity groups, countries of origin or quality criteria.


‘We were impressed by adesso’s collaboration with us. Everyone involved was on equal footing right from the start and immediately understood what we wanted. In the workshops, we got a feel for all the things you can do with the centralised data platform.’
Till Dinger, Project Director, IMA DAIRY & FOOD Holding GmbH
‘With our centralised data model, it is possible to achieve savings of between eight and ten per cent.’
Ingolf Bleyer, Director Supply Chain, IMA DAIRY & FOOD Holding GmbH

Result

With adesso’s help, IMA DAIRY & FOOD has created a transparent system that offers all companies a consolidated view of the supply chain. Delivery qualities and outgoings are easy to record, and expenditure is analysed quickly. The bottom line is savings in purchasing volume and noticeable value creation within the entire IMA Dairy & Food Group.


Customised solutions for the dairy and food industry: Marketing dairy products poses specific challenges for today’s packaging industry. Extending product shelf life by sterilising the packaging material while still maintaining the specially designed packaging to support brand identity is not always an easy task. That is why IMA DAIRY & FOOD develops state-of-the-art form fill and seal (FFS) machines for cups, portion-sized packs, stick packs and sachets as well as fill and seal (FS) machines for pre-made cups, trays and bottles.
Logo IMA DAIRY & FOOD HOLDING

Do you have any questions?

There is no website or brochure which can replace a personal meeting to talk about your goals and topics. We are looking forward to an appointment on site.

Contact

Save this page. Remove this page.