Automatización de la captura y análisis de datos de producción en planta industrial mediante SQL y Power BI

Read full text Summarise with VIRAT
Authors: Nicolle Stefanny Ballesteros Suarez
Cited by: 0
References: 10

Summary

No summary yet. VIRAT can read this paper and write a plain-language summary of its aim, methods, key findings and limitations.

Summarise with VIRAT Free to try with your Science Catalogs account.

Abstract

This project aims to update the production order management system in an industrial plant, which is currently carried out using spreadsheets and macros. These tools are valid, but nowadays they generate errors, are not controllable, lose traceability, and are highly dependent on manual input. Therefore, the aim is to study the feasibility and develop an automated solution for data capture and analysis. The goal is to replace error-prone manual processes with an SQL-Power BI architecture that centralizes information and facilitates real-time analysis. The SQL database will ensure that records are reliable and accessible to all, while Power BI will allow this data to be exploited with dynamic dashboards that provide insight into the status of production in real time. Ultimately, the goal is to ensure that decision-making does not depend on Excel files that are corrupted or difficult to maintain, but rather on real indicators of efficiency and productivity, achieved with free tools. The methodology focuses on automating data management so that the flow is continuous. A comprehensive study of the current situation has been carried out, looking at how orders are currently recorded, associating each product and operator with specific statuses such as starts, breaks, resumptions, etc. The work consists of designing an SQL structure that allows these events to be recorded and organized in such a way as to identify key indicators. This study is complemented by implementation in Power BI, where efficiency indicators and downtime can be visualized. All development was done under the premise of using free software resources, demonstrating that production control can be achieved without high software costs.

Fields of Study & Subjects

Big Data and Business Intelligence Industrial Automation and Control Systems Digital Transformation in Industry

Publication details

Journal / source
UPCommons institutional repository (Universitat Politècnica de Catalunya)
Publication date
6 February 2026
Language
ES
Document type
Thesis