This case study, developed in the Standardization and Quality Control 2025-1 course, analyzed the capping and sealing process in beverage production under Quality 4.0. Using SIPOC, key variables were defined: defective caps (discrete) and closing turns (continuous). Data collection stage enabled BI control charts, p-charts, and Gage R&R by attributes with risk analysis method for assess measurement reliability. From 1,978 caps across 56 batches with 3 operators, high defect rates linked to raw material variability, poor inspection, and unstandardized procedures were found. Corrective actions included stricter inspections, supplier renegotiation, and process standardization. Integrating R-Studio with Power BI enabled real-time dashboards for defect monitoring, supporting data-driven decisions. This approach demonstrates how statistical methods and BI tools enhance quality control, offering potential for predictive analytics, anomaly detection, and broader industrial applications.

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

Quality Control in Beverage Production – Cap Defects Analysis Using an Integration of R-Studio in Power BI

  • Espitia Rodriguez Arcesio,
  • Carmen E. Patiño-Rodríguez

摘要

This case study, developed in the Standardization and Quality Control 2025-1 course, analyzed the capping and sealing process in beverage production under Quality 4.0. Using SIPOC, key variables were defined: defective caps (discrete) and closing turns (continuous). Data collection stage enabled BI control charts, p-charts, and Gage R&R by attributes with risk analysis method for assess measurement reliability. From 1,978 caps across 56 batches with 3 operators, high defect rates linked to raw material variability, poor inspection, and unstandardized procedures were found. Corrective actions included stricter inspections, supplier renegotiation, and process standardization. Integrating R-Studio with Power BI enabled real-time dashboards for defect monitoring, supporting data-driven decisions. This approach demonstrates how statistical methods and BI tools enhance quality control, offering potential for predictive analytics, anomaly detection, and broader industrial applications.