Real time Data Visualization Enables Better, Faster Decision Making

Challenge

Our client a leading oil & gas company had millions of real time data recorded from Oil Fields. The large volume of data coming from multiple systems for different fields gave rise to following issues:

  • End users were not able to visualize real time data and make important business decisions on time.
  • Inability to predict directions on drilling wells, forecast and optimize production
  • Millions of records to be checked for data quality, consolidation and aggregation
  • Multiple processes to extract and store the aggregated data
  • Connectivity issues

Approach

iLink conceptualized, designed and developed an application with various components for the end user to visualize real time data and aggregated data.

We designed and developed back end services using third party API’s and in house (using .Net) APIs to connect with different real time sources such as OsiPi, GE Proficy, Honeywell PHP to pull data (tag, time and value) and store as it is for further processes to check for data quality and aggregation.

Solution

The solution was an ETL process using Kettle, SSIS to check quality of real time data, aggregate (hourly average, daily average, monthly average etc.…) as per business needs and store in database.

We created rich user interfaces to allow the client to visualize real time data (automatic refresh of UI for latest data) and aggregated data for continuous monitoring. 

Outcome

Reduced errors and important financial impact on ROI for client. 

Users were able to see real time data of oil fields from their offices. The client was bale to make important and critical decisions influencing activities in oil fields instantaneously based on the data reducing errors.

We created a system that aggregated data to help users to derive key financial metrics such as P&L, ROI, etc. Our team built various predicting models run on the data to help decide directions on drilling wells, optimize production, etc. Historic data of oil fields were stored in a structured way to be referenced at any time. 

    Etiam magna arcu, ullamcorper ut pulvinar et, ornare sit amet ligula. Aliquam vitae bibendum lorem. Cras id dui lectus. Pellentesque nec felis tristique urna lacinia sollicitudin ac ac ex. Maecenas mattis faucibus condimentum. Curabitur imperdiet felis at est posuere bibendum. Sed quis nulla tellus.

    ADDRESS

    63739 street lorem ipsum City, Country

    PHONE

    +12 (0) 345 678 9

    EMAIL

    info@company.com

    Cart