Developing an energy consumption monitoring tool based on the Power BI platform for refineries
Abstract
Monitoring energy consumption and efficiency in oil refineries is crucial for operational performance. While traditional tools such as Excel-based calculations can still serve basic monitoring purposes, the rapid advancement of digital transformation has led to the emergence of new tools with significantly enhanced capabilities.
The energy consumption monitoring tool is developed as a versatile template model to track energy consumption, energy intensity index (EII) and related parameters. Input data is collected and presented on an Excel platform, stored in the cloud, automatically updated and visualized using Power BI.
The model integrates data processing, digital transformation, and calculation of necessary factors and parameters based on Solomon standard procedure, similar to the methods used in refineries. Consequently, the model's computational results closely match the data calculated by the refineries when applied to specific cases.
By utilizing this energy consumption monitoring model, refineries can track and monitor the energy structure and efficiency of individual units/areas and the entire plant over different time periods, identifying priority areas for implementing energy-saving measures implementation and energy efficiency improvement. In addition, the model also calculates CO2 emissions from energy consumption in the refinery, which is the basis for monitoring greenhouse gas emissions when legal regulations on management CO2 emissions and carbon credits are issued and applied.
References
Solomon, “Quy trình tính toán và đánh giá chỉ số cường độ năng lượng EII”, 2020.
BSR, “Dữ liệu vận hành của nhà máy lọc dầu”, 2023.
Tomorrow Marketers, “Cách xây dựng data relationship trong Power BI”. [Online]. Available: https://blog.tomorrowmarketers.org/cach-xay-dung-datarelationship-trong-power-bi/.
Technip, “Tài liệu thiết kế nhà máy lọc dầu”, 2008.
IPCC, “Phương pháp quy đổi nhiên liệu và phát thải”, 2020.
1. The Author assigns all copyright in and to the article (the Work) to the Petrovietnam Journal, including the right to publish, republish, transmit, sell and distribute the Work in whole or in part in electronic and print editions of the Journal, in all media of expression now known or later developed.
2. By this assignment of copyright to the Petrovietnam Journal, reproduction, posting, transmission, distribution or other use of the Work in whole or in part in any medium by the Author requires a full citation to the Journal, suitable in form and content as follows: title of article, authors’ names, journal title, volume, issue, year, copyright owner as specified in the Journal, DOI number. Links to the final article published on the website of the Journal are encouraged.
