POWER BI SOLUTION FOR A TOP LUBRICANT BRAND

About Company

A multinational lubricant company, consistently outperforming within its industry. With regards to brand awareness, purchase consideration and other parameters, its position in top 3 lubricant brands, with a global presence in around 100 countries. A rich motorsport history and have sponsored and partnered with various esteemed sports associations such as IPL, Manchester United Football Club, World Endurance Championship (WEC) and World Super Bike Racing (WSBK).They have pan India network of 320 auto distributors, 30 industrial distributors and over 50000 retailers, backed by the logistics support of 33 depots, five regional offices and a corporate office in Mumbai.

Project Summary

Being a fastest growing lubricant player by consistently outperforming the industry growth rate they needed a feasible, economic BI tool with report automation, incremental refresh, and many other visual features. A cost-effective Power BI dashboard solution that can pull data from multiple data sources, maintain business logic, is user friendly and outperforms other reporting solutions in its look and feel was implemented.

Challenge

Client being a leading oil manufacturing company, their executives were required to view year over year analysis of their oil products but required extensive importing of data for last 3-4 years and upcoming predictions in a reporting solution. Client maintained a lot of information in separate spreadsheets that had to be manually loaded in the system and the report being built using multiple sources led to not only waste of time and effort but also delayed decision making and was non-intuitive for executive consumption. They wanted to automate this behaviour since loading the spreadsheets in system requires multiple decisions and efforts.

Solution

We assigned a team of expert Power BI consultants and engineers that worked on-site at client location and built 3 critical reports and 20 business reports. Critical reports were built within 20 working days that included requirement gathering, understanding the process with their business team, IT team, data team and SAP vendor team to extract data from SAP Business Warehouse.

Microsoft Power BI provides ā€˜nā€™ number of features like incremental refresh, drill-up and drill-down, automation, natural language Q&A, custom visualizations.

Country

India

Industry

Oil & Energy

Organization Size

Corporate (10000+ Employees)

Solution

Big Data & Analytics

Products & Services

Power BI
Data Gateway
Azure SQL Database