Desarrollo de un dashboard para la visualización de indicadores de gestión de mantenimiento de una línea de producción de agua embotellada
| dc.contributor.advisor | Velasco Peña, Marco Antonio | |
| dc.contributor.author | Cárdenas Bello, Marlon Ferney | |
| dc.contributor.author | Garzón Ladino, Santiago | |
| dc.contributor.orcid | Velasco Peña, Marco Antonio [0000-0003-4436-9443] | |
| dc.date.accessioned | 2025-05-30T19:12:53Z | |
| dc.date.available | 2025-05-30T19:12:53Z | |
| dc.date.created | 2025-05-08 | |
| dc.description | Este proyecto desarrolla un dashboard para Coca-Cola FEMSA, planta Manantial de agua embotellada, con el propósito de visualizar y analizar los indicadores de gestión de mantenimiento. Los indicadores principales incluyen costos de mantenimiento, valor de almacén de mantenimiento e indicadores de mantenimiento por paros de equipos. Se realizó una definición detallada de los indicadores, su impacto y relevancia en la gestión de mantenimiento. Para la extracción de datos, se emplea SAP, utilizando SAP GUI Scripting para automatizar la ejecución de tres transacciones clave. Los datos extraídos se procesan mediante Python y Pandas, permitiendo la integración de la información y la generación del dashboard final. Este desarrollo facilita la toma de decisiones basada en datos, optimizando el análisis de los indicadores y mejorando la eficiencia en la gestión de mantenimiento de la planta. | |
| dc.description.abstract | This project focuses on the development of a dashboard for Coca-Cola FEMSA, Manantial bottled water plant, aimed at visualizing and analyzing maintenance management indicators. The key indicators include maintenance costs, maintenance warehouse value, and equipment downtime maintenance indicators. The indicators were carefully defined, assessing their impact and relevance in maintenance management. Data extraction is performed using SAP, leveraging SAP GUI Scripting to automate the execution of three key transactions. The extracted data is then processed using Python and Pandas, integrating the information to generate the final dashboard. This development enhances data-driven decision-making, optimizing the analysis of key indicators and improving maintenance management efficiency within the plant. | |
| dc.format.mimetype | ||
| dc.identifier.uri | http://hdl.handle.net/11349/95825 | |
| dc.language.iso | spa | |
| dc.publisher | Universidad Francisco José de Caldas | |
| dc.relation.references | Ali-Khan, J., Raman, A. M., Sambamoorthy, N., & Prashanth, K. (2023). Research Methodology (Methods, Approaches And Techniques). San International Scientific Publications. https://doi.org/10.59646/rmmethods/040 | |
| dc.relation.references | Bayramova, A., Edwards, D. J., Roberts, C., & Rillie, I. (2023). Constructs of leading indicators: A synthesis of safety literature. Journal of Safety Research, 85, 469– 484. https://doi.org/10.1016/j.jsr.2023.04.015 | |
| dc.relation.references | Donaire, F., Durán, O., Vergara, J. I., & Arata, A. (2024). Maintainability Assessment during the Design Phase: Integrating MTA and UNE 151001. Machines, 12(7), 483. https://doi.org/10.3390/machines12070483 | |
| dc.relation.references | Duarte-Segura, E. (2023). Propuesta de implementación de dashboard para seguimiento de indicadores de calidad en salud. Universidad Distrital Francisco José de Caldas. | |
| dc.relation.references | Dwivedi, Y. K., Ismagilova, E., Hughes, D. L., Carlson, J., Filieri, R., Jacobson, J., Jain, V., Karjaluoto, H., Kefi, H., Krishen, A. S., Kumar, V., Rahman, M. M., Raman, R., Rauschnabel, P. A., Rowley, J., Salo, J., Tran, G. A., & Wang, Y. (2021). Setting the future of digital and social media marketing research: Perspectives and research propositions. International Journal of Information Management, 59, 102168. https://doi.org/10.1016/j.ijinfomgt.2020.102168 | |
| dc.relation.references | Faveto, A., Traini, E., Bruno, G., & Chiabert, P. (2024). Review-based method for evaluating key performance indicators: an application on warehouse system. The International Journal of Advanced Manufacturing Technology, 130(1–2), 297–310. https://doi.org/10.1007/s00170-023-12684-4 | |
| dc.relation.references | Ghanad, A. (2023). An Overview of Quantitative Research Methods. INTERNATIONAL JOURNAL OF MULTIDISCIPLINARY RESEARCH AND ANALYSIS, 06(08). https://doi.org/10.47191/ijmra/v6-i8-52 | |
| dc.relation.references | Hamasha, M. M., Bani-Irshid, A. H., Al Mashaqbeh, S., Shwaheen, G., Al Qadri, L., Shbool, M., Muathen, D., Ababneh, M., Harfoush, S., Albedoor, Q., & Al-Bashir, A. (2023). Strategical selection of maintenance type under different conditions. Scientific Reports, 13(1), 15560. https://doi.org/10.1038/s41598-023-42751-5 | |
| dc.relation.references | Harju, A., Schaëfer, K., Hallikas, J., & Kähkönen, A.-K. (2024). The role of risk management practices in IT service procurement: A case study from the financial services industry. Journal of Purchasing and Supply Management, 30(2), 100899. https://doi.org/10.1016/j.pursup.2024.100899 | |
| dc.relation.references | Ishaq Bhatti, M., Awan, H. M., & Razaq, Z. (2014). The key performance indicators (KPIs) and their impact on overall organizational performance. Quality & Quantity, 48(6), 3127–3143. https://doi.org/10.1007/s11135-013-9945-y | |
| dc.relation.references | Korhonen, T., Jääskeläinen, A., Laine, T., & Saukkonen, N. (2023). How performance measurement can support achieving success in project-based operations. International Journal of Project Management, 41(1), 102429. https://doi.org/10.1016/j.ijproman.2022.11.002 | |
| dc.relation.references | Kumar, U., Galar, D., Parida, A., Stenström, C., & Berges, L. (2013). Maintenance performance metrics: a state‐of‐the‐art review. Journal of Quality in 69 Maintenance Engineering, 19(3), 233–277. https://doi.org/10.1108/JQME-05- 2013-0029 | |
| dc.relation.references | Li, C., Chen, Y., & Shang, Y. (2022). A review of industrial big data for decision making in intelligent manufacturing. Engineering Science and Technology, an International Journal, 29, 101021. https://doi.org/10.1016/j.jestch.2021.06.001 | |
| dc.relation.references | Liberati, M. R., Sowa, S. P., May, C. A., & Doran, P. J. (2020). Making measures count: Structured indicator selection to improve program success. Environmental and Sustainability Indicators, 8, 100077. https://doi.org/10.1016/j.indic.2020.100077 | |
| dc.relation.references | Lutfi, A., Alqudah, H., Al-Daoud, K. I., Zaqeeba, N., Alrawad, M., & Almaiah, M. A. (2024). Technology factors and ERP system efficiency in the Jordanian industrial firms: does company size matter? Humanities and Social Sciences Communications, 11(1), 674. https://doi.org/10.1057/s41599-024-03198-9 | |
| dc.relation.references | Maletič, D., Maletič, M., Al-Najjar, B., & Gomišček, B. (2012). The role of maintenance regarding improving product quality and company’s profitability: A case study. IFAC Proceedings Volumes, 45(31), 7–12. https://doi.org/10.3182/20121122-2-ES-4026.00040 | |
| dc.relation.references | Maletič, D., Maletič, M., Al-Najjar, B., & Gomišček, B. (2014). The role of maintenance in improving company’s competitiveness and profitability. Journal of Manufacturing Technology Management, 25(4), 441–456. https://doi.org/10.1108/JMTM-04-2013-0033 | |
| dc.relation.references | Molęda, M., Małysiak-Mrozek, B., Ding, W., Sunderam, V., & Mrozek, D. (2023). From Corrective to Predictive Maintenance—A Review of Maintenance Approaches for the Power Industry. Sensors, 23(13), 5970. https://doi.org/10.3390/s23135970 | |
| dc.relation.references | Neri, A., Cagno, E., Lepri, M., & Trianni, A. (2021). A triple bottom line balanced set of key performance indicators to measure the sustainability performance of industrial supply chains. Sustainable Production and Consumption, 26, 648– 691. https://doi.org/10.1016/j.spc.2020.12.018 | |
| dc.relation.references | Pech, M., Vrchota, J., & Bednář, J. (2021). Predictive Maintenance and Intelligent Sensors in Smart Factory: Review. Sensors, 21(4), 1470. https://doi.org/10.3390/s21041470 | |
| dc.relation.references | Picozzi, P., Nocco, U., Pezzillo, A., De Cosmo, A., & Cimolin, V. (2024). The Use of Business Intelligence Software to Monitor Key Performance Indicators (KPIs) for the Evaluation of a Computerized Maintenance Management System (CMMS). Electronics, 13(12), 2286. https://doi.org/10.3390/electronics13122286 | |
| dc.relation.references | Pineda-Vásquez, J. (2023). Diseño de un Dashboard para la Gestión de Mantenimiento en la Empresa Productos Familia S.A Planta Rionegro. Universidad de Antioquia. | |
| dc.relation.references | Portilla-Morales, V. (2021). Diseño, creación e implementación de un Dashboard para el seguimiento de peticiones de servicios en el área de mantenimiento, planeación y control de FORD España [Maestría]. Universitat Politècnica de València. | |
| dc.relation.references | Rodríguez-Parra, Lady. (2022). Desarrollo de un dashboard para la toma de decisiones estratégica, en torno a los negocios de las facilidades de casualty. Pontificia Universidad Javeriana. | |
| dc.relation.references | Schönsleben, P. (2019). Tangible services and intangible products in industrial product service systems. Procedia CIRP, 83, 28–31. https://doi.org/10.1016/j.procir.2019.02.144 | |
| dc.relation.references | Shekarian, E., Ijadi, B., Zare, A., & Majava, J. (2022). Sustainable Supply Chain Management: A Comprehensive Systematic Review of Industrial Practices. Sustainability, 14(13), 7892. https://doi.org/10.3390/su14137892 | |
| dc.relation.references | Simovic, F. (2021). SAP Módulo PM - Plant Mainenance. In SAP. SAP. | |
| dc.relation.references | Sovacool, B. K., Bazilian, M., Griffiths, S., Kim, J., Foley, A., & Rooney, D. (2021). Decarbonizing the food and beverages industry: A critical and systematic review of developments, sociotechnical systems and policy options. Renewable and Sustainable Energy Reviews, 143, 110856. https://doi.org/10.1016/j.rser.2021.110856 | |
| dc.relation.references | Uher, J. (2018). Quantitative Data From Rating Scales: An Epistemological and Methodological Enquiry. Frontiers in Psychology, 9. https://doi.org/10.3389/fpsyg.2018.02599 | |
| dc.relation.references | Valencia-Enciso, N., & Sierra, R. Y. (2023). Dashboard para monitorización y visualización de resultados de aprendizaje en el proyecto curricular de tecnología en sistematización de datos e ingeniería en telemática. Universidad Distrital Francisco José de Caldas. | |
| dc.relation.references | van de Ven, M., Lara Machado, P., Athanasopoulou, A., Aysolmaz, B., & Turetken, O. (2023). Key performance indicators for business models: a systematic review and catalog. Information Systems and E-Business Management, 21(3), 753– 794. https://doi.org/10.1007/s10257-023-00650-2 | |
| dc.relation.references | Van Looy, A., & Shafagatova, A. (2016). Business process performance measurement: a structured literature review of indicators, measures and metrics. SpringerPlus, 5(1), 1797. https://doi.org/10.1186/s40064-016-3498-1 | |
| dc.relation.references | Varela, T., Zamorano, P., Muñoz, P., Rain, C., Irazoqui, E., Sapag, J. C., & Tellez, A. (2023). Evaluation of the implementation progress through key performance indicators in a new multimorbidity patient-centered care model in Chile. BMC Health Services Research, 23(1), 439. https://doi.org/10.1186/s12913-023- 09412-9 | |
| dc.relation.references | Wang, X., Kumar, V., Kumari, A., & Kuzmin, E. (2022). Impact of Digital Technology on Supply Chain Efficiency in Manufacturing Industry (pp. 347–371). https://doi.org/10.1007/978-3-030-94617-3_25 | |
| dc.relation.references | Zhao, G., Xie, X., Wang, Y., Liu, S., Jones, P., & Lopez, C. (2024). Barrier analysis to improve big data analytics capability of the maritime industry: A mixedmethod approach. Technological Forecasting and Social Change, 203, 123345. https://doi.org/10.1016/j.techfore.2024.123345 | |
| dc.rights.acceso | Restringido (Solo Referencia) | |
| dc.rights.accessrights | RestrictedAccess | |
| dc.subject | SAP | |
| dc.subject | Indicadores | |
| dc.subject | Python | |
| dc.subject | Dashboard | |
| dc.subject | Mantenimiento | |
| dc.subject.keyword | SAP | |
| dc.subject.keyword | Indicators | |
| dc.subject.keyword | Python | |
| dc.subject.keyword | Dashboard | |
| dc.subject.keyword | Maintenance | |
| dc.subject.lemb | Ingeniería Mecánica -- Tesis y disertaciones académicas | |
| dc.subject.lemb | Indicadores de gestión | |
| dc.subject.lemb | Fabricas -- Mantenimiento y reparación | |
| dc.subject.lemb | Industria de bebidas | |
| dc.title | Desarrollo de un dashboard para la visualización de indicadores de gestión de mantenimiento de una línea de producción de agua embotellada | |
| dc.title.titleenglish | Development of a dashboard to display maintenance management indicators for a bottled water production line | |
| dc.type | bachelorThesis | |
| dc.type.coar | http://purl.org/coar/resource_type/c_7a1f | |
| dc.type.degree | Monografía | |
| dc.type.driver | info:eu-repo/semantics/bachelorThesis |
Archivos
Bloque de licencias
1 - 1 de 1
No hay miniatura disponible
- Nombre:
- license.txt
- Tamaño:
- 7 KB
- Formato:
- Item-specific license agreed upon to submission
- Descripción: