Oil & Gas
5,000 – 10,000
The client is a multinational energy corporation. They supply fuel to some of the world’s largest airlines, shipping companies and power suppliers. With a widespread global network, their oversee operations include 100 storage terminals, 3,000+ retail sites, and a presence at over 80 airports. Their oil terminals and depots capture multiple operational data points adding up to humungous organizational data.
The client teams owned several terabytes of data. However, they had no way to automatically consolidate, visualize or report it. This did not help with improving operational efficiency and gave rise to multiple challenges such as –
The client’s business challenges required technical upgrades and tailored solutions providing actionable intelligence through data visualization. Leveraging the client’s existing database in the Azure Ecosystem, we designed and deployed an architecture consisting of Azure SQL, Azure Active Directory, Azure Analysis Service and Power BI. It enabled pulling of data from multiple sources and generated automated custom reports. These reports would cater to all the operational departments and their individual needs. Using Embedded Power BI, automated reports were generated for multiple stakeholders, based on these specific KPIs around –
Using Power BI also enabled the workforce on terminals and depots to rectify manually entered data. The accuracy of new reports improved exponentially. Power BI became the default custom report generation tool for the client teams.