Practice of building a corporate data warehouse in the oil and gas sector

Abstract

Introduction. Effective managerial decision-making largely depends on having timely access to current information about asset status. Data on such business structures are typically fragmented and interdependent, necessitating a systematic approach to their consolidation and interpretation.

Aim. The article examines the experience of building a corporate data warehouse based on disparate data from operational source systems to enable comprehensive analysis of asset status.

Materials and methods. To achieve the goal, a list of key company performance indicators at diff erent management levels was determined, the advantages and disadvantages of the architectural approaches of William Inmon and Ralph Kimball to building a corporate data warehouse were analyzed, and the difficulties in eliminating inconsistencies in source system models and ensuring the required level of information security in architecture components were investigated..

Results. A real example of constructing a hybrid architecture for a corporate data warehouse based on the approaches of William Inmon and Ralph Kimball is provided. ETL processes for loading data into the warehouse and populating data marts have been configured. A module for loading data absent in the systems has been developed. Monitoring and risk analysis of the constructed architecture have been conducted.

Conclusion. Building a corporate data warehouse indeed presents numerous challenges in architecture development and ETL process confi guration. Real-world integration examples, including the one provided in this article, serve as valuable benchmarks for understanding implemented strategies. They demonstrate the practical application of integration frameworks, technologies, and methodologies, and offer insights into lessons learned and key factors that contributed to successful integration projects.