Learn how the multinational centralized data from all its distributors worldwide into a single report and successfully shared this information across the company in a dynamic and secure way.
PETRONAS Lubricants International (PLI) is the global lubricants manufacturing arm of PETRONAS, producing and marketing a wide range of automotive and industrial lubricants in over 100 countries worldwide.
The company sought out Dataside to achieve success in its strategy through a data analytics solution, which involved digitizing Petronas' vast volume of data to enable secondary sales analysis and improve commercial performance with its partners/distributors on a single global platform.
The main challenge
How to manage data from 17 countries in a single report, while considering user experience, information processing, and security, ensuring the report doesn't crash during a critical analysis?
Petronas is a multinational company, and in addition to these concerns, it was necessary to work on a project that would meet future needs, as the company is expanding, and more countries will soon be added to the report, increasing the volume of data to be managed.
In this context, Dataside's team of specialists identified two main pain points, specific to each scenario:
The project needed usability
Given the involvement of 17 countries, it was essential to include the respective languages so that each nationality could access the report equally.
In addition to languages, it was also necessary to include currencies according to each country, labeled as the local currency in the report. For a general parameter, the primary currency option was the US dollar.
The project needed to guarantee Data Security:
The technical team required a report that could support the global data volume of PETRONAS without compromising the dashboard’s efficiency.
The data needed to be dynamically released according to different access groups, such as countries, continents, and distributor groups, for example.
What was the final solution?
The solution proposed by Dataside was to architect the reports using Power BI and integrate the data from the PETRONAS Lubricants International Data Lake and SharePoint.
From there, a solution was presented for each requirement:
Creation of a Power BI application accessible to all authorized PETRONAS Lubricants International employees, integrating data from the Data Lake and SharePoint.
In Power BI, a filter was created to change the report’s language using a dynamic translation model integrated with SharePoint, allowing the client to add more languages if necessary. Additionally, a filter was created to select the desired currency.
Data interaction was simplified by breaking down a large report into smaller ones by topic. This also reduced the volume of data and made it scalable, keeping only the necessary data.
Creation of dynamic RLS (Row-Level Security) in Power BI with 5 different permission levels integrated into SharePoint, allowing the administrator to edit permissions and add or remove new users.
Of all the results achieved, the recognition, satisfaction, peace of mind, and security of our client are the most important. We delivered this project with the certainty that we met these expectations. More than just providing our services, Dataside is here to be a partner and boost our clients’ growth.
Bình luận