Multinational Brewing Company Leverages
Thousands of KPIs With Programmers’ Analytics App

With the help of Programmers’ Analytics App, businesses with outdated reports can now consolidate data from the previous month quickly. Then, they can automatically generate business insights with an expansive view of over 3,000 KPIs related to financial, supply chain, input costs, and logistics indicators.

Businesses of all sizes and in all different industries benefit from data sets that are expansive, well-organized, and regularly updated. Below, learn how a multinational brewing company effectively utilized the Analytics App to improve its bottom line.

Organizing and Learning From KPIs: The Brewing Company’s Challenge

During the early part of 2020, one of the world’s largest brewers faced a major business challenge. The company needed to provide leaders and decision-makers with a unified, timely, and single source of data that would reflect an accurate global view for supply chain financial data, KPIs, input costs, raw materials, and logistics indicators. This would be an intimidating task considering there are currently over 3,000 global KPIs that support the company’s worldwide supply chain daily.

The Problem With Typical KPI Reporting

At the end of 2019, the company had migrated to the Anaplan ERP for supply reporting. It’s incredibly robust for the group’s management needs. However, it didn’t allow the flexibility to provide business users with updated and consolidated reports of global KPIs. To fill this gap, Microsoft’s Power BI solution was selected. Yet consolidating KPIs in reports was a very slow process with a week delay and error vulnerabilities. This was due to the data extraction occurring manually from the ERP and then loading into Excel files with thousands of rows before being manipulated. Only after that process was the data available in Power BI with outdated reports from the previous month.

The Programmers Solution

Programmers was chosen as a technology partner to help the multinational drink and brewing company overcome this business challenge. The Chicago-based IT company develops business solutions with innovation and specialized technology leveraging digital and data intelligence.

Programmers initiated the project in March 2020, starting with identifying data in the ERP Anaplan and aiming at integration with Power BI. From that point, Programmers built a structured database with a 100% automated process to extract, store, process, and update the final report twice a day with over 3,000 KPIs. The final step was the delivery of the analytical application.

Today, this user-friendly and reliable platform brings global data and KPIs to the company’s decision-makers.

Programmers’ Analytics App Userbase Grows

“We are extremely pleased to contribute to this project that is reflecting on business in such a company and industry. With the data visualization platform, we developed together, the company can analyze and benchmark their operations, driving efficiency and internal competition across their business,” says Rafael Dourado, Programmers’ Data Analytics Manager.