×
Type in a topic service or offering and then hit Enter to search
Global Alcoholic Beverages

Global Alcoholic Beverages Firm Resolves Sales Data Challenges With Microsoft Azure And Power BI Stack

Highlights

Overview

Our client is a leading beverage multi-national, famous for some iconic alcoholic labels & brands. The Indian division of the company was facing difficulties in data accumulation and commercial reporting. India being a complex Alco-beverages market, posed all sorts of challenges related to varying liquor excise policies, complex routes to market and quotas split between Indian states and territories.

They were looking for a solution to manage this complex sales data with varying rules applicable across 29 Indian states. Move-to-cloud was a necessity to build a centralized data repository that would contain all the sales data to feed the analytical systems. They chose Azure SQL Database for storage and we helped them deploy an Azure Data Factory and Power BI based solution to automate the workflows and reports, to fuel strategic decision-making.

Underlying Practices

The regulatory and organizational practices were giving a hard time to the MIS team. There were disparate data entry systems across business units. Hence, all sales metrics reports/dashboards were maintained manually and use of Excel/Google Sheets was prevalent. These practices that worked in the past were not proving to be effective given the growing expanse and complexity of the business.

On top of these inefficiencies, all the data was accessible across the organization - leading to duplicacy, unmonitored changes that were creating chaos while reporting, coupled with the security and governance issues.

Key Challenges

Objectives & Implementation

The project was meant to deliver Commercial Performance Dashboards for the spirit manufacturer. The objective of the project was to provide a platform for stakeholders where they could track demography and territory-based information along with their assigned budgets & target quotas.

We helped the client move to Azure SQL DB to infuse scalability, flexibility into the enterprise data management practices. Moving to the cloud also led to a centralized repository whereupon, we created hierarchical table structures to define role-based access rights at the data warehouse level. To avoid any performance bottlenecks, an SSAS Layer was added and fed into the power reports and establishedestablish a live connection.

With Azure Data Factory, we created and scheduled data-driven workflows that could ingest and feed data from disparate sources into the centralized Azure Data Warehouse.

Microsoft Power BI has been used to offer intuitive and near-real-time reports and dashboards to business decision makers. To fast track reporting further, we enabled the Power BI solution with a Deployment Pipeline. With deployment pipelines, the environment migration of reports - Development to Test to Production - got streamlined. Different workspaces get created and Power BI users can either choose to allow full-deployment of all the new items created in the previous stages (like development or test) or can go for selective-deployment to just the update workspace with limited items only. The Power BI reports generated get updated seamlessly.

Key Impacts

More Case Studies

Interested In Learning More
About Our Service Offerings?

Copyright © 2021 Polestar Solutions and Services India Pvt. Ltd, All Rights Reserved.