Diseño de cuadro de mando integral con Power Bi para empresa distribuidora de bebidas
Keywords:
cuadro de mando integral, distribución de bebidas, inteligencia de negocios, Power BiAbstract
Supply chain management must integrate all activities to achieve a competitive advantage and increase the effectiveness of the organizations that comprise it. For this, it is essential to be able to measure performance through indicators that facilitate transparent and open communication, promoting cooperative work. The Balanced Scorecard (BSC) is a management tool used to implement the business strategy based on a series of indicators, allowing permanent control that relates the organization's strategic objectives with specific action plans. The CMSA company is a beverage distributor. You currently analyze your operational processes with dashboards that are visually unappealing and with many indicators at the same level. In this work, two objectives were set: to design a CMI to measure its critical processes and to use Power BI, a business intelligence tool, to improve the visual communication of said dashboard. Based on the survey of the processes and interviews with the different actors, a set of indicators was selected that guarantee compliance with the organization's strategy and their real-time calculation generated by Power Bi allowed for more focused decision making.
Downloads
References
Ballou, R. H. (2004). Business Logistics Management. The United States: Prentice Hall
Bhagwat, R., y Sharma, M. K. (2007). Performance measurement of supply chain management: A balanced scorecard approach. Computers and Industrial Engineering, 53(1), 43-62. https://doi.org/10.1016/j.cie.2007.04.001
Chang, H. H. (2009). An empirical study of evaluating supply chain management integration using the balanced scorecard in Taiwan. Service Industries Journal, 29(2), 185-202. https://doi.org/10.1080/02642060802294961
Cordero Guzmán, D., y Rodríguez López, G. (2017). La inteligencia de negocios: una estrategia para la gestión de las empresas productivas. Revista Ciencia UNEMI, 10(23), 40-48. https://doi.org/10.29076/issn.2528-7737vol10iss23.2017pp40-48p
Deloitte. (2021, 11 De octubre) ¿Qué es Power BI? https://www2.deloitte.com/es/es/pages/technology/articles/que-es-power-bi.html
Elbashir, M. Z., Collier, P. A., y Davern, M. J. (2008). Measuring the effects of business intelligence systems: The relationship between business process and organizational performance. International Journal of Accounting Information Systems, 9(3), 135-153. https://doi.org /10.1016/j.accinf.2008.03.001
García, L. A. M. (2008). Indicadores de la gestión logística. Ecoe Ediciones.
Guerra, L. M., y Vanegas, E. (2013). Sistema de inteligencia de negocios para el apoyo al proceso de toma de decisiones. Revista INGENIERÍA UC, 20(3), 25-34.
Gunasekaran, A., Patel, C., y Tirtiroglu, E. (2001). Performance measures and metrics in a supply chain environment. International Journal of Operations and Production Management. Vol. 21, Issue 1/2, 71-87. https://doi.org/10.1108/01443570110358468
Gunasekaran, A., y Kobu, B. (2007). Performance measures and metrics in logistics and supply chain management: A review of recent literature (1995-2004) for research and applications. International Journal of Production Research, 45(12), 2819-2840. https://doi.org/10.1080/00207540600806513
ISOTools. (2021). El Cuadro de Mando Integral “Balanced Scorecard. https://elibro.net/es/lc/ucnbiblioteca/titulos/119597
Jothimani, D., y Sarmah, S. P. (2014). Supply chain performance measurement for third party logistics. Benchmarking, 21(6), 944-963. https://doi.org/10.1108/BIJ-09-2012-0064
Kaits Consulting. (2022, 2 de febrero). Webinar Power Query with Power BI. https://www.kaitsconsulting.com/power-power
Kaplan, R.S. Y Norton, D.P. (1996). The Balanced Scorecard: Translating Strategy into Action, Harvard Business School Press, Boston, MA.
Kubina, M., Koman, G., y Kubinova, I. (2015). Possibility of Improving Efficiency within Business Intelligence Systems in Companies. Procedia Economics and Finance, 26(15), 300-305. https://doi.org/10.1016/S2212-5671(15)00856-4
Lakri, S., y Jemai, Z. (2016). Performance measurement and management systems of supply chains: A review of the challenges they raise. Proceedings of 2015 International Conference on Industrial Engineering and Systems Management, IEEE IESM, 920-929.
Machinandierena, V. (2022). Propuesta de indicadores de desempeño logísticos y tablero de control para el almacén de una empresa distribuidora. Tesis de grado. Facultad de Ingeniería - Universidad Nacional del Mar del Plata, Argentina.
Oracle. (2022, 22 de marzo). ¿Qué es la ERP?. https://www.oracle.com/ar/erp/what-is-erp/.
Piela, J. (2017). Key performance indicator analysis and dashboard visualization in a logistics company. Lappeenranta University of Technology, Helsinski.
Saleheen, F., Habib, M. M., y Hanafi, Z. (2018). Supply chain performance measurement: a systematic literature review. International Journal of Logistics Systems and Management, 7(3), 70-78.
Singh, R. K., y Acharya, P. (2014). Performance evaluation of supply chain management systems: A critical review of literature. International Journal of Procurement Management, 7(2), 201-218.
Zuluaga, M. A., Gómez, M. R., y Fernández, H. S. (2014). Indicadores logísticos en la cadena de suministro como apoyo al modelo SCOR. Clío América, 8 (15), 90- 110.
Downloads
Published
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Atribución — Usted debe dar crédito de manera adecuada, brindar un enlace a la licencia, e indicar si se han realizado cambios. Puede hacerlo en cualquier forma razonable, pero no de forma tal que sugiera que usted o su uso tienen el apoyo de la licenciante.
NoComercial — Usted no puede hacer uso del material con propósitos comerciales.
CompartirIgual — Si remezcla, transforma o crea a partir del material, debe distribuir su contribución bajo la misma licencia del original.
