Propuesta de visualización de datos empresariales mediante dashboards en Power BI: aplicación en las Direcciones Comercial, Producción, Talento Humano Y Finanzas en Fibroacero S.A.

Abstract

This degree project proposes a data visualization solution through dashboards developed in Microsoft Power BI, applied to the Commercial, Production, Human Talent, and Finance departments of Fibroacero S.A. The initiative arises from the need to have tools that improve access to key information for strategic decision-making. The Information needs of each department were identified through semi-structured interviews, allowing the definition of key performance indicators (KPIs) for each area. Data was extracted from the company's database and spreadsheet files, then transformed and loaded through an ETL process, followed by modeling and visualization in Power BI. The project methodology combined a quantitative approach, focused on data processing and analysis, with a qualitative approach based on the interpretation of user input during development. The CRISP-DM and Design Thinking methodologies were applied, oriented both toward technical logic and user experience. During the project, challenges such as non-standardized data and limited access to information were addressed by using structured templates stored in the cloud. The dashboards developed were evaluated and validated with department directors, who highlighted their usefulness in centralizing information, identifying trends, and improving decision-making. In this way, the project fulfilled its objectives and added value to the company's internal management and the use of decision-support tools.