Informe opción de grado práctica profesional

Abstract

This report documents the professional internship carried out at Regional Business Colombia S.A.S., under the Intcomex brand, focused on data analysis for human talent management and KPI compliance monitoring, along with data cleaning, transformation, and modeling for the evaluation of certain payroll procedures. The internship arose from the need for a data analyst with an emphasis on data storytelling and Business Intelligence (BI) knowledge within the human resources area, due to an increase in employee turnover, requiring the ability to assess regional performance and manage strategic analytical projects. The main objective was to analyze the relationship between KPI compliance and variable payroll payments across the company’s subsidiaries in different countries, as well as to automate procedures for measuring business performance data through key indicators and variable payroll payments. To achieve this, ETL processes were applied to clean and unify databases, followed by the modeling of complex data structures for final visualization through BI tools. The results included the creation of automated dashboards that identified the level of compliance across departments, optimizing visualization and process improvement with a significant impact on decision-making within the human capital area, demonstrating that quantitative performance analysis is crucial for assessing employee profitability and efficiency, facilitating the extraction of insights for stakeholders and supporting strategic decision-making in talent management.