Modelagem e análise de dados de manutenção de correias transportadoras

Abstract

Maintenance management applied to conveyor belts plays a fundamental role in operational reliability and resource optimization in industrial environments. In this context, this work proposes the computerization of the recording, storage, and analysis of maintenance data for an industrial conveyor belt through the modeling of a structured database and the development of an analytical report in Microsoft Power BI. The data used in the project are fictitious; however, they are based on a real-world scenario in order to preserve operational coherence and the practical applicability of the proposed solution. The system architecture includes the collection of simulated operational parameters from sensors installed on critical components of the conveyor belt, with storage in relational databases and cloud-based platforms using MySQL and Google Sheets. The data extraction, transformation, and loading (ETL) process is carried out using Power Query, supported by the M and DAX languages for analytical modeling, while the Python programming language is employed for data generation, process automation, and the development of data entry interfaces. As a result, a dynamic report is developed, enabling historical data consultation, correlation between diagnostics, processes, and work orders, as well as the visualization of relevant indicators to support decision-making. The proposed solution demonstrates potential to reduce fault diagnosis time, increase the data sampling rate, and promote the standardization of maintenance procedures, contributing to operational gains in the short and medium term.