Informe final de prácticas laborales

Abstract

This report presents the final outcomes of the professional internship carried out at Colsubsidio, focusing on the enhancement of internal processes through the implementation of Business Intelligence tools such as Power BI, Excel, and Python. The internship enabled the identification and resolution of a significant inconsistency in the measurement of an institutional indicator related to the incorporation of interns, which initially produced inaccurate results in the dashboard. A technical revision of the script and methodological redesign of the data visualization system improved the accuracy of reported metrics and mitigated operational risks. The experience incorporated ETL processes, KPI tracking, and data governance practices, supported by national data protection laws and institutional policies. Throughout the internship, the application of conceptual frameworks to real-world challenges fostered collaborative problem-solving and strategic decision-making. The results demonstrated not only a meaningful contribution to the organization’s operational efficiency but also the development of analytical, technical, and communication skills in the intern. This practice proved to be a transformative educational modality, bridging academic knowledge and professional requirements, and generating tangible value in both domains.