Elaboração de um dashboard para a análise do overall equipment effectiveness de uma empresa do setor alimentício

Abstract

There are several indicators present in companies that seek to increasingly qualify, and one of the most relevant indicators in the production area are the Global Equipment Effectiveness (OEE) indicators. These indicators aim to measure the productive efficiency of an industry, analyzing data related to machine availability, performance, and quality. In this work, a project was developed to create a dashboard that ranges from data collection to the creation of a visual that facilitates the analysis of this data, transforming the database into graphs and other visuals. To obtain the data, Microsoft Excel software was used, stored in the cloud on the Microsoft SharePoint Online platform, data processing was carried out in the Power Query software (an extension of the Microsoft Power BI software) and the creation of the dashboard was carried out in the Microsoft Power software. BI. With the dashboard finalized, it was possible to obtain the results of these OEE indicators, with the Global OEE having an index of 65.56%. Furthermore, it was possible to simulate and analyze these results in other scenarios, changing the “availability”, “performance” and “quality” values. By analyzing these indicators, it is also possible to suggest which problems are most affecting the industry.