Modelamiento dimensional de la información de producción de crudo de dos Campos Petroleros del Grupo PETROGAS S.A con Qlik plataforma de analítica de datos para Business intelligence

Abstract

Petrogas S.A. group and its subsidiary companies manage large volumes of data and information of various kinds, being of great relevance the one referring to the production of crude oil in its two oil fields. There is a need to map and model such information in dashboards and reports with the data and indicators of the extraction of crude from the Gustavo Galindo Velasco Field - Santa Elena Peninsula and Tiguino Field in the Coca - Ecuadorian East. Currently this information is entered into some applications and the reports are generated in flat files called "production sheets"; hence this initiative to add value and significantly improve data interpretation through a robust, fast and scalable platform for all members of the organization. We proposed the creation of a board that contains all the information regarding the extraction of crude oil with its respective indicators and the data can be visualized and interpreted in a graphic and dynamic way, as well as a board to geolocate the wells of the two fields. The SCRUM methodology was used for the development of the project. In order to determine the requirements and the fulfillment of these, meetings called "sprint" were held where the progress of the project was recorded. The prototype of the application was designed and modeled on a BI Qlik Sense platform. A process of data extraction, transformation and loading (ETL) was developed to collect all the necessary information from the various sources of information available and be presented through graphic elements, statistical maps, depending on the interest group of each area of the company, leveraging effective decision making and timely access to information.