Improving processes of forming investment program of oil producing company by using digital business analysis tools

Abstract

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.