Strategies for the operational indicators analysis that make it easier the decision making in the company Extrusiones S.A using Power BI
Published
:Issue
:Section
:License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Downloads
Business Intelligence, information system, ETL, Power BI, decision making, analytics, dashboard, data, Power Query, DAX, scrum, manufacturing.
The following project details a proposal based on business intelligence for the company Extrusiones S.A looking for this becomes a tool that gather the most relevant data generated in the plant and supports the decision making of the teams that are part of the operational department of the company.
The research will be descriptive in nature with a quantitative approach and will use different data sources generated by the company's information system that serves as input for the development of the solution proposed under an ETL methodology using the Power BI software.
It is intended to impact the development of the company's data analytics projects from the identification of the data requirements of operational teams and present a methodology that allows extracting, transforming, and loading all the data necessary for the design and creation of dashboards in Power BI that will be visual tools for quick searching to identify waste and improvements in the plant.
This research will raise awareness among the company's employees about the value of making decisions based on data and will allow to deploy work plans that improve the operational performance of the plant that will positively impact the financial result and allow identifying improvement opportunities that seek to reduce costs and improve competitiveness and innovation as a value offer to the market.
xMojica Baltodano, M. A. (2020). Tableros de impacto de los datos de Coronavirus Covid-19 en América Latina y el mundo utilizando Power BI como herramienta de visualización. REICE: Revista Electrónica de Investigación en Ciencias Económicas, 8(15), 88-103. Disponible en: https://www.lamjol.info/index. php/REICE/article/view/9946
Colciencias (2017), Política de ética, bioética e integridad científica, Disponible en: https://minciencias.gov.co/sites/default/files/upload/ noticias/politica-etica.pdf
López Benítez, Y. (2018). Business Intelligence. ADGG102PO. Antequera (Málaga), IC Editorial. Recuperado de https://elibro.net/es/ereader/ biblioibero/124393?page=10
González Farran, X. Guitart, I. & Rodríguez, J. R. (2016).
¿Cómo planificar un proyecto de inteligencia de negocio?: ( ed.). Editorial UOC.
disponible en: https://elibro.net/es/lc/biblioibero/titulos/58548
Rovira Samblancat, P. y Pascual Cid, V. (2021). Analítica Visual. Como explorar, analizar y comunicar datos. 1. Madrid, Difusora Larousse - Anaya Multimedia. Recuperado de https://elibro.net/es/ereader/ biblioibero/217097?page=15
Jaime Mesías Cajas, Doris Karina Chicaiza Angamarca, María Liseth Álvarez, Kerly Roxana Vélez, (2023). Desarrollo de un sistema BI Inteligencia de Negocios para la toma de decisiones gerenciales: Caso práctico empresa CTLSPORTS. Revista Científica y Académica VICTEC, ISSN 2737-6214, Vol. 4, Nº. 6, 2023, págs. 86-104. Disponible en: https://dialnet-unirioja-es.ibero. basesdedatosezproxy.com/servlet/articulo?codigo=9042836
Suren Machiraju, & Suraj Gaurav. (2018). Power BI Data Analysis and Visualization. De|G Press, Disponible en: https://search-ebscohost.com.ibero. basesdedatosezproxy.com/login.aspx?direct=true&db=e000xww&AN=1893725 &lang=es&site=ehost-live
Greg Deckler, (2019). Learn Power BI : A Beginner’s Guide to Developing Interactive Business Intelligence Solutions Using Microsoft Power BI. Packt Publishing. Disponible en: https://web-s-ebscohost-com.ibero. basesdedatosezproxy.com/ehost/detail/detail?vid=2&sid=8c6ebb00-dfc1-4bd0- 8d54-53ee648d260b%40redis&bdata=Jmxhbmc9ZXMmc2l0ZT1laG9zdC1saXZl #AN=2252653&db=nlebk
Brett Powell. (2018). Mastering Microsoft Power BI: Expert Techniques for Effective Data Analytics and Business Intelligence. Packt Publishing. Disponible en: https://web-s-ebscohost-com.ibero.basesdedatosezproxy.com/ ehost/detail/detail?vid=2&sid=7e5f4f71-9573-4bbe-a364-5d587188e4db%40re dis&bdata=Jmxhbmc9ZXMmc2l0ZT1laG9zdC1saXZl#db=nlebk&AN=1775076
Mojica-Avila, E. M. ., & Contreras-Cáceres, M. E. . (2022). La importancia del análisis de los estados financieros. Reflexiones Contables, 5(2), 17–26. https://doi.org/10.22463/26655543.3602
Higuera-Vargas, R. E. ., & Contreras-Cáceres , M. E. . (2021). Aspectos fundamentales de los riesgos financieros y sus incidencias en Colombia. Reflexiones Contables, 4(1), 8–20. https://doi.org/10.22463/26655543.3595
Correa-Tellez, Y. A. ., Rico-Rojas, C. F. ., & Guardiola-Plazas, L. F. . (2022). Auditoría de la cuenta por cobrar. Reflexiones Contables, 5(2), 8–16. https://doi.org/10.22463/26655543.3600
The following project details a proposal based on business intelligence for the company Extrusiones S.A looking for this becomes a tool that gather the most relevant data generated in the plant and supports the decision making of the teams that are part of the operational department of the company.
The research will be descriptive in nature with a quantitative approach and will use different data sources generated by the company's information system that serves as input for the development of the solution proposed under an ETL methodology using the Power BI software.
It is intended to impact the development of the company's data analytics projects from the identification of the data requirements of operational teams and present a methodology that allows extracting, transforming, and loading all the data necessary for the design and creation of dashboards in Power BI that will be visual tools for quick searching to identify waste and improvements in the plant.
This research will raise awareness among the company's employees about the value of making decisions based on data and will allow to deploy work plans that improve the operational performance of the plant that will positively impact the financial result and allow identifying improvement opportunities that seek to reduce costs and improve competitiveness and innovation as a value offer to the market.
xMojica Baltodano, M. A. (2020). Tableros de impacto de los datos de Coronavirus Covid-19 en América Latina y el mundo utilizando Power BI como herramienta de visualización. REICE: Revista Electrónica de Investigación en Ciencias Económicas, 8(15), 88-103. Disponible en: https://www.lamjol.info/index. php/REICE/article/view/9946
Colciencias (2017), Política de ética, bioética e integridad científica, Disponible en: https://minciencias.gov.co/sites/default/files/upload/ noticias/politica-etica.pdf
López Benítez, Y. (2018). Business Intelligence. ADGG102PO. Antequera (Málaga), IC Editorial. Recuperado de https://elibro.net/es/ereader/ biblioibero/124393?page=10
González Farran, X. Guitart, I. & Rodríguez, J. R. (2016).
¿Cómo planificar un proyecto de inteligencia de negocio?: ( ed.). Editorial UOC.
disponible en: https://elibro.net/es/lc/biblioibero/titulos/58548
Rovira Samblancat, P. y Pascual Cid, V. (2021). Analítica Visual. Como explorar, analizar y comunicar datos. 1. Madrid, Difusora Larousse - Anaya Multimedia. Recuperado de https://elibro.net/es/ereader/ biblioibero/217097?page=15
Jaime Mesías Cajas, Doris Karina Chicaiza Angamarca, María Liseth Álvarez, Kerly Roxana Vélez, (2023). Desarrollo de un sistema BI Inteligencia de Negocios para la toma de decisiones gerenciales: Caso práctico empresa CTLSPORTS. Revista Científica y Académica VICTEC, ISSN 2737-6214, Vol. 4, Nº. 6, 2023, págs. 86-104. Disponible en: https://dialnet-unirioja-es.ibero. basesdedatosezproxy.com/servlet/articulo?codigo=9042836
Suren Machiraju, & Suraj Gaurav. (2018). Power BI Data Analysis and Visualization. De|G Press, Disponible en: https://search-ebscohost.com.ibero. basesdedatosezproxy.com/login.aspx?direct=true&db=e000xww&AN=1893725 &lang=es&site=ehost-live
Greg Deckler, (2019). Learn Power BI : A Beginner’s Guide to Developing Interactive Business Intelligence Solutions Using Microsoft Power BI. Packt Publishing. Disponible en: https://web-s-ebscohost-com.ibero. basesdedatosezproxy.com/ehost/detail/detail?vid=2&sid=8c6ebb00-dfc1-4bd0- 8d54-53ee648d260b%40redis&bdata=Jmxhbmc9ZXMmc2l0ZT1laG9zdC1saXZl #AN=2252653&db=nlebk
Brett Powell. (2018). Mastering Microsoft Power BI: Expert Techniques for Effective Data Analytics and Business Intelligence. Packt Publishing. Disponible en: https://web-s-ebscohost-com.ibero.basesdedatosezproxy.com/ ehost/detail/detail?vid=2&sid=7e5f4f71-9573-4bbe-a364-5d587188e4db%40re dis&bdata=Jmxhbmc9ZXMmc2l0ZT1laG9zdC1saXZl#db=nlebk&AN=1775076
Mojica-Avila, E. M. ., & Contreras-Cáceres, M. E. . (2022). La importancia del análisis de los estados financieros. Reflexiones Contables, 5(2), 17–26. https://doi.org/10.22463/26655543.3602
Higuera-Vargas, R. E. ., & Contreras-Cáceres , M. E. . (2021). Aspectos fundamentales de los riesgos financieros y sus incidencias en Colombia. Reflexiones Contables, 4(1), 8–20. https://doi.org/10.22463/26655543.3595
Correa-Tellez, Y. A. ., Rico-Rojas, C. F. ., & Guardiola-Plazas, L. F. . (2022). Auditoría de la cuenta por cobrar. Reflexiones Contables, 5(2), 8–16. https://doi.org/10.22463/26655543.3600