With growing data volumes and new business demands, Heineken Srbija needed to improve its in-house BI solution. In cooperation with Comtrade System Integration, the existing BI solution was enhanced with new features providing Heineken Srbija with a reporting tool capable of supporting modern business demands.
Heineken Srbija has a clear roadmap of business objectives that should be achieved through business intelligence. In recent years, the company has implemented a number of BI features on their own.
Heineken had been using Microsoft BI that was developed in-house and was used for sales monitoring and analysis, as well as inventory tracking.
To support business development, there was a pressing need to introduce an expandable system with simple maintenance.
Although the previous solution was developed in-house, additional business requirements and hard imposed deadlines led Heineken to outsource these services and engage an external partner. Using best practice methodologies, Comtrade System Integration delivered the solution on time, which was invaluable for the long-term cooperation with the client.
The first step was to investigate and analyze the existing BI analytical cubes in order to identify opportunities for improvement. At the same time, in close cooperation with the Heineken team (IT and business users), Comtrade SI performed analysis of data sources and new business requirements. Key implementation steps consisted of data integration (ETL) development in MS SQL Integration Services tool, and analytical cubes modeling in MS SQL Analysis Services tool, as well as redesign and reengineering steps taken in order to improve performance and informational capability of existing reports. The final step before deployment was testing, which consisted of end-to-end integration testing and end user testing.
The project included extension of the existing cubes’ dimensions, as well as their redesign with an aim to improve performance. Moreover, new cubes were implemented in the areas of commerce and finance/controlling. With the aforementioned measures, the company is able to monitor plan realization across time, as requested by stakeholders.
Microsoft was selected as technology of choice as it was already used in-house. Therefore, no additional licenses were required and the technology was able to support the specific needs of the project.
Optimization of the existing BI solution was essential for Heineken to maintain its competitive edge. Report generation is now much faster and automated – a process which previously required exporting several reports from the base system and and was prone to errors.
The optimized BI solution with a new reporting domain delivered the following benefits:
Adding new dimensions to the existing cubes, enabled the company to monitor several new parameters.
Furthermore, the existing cubes’ design is simplified and based on a data model, which is easy to expand and maintain.
By enhancing the existing solution and implementing new features, Heineken Srbija now has a modern, flexible and scalable BI solution capable of supporting current and future business needs.
Heineken Srbija currently operates two breweries in the cities of Zaječar and Novi Sad. Its parent company, Heineken, is the number one brewer in Europe, as well as the world’s third brewer by volume. On a global level, Heineken operates in 70 countries and employs over 85,000 people.