AI-Powered Data Management to Optimize Data Collection and Processing in a Painting Laboratory
Journal of Mechanical Engineering and Manufacturing · 2026
DOI: 10.53941/jmem.2026.100011 ↗Kurz gefasst
Fachartikel in der Zeitschrift Journal of Mechanical Engineering and Manufacturing, 2026. Verfasst von Maria Teresa Ribeiro Pereira und 4 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
Industrial laboratories often remain under-digitized compared to production lines, creating a gap between data acquisition and analytical intelligence, critical for advanced quality control. This study addresses this gap by proposing and validating a novel framework that combines Low-Code digitalisation tools with Machine Learning (ML) and Causal Inference to optimise data collection and analysis in an automotive painting laboratory. A Microsoft Power Apps-based platform was developed in order to digitalise all measurement records, eliminating manual transcription errors (previously ≈ 40.01%) and reducing data-handling time by up to 34% of an operator’s shift, while enabling centralised, traceable storage and Power BI integration. Four datasets were used to assess predictive capacity with Random Forest, XGBoost and Neural Networks; Random Forest consistently provided the most stable results—Mean Absolute Error (MAE) of 0.972, Mean Absolute Percentage Error (MAPE) of 16.45%, and Root Mean Square Error (RMSE) of 1.307. Causal models (Linear Regression, DoWhy, Causal Forest, Double Machine Learning) consistently identified ultrafiltrate I solid content of the electrodeposition process as a dominant causal factor for defects. This study provides a novel framework that bridges digitalisation and ML-based causal reasoning in laboratory settings, offering a scalable approach that can be extended and replicated in other industrial sectors, aiming to develop smart, data-driven quality control systems.
Zitieren
APA
Pereira, M. T. R., Pereira, M. J. G., Tavares, M. G., Guimarães, A. M., & Vilarinho, H. (2026). AI-Powered Data Management to Optimize Data Collection and Processing in a Painting Laboratory. Journal of Mechanical Engineering and Manufacturing. https://doi.org/10.53941/jmem.2026.100011
Vancouver
Pereira MTR, Pereira MJG, Tavares MG, Guimarães AM, Vilarinho H. AI-Powered Data Management to Optimize Data Collection and Processing in a Painting Laboratory. Journal of Mechanical Engineering and Manufacturing. 2026. doi:10.53941/jmem.2026.100011
BibTeX
@article{Pereira2026,
author = {Pereira, Maria Teresa Ribeiro and Pereira, Marisa João Guerra and Tavares, Miguel Guedes and Guimarães, André Martins and Vilarinho, Hermilio},
title = {AI-Powered Data Management to Optimize Data Collection and Processing in a Painting Laboratory},
journal = {Journal of Mechanical Engineering and Manufacturing},
year = {2026},
doi = {10.53941/jmem.2026.100011}
}
EUVIMED