Programa anual de manutenção preventiva, aplicando business intelligence na otimização do processo de gestão: estudo de caso de uma subestação de 69 kV

Abstract

For the proper functioning of a substation, it is necessary to properly carry out preventive maintenance procedures, as well as the efficient management of the data obtained, favoring the decision-making process. In this sense, it was relevant to study the application of a business intelligence tool to optimize the process of managing information acquired from a preventive maintenance program carried out in a 69 kV substation. This work aims to compare the most relevant business intelligence tools on the market, in order to define which one will be used in the study, study preventive maintenance processes, aiming to understand which information is relevant for the preparation of dashboards and develop a platform based on in business intelligence to present information clearly and accurately. The research methodology used to prepare the work was the case study of using the Power BI tool to manage the data obtained from the annual preventive maintenance plan. The entire interface production process is described, pointing out the most relevant points. The developed platform is compared with the solution currently used, in order to evaluate the benefits generated by implementing the new solution. The results indicate that the more visual nature of Power BI favors the interpretation of data, facilitating the diagnosis and decision-making processes.