☏ +60 3 2712 9999   ✉ info@avowsit.com

Data Unification - Oil and Gas

Data Unification - Oil and Gas

CLIENT

The client is an integrated oil and gas services company based in Malaysia.

It has established its presence in over 20 countries, such as China, Australia, United States of America, and those in Western Africa and the Middle East, employing approximately 22,000 people.

Challenges

Client's data resided in disparate systems and lacked consistencies for any C-level executive analysis.

This resulted in a very tedious exercise which took several days to achieve.

Hence, an immediate need to bring data together with advanced analytics and visualisation techniques to enable quicker insights and better decision making.

The data was also assimilated by extracting data from email attachments. The daily progress reports (DPR) in multiple Excel formats. Additionally project status reports for over hundred projects from eight departments were also received from Vessels to central collation authority.

This resulted in a very tedious exercise which took several days to achieve. Hence, an immediate need to bring data together with advanced analytics and visualisation techniques to enable quicker insights and better decision making.

Solutions

Avows partnered with the client to understand the client’s organisation data sets and the different systems along with data storage access points to arrive at the complete blue print for organisational data from its creating to where it was residing.

The extracted data was collated in SAP BW. The process was re-engineered to reduce the complexity and achieve standardization. The project and financial reports and dashboards were built using Power BI.

We then created a solution to bring all data together for analytics and for advanced dashboards for C-level executives.

Benefits

The collected data is in better structured format and the reporting is now in near real time.

Gain a seamless environment that includes data visualisation and analytics integrated with communication tools, and specialised business applications.

Capitalise on customers’ existing Microsoft based technology to accelerate progress towards the next innovation in data analytics.

The customer has successfully migrated more than 46 metrics across 4 critical datasets from Spreadsheet into a SAP BW Platform for their daily, weekly and monthly reporting empowered by our design principles on Power BI platform.

Analytics and business intelligence teams, formerly dependent on IT or support teams are now able to create and prepare the data themselves.