Karl Bindewald GmbH, Bischheim, Germany

The customer’s requi­re­ment was to bring tog­e­ther all silo con­trol, mal­ting and labo­ra­to­ry data on a uni­form plat­form. It should be pos­si­ble to fle­xi­b­ly expand the system with addi­tio­nal data sets. In order to sol­ve the­se chal­len­ges, data is collec­ted by the con­trol system auto­ma­ti­onX and trans­fer­red to the BI tool Qlik Sen­se via SQL data­ba­ses. In Qlik Sen­se, the data is con­su­med and ana­ly­sed by with reports and dash­boards. The reports can also be edi­ted and fur­ther deve­lo­ped by the customer.

With this solu­ti­on, the custo­mer recei­ves con­ti­nuous batch tracking with con­ve­ni­ent for­ward and back­ward func­tio­n­a­li­ty. Tem­pe­ra­tu­re cur­ves of the kiln or the indi­vi­du­al labo­ra­to­ry reports can also be view­ed for each batch. This means that the custo­mer is opti­mal­ly equip­ped for the future and meets all the requi­re­ments of the various sta­ke­hol­ders such as qua­li­ty manage­ment, custo­mer audits, etc. in the best pos­si­ble way by having access to all pro­duc­tion and qua­li­ty data via web brow­ser at any time.

Auftraggeber

Karl Bin­de­wald GmbH

Anlagentyp

Mal­t­house

Realisierung

2021 bis 2022

Projektumfang

• 3200 data points malthouse
• 2000 data points bulk storage
• 1 Ser­ver Qlik application
• 7 Pre­con­fi­gu­red reports and dashboards

Unsere Leistungen

• Con­cept design and consulting
• SQL-Daten­bank Engineering
• Crea­te Qlik data model
• Crea­te Qlik reports and dashboards
• Start-up
• Ope­ra­tor training

Eingesetzte Technologie

• Win­dows Ser­ver 2019
• Micro­soft SQL Server
• Qlik Sen­se

Ansprechpartner

Karl Zol­ler, Seni­or Pro­cess Auto­ma­ti­on Con­sul­tant, Schmid Auto­ma­ti­on AG