Criação de um dashboard para auxiliar na etapa analyze da metodologia DMAIC aplicando ferramentas Lean Six Sigma

Abstract

Searching for a competitive increase and increase in productive performance, many companies are betting on data analysis as a business tactic. With this, methodologies such as Six Sigma become important in the analysis and refinement of this data, eliminating waste in the production process and increasing the performance of companies. With the great availability of data, it is possible to implement Business Intelligence (BI) and Digital Transformation (DT), which makes these analysis more assertive and robust. The present paper aims to generate a dashboard for the application of a Six Sigma methodology in generic banks of data in an assembly line of heavy equipment located in Curitiba with the help of the Microsoft Power BI tool, seeking to generate Digital Transformation and to highlight opportunities to reduce costs. This project used a modified version of the DSR (Design Science Research) Methodology, as proposed by Wieringa. The study generated a dashboard as proposed using Bar graphs, Pareto diagrams, pizza graphs and control charts, in a way that assist the analyze phase of the DMAIC cycle. The tool created successfully pointed out several opportunities to reduce costs, showing where to strike for greater savings, the tool also showed the potential to be expanded and used with other databases others than the one utilized by the authors.