Sistema de business intelligence para mapeamento do nível de qualidade dos fornecedores da cadeia de suprimentos.

Abstract

Efficient quality management in the supply chain is a decisive factor for industrial competitiveness, however many organizations still lack a clear mapping of quality information regarding their suppliers’ products or base their decisions on raw metrics that mask financial losses. The objective of this work was to develop and implement a Business Intelligence (BI) system capable of mapping and quantifying supplier quality levels strategically. The methodology adopted consisted of modeling and creating a relational MySQL database, managed by a web application developed in PHP with MVC architecture for recording non-conformities. For data analysis, Microsoft Power BI was used to build dashboards. The system validation occurred through the simulation of scenarios that compared traditional metrics, such as unit price and total defects, with advanced indicators calculated by the system, specifically the Part Per Million equivalents (PPMeq) and the Effective Cost per Good Part. The results demonstrated that the use of BI corrected erroneous interpretations generated by the exclusive analysis of raw data, in addition to allowing for the precise identification of critical suppliers and development opportunities through quadrant charts. It is concluded that the proposed solution enables the transition from reactive management to a proactive approach and ensures greater assertiveness in strategic decision-making and mitigation of poor quality costs.