Modern technology improves product quality control at a large brewer

Background

This development is the latest milestone in the leading brewery’s long-term partnership with Keyrus on a company-wide journey to full digital transformation.

Challenge

Namibia Breweries turned to our team of experts again with a requirement to redesign its legacy application, modernise the architecture of data storage and flow, and enhance the user experience of its product quality control reporting tool. Additionally, an improved management reporting on the product quality matrix with modern architecture and its scalability was required.

Approach

Keyrus team completely redesigned the original MySQL database, which was structured more as a warehouse, into a star schema. This creates an on-premise MSSQL database suitable for transactions and allows for a quick, responsive web application. It also helps to remove data that was duplicated throughout the tables. ASP.Net was used as the framework for the rebuild focused on the end-user experience. The new solution is linked to a Tableau front-end to enable end users to access, analyse and report on the data. It encompasses Row-Level Security (RLS) using Entitlement tables. This enables tiered access of the data based on the access levels granted to the individual users.

Key results

Benefits

A modern, scalable solution that has significantly increased reporting speed, improved user experience, and boosted productivity. Alongside increased speed, reliability, and agility, Namibia Breweries acquired a faster quality testing process to enable more agile product testing and distribution. the system further improved management reporting on the product quality matrix with modern architecture and scalability. In addition, there was a total re-design of the data flow, or storage logic, to support rigorous data management. The solution has significantly reduced application load times resulting in greater speed and little to no latency. The user experience has also been significantly improved through the addition of a modern front-end and improved ease of use. This ensured a seamless transition to the new application, reducing downtime and increasing user adoption.

What our clients say

The solution has significantly reduced application load times. The user experience has also been significantly improved through the addition of a modern front-end and improved ease of use.

Andre Engelbrecht , Industrial Control Systems Mng, Namibia Breweries

Share this key play