Aplicação de Business Intelligence para gerenciamento da manutenção de subestações de alta tensão

Abstract

This work aims to study the application of the Business Intelligence methodology to help the maintenance management of high voltage substations of distribution concessionaires, carrying out a theoretical review of the main maintenance concepts, substations and architecture of a Business Intelligence environment. This study is motivated by the great importance of high voltage substations for the electrical system and the need for the maintenance manager to guarantee the continuity and reliability of the operation of these facilities. As specific objectives, the computational tool Power BI was studied, the Extract, Transform and Load process and dimensional modeling were used to implement a Data Warehouse from the database with work orders of a distribution company and create dashboards with the Pareto diagram and the histogram with normal curve. These graphical representations allow the maintenance manager to visually identify the main causes of interventions and which equipment has a number of interventions above the acceptable. In this way, Power BI and Business Intelligence concepts proved to have a lot to contribute to the maintenance management of high voltage substations.