Creating Opportunities from Production Loss Reporting using Business Intelligence
Authors: Khan Shamsuddin Ahmad , Hussain Syed Mazhar 
Published: November 2015

Abstract
A system developed by Abu Dhabi Gas Liquefaction Company Limited (ADGAS) to create opportunities from Production loss. This reporting and analysis tool provides key information about how ADGAS is performing in terms of LNG production & areas of improvement. Production Opportunity Loss reporting is key driver of process enhancement, initiating root cause analysis (RCA) for critical events, process enhancements, investments feasibilities for plant modifications and understanding of the Company's financial position.
Daily production and opportunity losses reporting is a key driver of ADGAS production process enhancement; these reports are used by the Company's senior management to make decisions and go to Marketing to calculate financials.
The key success factor in Opportunity Loss Management system is depending on the followings: Accurate data recordingCategorization of lossesRCA to find real problems in the processesAnalyze information in graphical format better visibilityComparing trends over the periodEasy accessibility of information to the management
Earlier in ADGAS, it was not possible to capture data and analyze it directly from the source. The data were analyzed in Excel and the reports were then created.
This carried the risk of errors in data integrity and accuracy, possibly leading to inaccurate reports and faulty recommendations.
In addition, data capture and analysis required considerable man-hours and depended on the experience of dedicated personnel, creating a risk to business continuity.
Business intelligence Analytical Tool is used to provide Dashboards and intelligence reports. Historically these data were downloaded from ERP system and copied into Excel spreadsheets for compilation and analysis. Usefulness of reports was limited because investment scenarios cannot be evaluated to identify the potential costs and benefits of plant modifications and enhancements. Business Warehouse was selected to meet requirements for data extraction, compilation and reporting, thus data could be read by Business Objects and graphical presentations created for reporting.
This system provides immediate, on-line access to employees to the most current data, users across all lines of business to make timely, data-driven decisions.
This information system provides foundation to ADGAS infrastructure to extend to other systems. This solution can grow with ADGAS, allowing organization to employ additional tools and eliminating need to stitch together various disparate solutions which result in bulky, user-unfriendly system. Business continuity–helps to support business continuity and sustainability by reducing dependence on individual employees. New employees can be deployed to use the solution without affecting the reporting cycle.Flexibility – Business Objects reports can be modified or expanded, according to end user requirements.Accurate reporting–risk of inaccurate data in reporting is virtually eliminated because data no longer need to be downloaded for analysis.Efficient resource allocation – analysis is simplified from start to finish, requiring fewer resources, saving costs and increases overall efficiency.Speed – reports and analysis are faster, improving their usefulness.Accurate attribution of causes leading to better RCA – because data are extracted directly from DCS sources, accuracy is ensured. This results in better attribution of the causes of production gaps and thus reliable RCA.