Mastering the Momentum of Technology in Energy
Our customer, a petroleum refining and transportation company, embarked on a logistical cost analysis of their hydrocarbon supply chain with a focus on movement and storage.
Refine the Complex
Data Analytics and Insights to Make Intelligent Decisions
Our customer spends billions of dollars each year transporting and storing both raw materials and finished products before they reach consumers. However, complex monthly spreadsheets provided only limited visibility into logistical cost optimisation opportunities.
To gain a clearer understanding of how effectively these costs were being managed, the customer sought greater visibility into their logistics operations and related spending. They also wanted to leverage agile delivery practices, representing a new approach for the enterprise.
Driving Data Analytics
Optimising with Microsoft Azure DevOps
Our customer shared their vision: increase visibility and reduce logistics costs. They turned to us because of our delivery expertise and position as a trusted Microsoft partner.
We deployed a new data platform in the Microsoft Azure cloud, leveraging the latest services capable of handling structured, semi-structured and unstructured data. The platform was designed to support data growth over time while harnessing the power and flexibility of Azure Synapse. A key advantage was the ability to implement only the services required, giving the customer the flexibility to scale as demand increased.
We used systems such as SAP and SQL Server as source systems for daily data refreshes, with Power BI serving as the interactive visualisation interface for business users. Given the large volumes of data generated each day, the customer required a solution capable of moving data quickly and efficiently.
Azure Data Factory (ADF) provided a distributed platform that could rapidly load data from on-premises systems and other cloud sources. To help manage and track day-to-day delivery, source control and automated deployments, we used Azure DevOps Services, providing transparency for stakeholders and project sponsors throughout the engagement.
Going the Extra Mile
Improving Data Warehouse and Management
Working closely with our customer and their dedicated Microsoft data analytics architect, we implemented best practices and tailored the solution to exceed expectations.
Throughout the development and testing phases, we identified several issues and collaborated with both the customer and Microsoft to resolve them and enhance the overall solution.
Interested in a similar solution?
We deployed a new data platform in the Microsoft Azure cloud, leveraging the latest services capable of handling structured, semi-structured and unstructured data.
Real-World Results
Our customer established a centralised repository focused on the logistical costs associated with pipeline transportation. Data can now be extracted from multiple operational systems, integrated, standardised and presented through a consistent model that supports self-service reporting and business analytics.
The solution leveraged a shared platform used across various business areas. The initial implementation focused on pipeline transportation, with additional transportation modes planned for future phases. By designing and building a reusable platform, subsequent implementations required only a fraction of the initial effort, enabling the customer to make more efficient use of Azure while reducing costs.
Overall, our partnership helped the customer achieve greater savings through improved visibility into logistics costs and more effective management of their assets.