AI-Powered Data Management to Optimize Data Collection and Processing in a Painting Laboratory

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.