Implementación de Dashboard interactivo para la visualización de indicadores de gestión del área de distribución primaria de la empresa Cervecería Nacional, utilizando Power BI

Abstract

Abstract: The generation of visual representations has become an indispensable tool for improving decision-making processes, efficiency, and competitiveness in organizations. In this context, this thesis applies Data Science theory by using data capture through the Power Apps application, information storage in a database engine such as PostgreSQL, dashboard design in Power BI Desktop, and publication of charts on Power BI Server. The KDD Process is used as the data science methodology, with the following steps: selection, cleaning, transformation, mining, and knowledge generation. The tool integrates different data sources from various processes; subsequently, dynamic visual panels and interactive charts are generated, facilitating data interpretation through the use of performance indicators. In conclusion, the tool developed with the KDD methodology demonstrated the potential to improve the communication of results within the organization, streamline decision-making processes, and optimize productivity analysis with a high reliability rate.