Sistema inteligente de control de producción basado en power BI y automatización de datos

Ana María Sosa Pintle; Josefina Porras Aguirre; Violeta Martínez Ramírez; Luciano Machorro Teresa; Adrián Uriel Mezura Galindo

doi:10.61117/ipsumtec.v8i2.424

Authors

Ana María Sosa Pintle National Technological Institute of Mexico
Josefina Porras Aguirre National Technological Institute of Mexico
Violeta Martínez Ramírez National Technological Institute of Mexico https://orcid.org/0000-0003-1518-786X
Luciano Machorro Teresa National Technological Institute of Mexico
Adrián Uriel Mezura Galindo National Technological Institute of Mexico

DOI:

https://doi.org/10.61117/ipsumtec.v8i2.424

Keywords:

dashboard, Power Bi, TULIP, silos

Abstract

The following work outlines the stages of creating software automation that controls production flows within the industrial area. The project was developed using a practical and structured approach, based on the waterfall model methodology. This approach allowed the system to be built in stages, continuously validating its functionality with key users at the plant. Throughout the process, techniques such as requirements analysis, database design, no-code application development in Tulip, data modeling in Power BI, and key performance indicators (KPI) visualization were combined.

Downloads

Download data is not yet available.

Metrics

Metrics Loading ...

Author Biographies

Ana María Sosa Pintle , National Technological Institute of Mexico

ANA MARÍA SOSA PINTLE is a professor at the National Technological Institute of Mexico, Puebla campus. She studied computer science and obtained a master's degree in computer systems. She has 31 years of teaching experience at the Technological Institute of Puebla (January 1995 to present). She is an advisor for multiple professional residency projects, creativity contests, entrepreneurship, and InnovaTec.

Josefina Porras Aguirre , National Technological Institute of Mexico

JOSEFINA PORRAS AGUIRRE is a full-time professor at TecNM, Puebla campus. She studied for a Bachelor's degree in Computer Science and obtained a Master's degree in Computer Science, specializing in Databases. She has 29 years of professional experience. Lecturer at the Comitán Institute of Technology in the Bachelor's degree programs in Computer Science and Computer Systems Engineering (February 1, 1997 to September 14, 2021); Coordinator of the Computer Systems Engineering program (2005 to 2010), professor at the Technological Institute of Puebla in the Information and Communications Technology Engineering program (September 15, 2021 to date).

Violeta Martínez Ramírez , National Technological Institute of Mexico

Dr. Violeta Martínez Ramírez, who studied Computer Systems Engineering in Programming, holds a Master's Degree in Education Sciences and a Doctorate in Education. She is a professor in the Systems and Computing Department at the Technological Institute of Puebla, teaching mainly Programming in Information Technology and Communications Engineering. She is a PRODEP Desirable Profile (2020), leader of the Academic Body “Applied Computing” (2021), and head of Outreach Projects (2020).

Luciano Machorro Teresa, National Technological Institute of Mexico

MI. Teresa Luciano Machorro is a professor at TecNM, Puebla campus, with a degree in Computer Systems Engineering and a Master's degree in Engineering. She has 21 years of professional experience in teaching and academic-administrative management. She has been a professor at IT Puebla at various times between 2015 and the present. She has held management positions as Academic Deputy Director at IT Atitalaquia and Coordinator of ICT Engineering at IT Puebla. She has also held positions at TecNM and DGEST, as well as teaching and heading Human Resources at IT Tlaxiaco.

Adrián Uriel Mezura Galindo , National Technological Institute of Mexico

Adrián Uriel Mezura Galindo is an engineer currently completing his degree in Information and Communications Technology at the Technological Institute of Puebla. He has developed data analysis and process automation solutions during his professional collaboration with Stanley Black & Decker, where he implemented real-time information visualization and extraction systems for decision-making. His main areas of interest include data science, process optimization through technology, and the development of digital tools applied to industry.

References

