The article considers the current and expected conditions of using tools of data processing by the oil producing company’s employees; it is stated that their level of IT knowledge does not fully correspond to the dynamic functioning and development of a system of continuous improvements. The main features and potential of Pivot Tables, VBA, Power Query, Power Pivot and Power BI tools are examined for their further application. There is described the investment process, its main difficulties and problems including the requirement to increase the level of detail of information, expand the list of reporting forms, as well as the transition to a matrix organizational structure by ensuring the interaction of project teams and structural functional units, which ultimately serves as a prerequisite for optimization. The main elements of optimizing the investment process are identified, including the formation of a data model, ensuring the collection of the necessary information, automation of data consolidation and developing final reports, a data storage and dashboards for analyzing the investment process results. A data model has been developed that includes a set of interrelated budget tables and directories providing a high level of detail in data analytics. Modules of registering budget information for the user experience have been created including a convenient user interface, automated calculations, protection against changes, a standardized form for entering comments, a system for coordinating information and a change log. A complex model of information processing has been presented including means for consolidating data and preparing final reports. A data storage has been formed that provides structuring of the results of the investment process and the ability to quickly extract information when constructing summary / comparative analytical information. A dashboard for monitoring the execution of IP has been developed available to interact by using web technologies as well as built-in on the user’s mobile phone, which doesn’t violate the corporate privacy policy. Approaches to assessing the qualitative and quantitative effect from the introduction of the described de-velopments are defined.
В целях ресурсосбережения на предприятии нефтегазовой отрасли разработаны мероприятия по снижению постоянных затрат с помощью изменения топливного режима Узловой котельной Южного филиала ООО «Газпром энерго». Произведено нормативное и техническое обоснование процесса. Внедрение в практику хозяйствования обоснованного плана мероприятий позволит снизить эксплуатационные затраты, оптимизировать численность персонала, сократить размер имеющихся материальных запасов, снизить арендную плату, что в целом будет способствовать ресурсосбережению и улучшению конечных показателей деятельности Южного филиала ООО «Газпром энерго», повышению экономической эффективности.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.