Real-time charging process
Solution: BI & Analytics Category: Logistics Strategy Area: Logistics Company: Consumer Goods - Beverages Tools used: We use Analyze Service, Data Factory, SQL Server (Cubes and Procedures) and Power BI to achieve this success.
About the customer
It is a renowned Brazilian beverage company. Part of the group is the largest global beer manufacturer, dominating around 69% of the Brazilian market. In addition to beers, it also produces soft drinks, energy drinks, juices, teas and water. With a prominent position, it is the 14th largest company by net revenue in Brazil.
Challenge
The beverage industry leader faced the challenge of prioritizing and streamlining truck loading, reducing real-time loading time, which was originally 1 hour.
Solution
To address this challenge, we adopted an approach that involved allocating data into temporary tables for cleansing and transferring to facts and dimensions. This data was structured according to business rules on a high-performance basis, allowing Big Data manipulation in almost real time.
1 hour
that was how long the process took.
20 minutes
This is the time our client now takes for the process.