Gobierno de México. Secretaría de Agricultura. Cinco estados con cinco estrellas en producción agrícola [Internet]. 7 mayo 2021 [citado 8 ago 2025]. Disponible en: [https://www.gob.mx/agricultura/articulos/cinco-estados-con-cinco-estrellas-en-produccion-agricola#:~:text=Ma%C3%ADz%20grano%20(6%2C440%2C205%20t)%20y%20jitomate%20(764%2C435%20t](https://www.gob.mx/agricultura/articulos/cinco-estados-con-cinco-estrellas-en-produccion-agricola#:~:text=Ma%C3%ADz%20grano%20%286%2C440%2C205%20t%29%20y%20jitomate%20%28764%2C435%20t).)

Gobierno de México. Secretaría de Agricultura. Lista, producción nacional de flores para los festejos del Día de la Madre [Internet]. 7 mayo 2021 [citado 8 ago 2025]. Disponible en: [https://www.gob.mx/agricultura/articulos/cinco-estados-con-cinco-estrellas-en-produccion-agricola#:~:text=Ma%C3%ADz%20grano%20(6%2C440%2C205%20t)%20y%20jitomate%20(764%2C435%20t](https://www.gob.mx/agricultura/articulos/cinco-estados-con-cinco-estrellas-en-produccion-agricola#:~:text=Ma%C3%ADz%20grano%20%286%2C440%2C205%20t%29%20y%20jitomate%20%28764%2C435%20t).)

Tijuana EDC. ¿Cuáles son las 10 industrias más importantes de México? [Internet]. 3 mayo 2025 [citado 8 ago 2025]. Disponible en: [https://es.tijuanaedc.org/cuales-son-las-10-industrias-mas-importantes-de-mexico/](https://es.tijuanaedc.org/cuales-son-las-10-industrias-mas-importantes-de-mexico/)

TULIP. Operaciones componibles: transformación continua [Internet]. España; 2025 [citado 8 ago 2025]. Disponible en: [https://tulip.co/es/](https://tulip.co/es/)

Real Academia Española. Diccionario de la lengua española: silo [Internet]. 2025 [citado 8 ago 2025]. Disponible en: [https://dle.rae.es/silo](https://dle.rae.es/silo)

Université Bordeaux. TULIP [Internet]. Francia; [citado 8 ago 2025]. Disponible en: [https://tulip.labri.fr/site/](https://tulip.labri.fr/site/)

Nine Altitudes. Tulip, el MES de la próxima generación [Internet]. [citado 8 ago 2025]. Disponible en: [https://9altitudes.com/es/productos/tulip#35696](https://9altitudes.com/es/productos/tulip#35696)

Asana. Qué es un KPI, para qué sirve y cómo utilizarlo en tu proyecto [Internet]. 16 ago 2024 [citado 8 ago 2025]. Disponible en: [https://asana.com/es/resources/key-performance-indicator-kpi](https://asana.com/es/resources/key-performance-indicator-kpi)

KYOCERA. Dashboard y su significado estratégico [Internet]. 2025 [citado 8 ago 2025]. Disponible en: [https://www.kyoceradocumentsolutions.es/es/smarter-workspaces/business-challenges/procesos/dashboard-y-su-significado-estrategico.html](https://www.kyoceradocumentsolutions.es/es/smarter-workspaces/business-challenges/procesos/dashboard-y-su-significado-estrategico.html)

Business School Barcelona. La importancia del dashboard en la gestión empresarial [Internet]. Barcelona: EAE; 28 nov 2024 [citado 8 ago 2025]. Disponible en: [https://www.eaebarcelona.com/es/blog/que-es-un-dashboard#:~:text=%C2%BFQu%C3%A9%20es%20un%20dashboard?,comprensi%C3%B3n%20de%20los%20datos%20reunidos](https://www.eaebarcelona.com/es/blog/que-es-un-dashboard#:~:text=%C2%BFQu%C3%A9%20es%20un%20dashboard?,comprensi%C3%B3n%20de%20los%20datos%20reunidos)

Córdova Viera Y, Martínez Borrego J, Córdova Viera E. Propuesta de metodología para el diseño de dashboard. Rev Cub Transf Dig [Internet]. 2021;2(3):56-7 [citado 8 ago 2025]. Disponible en: https://rctd.uic.cu/rctd/article/view/141

Moyano DMB, Molina MAC. Implementación de Data Mart en Power BI para el análisis de ventas a clientes en los Econegocios “Gransol”. Polo Conocim Rev Cient Prof [Internet]. 2020;5(1):647-73 [citado 8 ago 2025]. Disponible en: https://dialnet.unirioja.es/servlet/articulo?codigo=7436046

Vásquez RAD, Espinoza JLA, Cabrera MAC. Power BI como herramienta de apoyo a la toma de decisiones. Univ Soc [Internet]. 2022;14(S3):195-207 [citado 8 ago 2025]. Disponible en: https://rus.ucf.edu.cu/index.php/rus/article/view/2949

TULIP. Cómo funciona: una forma nueva y más inteligente de dirigir sus operaciones [Internet]. 2025 [citado 8 ago 2025]. Disponible en: [https://tulip.co/es/how-it-works/](https://tulip.co/es/how-it-works/)

Mingo Smart Factory. Mingo Smart Factory vs. Tulip: comparación en profundidad [Internet]. 25 abr 2023 [citado 8 ago 2025]. Disponible en: [https://www.mingosmartfactory.com/mingo-smart-factory-vs-tulip-in-depth-comparison/](https://www.mingosmartfactory.com/mingo-smart-factory-vs-tulip-in-depth-comparison/)

G2. Tulip: reseñas y detalles del producto [Internet]. 2025 [citado 8 ago 2025]. Disponible en:

[https://www.g2.com/es/products/tulip-interfaces-tulip/reviews](https://www.g2.com/es/products/tulip-interfaces-tulip/reviews)