Implementación de herramientas tecnológicas para la mejora de documentos de investigación

Abstract

This report presents the development of an internal internship at the Research Unit of the Faculty of Technology, aimed at improving the management, organization, analysis, and visualization of information related to research processes. The need arose because the information was primarily distributed in Excel files, hindering its updating, integration, consultation, and monitoring, as well as generating risks of inconsistencies, duplication, and wasted time in operational activities. The work was carried out in several stages, including the diagnosis and analysis of research documents, data preparation and cleaning, information integration and structuring, the analysis and implementation of indicators, and the design of interactive dashboards in Power BI. Python, primarily using the Pandas library, was used for data transformation and cleaning, while Power BI allowed for the consolidation and visualization of information through dashboards designed to monitor research indicators. During the diagnostic phase, documents related to research lines, research characterization, and the Research Model of the Faculty of Technology (MIFT-UDFJC) were analyzed, identifying inconsistencies, missing fields, duplicate information, and difficulties in linking research groups, lines of research, curricular projects, and thematic focuses. Subsequently, reports from the SICIUD platform were used to establish the necessary sources for constructing the indicators and ensuring a more consistent information structure. As a result, the information was structured and refined to facilitate its integration, analysis, and updating. Additionally, dashboards were developed in Power BI that allow for a clearer and more dynamic visualization of the research indicators. The implementation of these tools contributes to improving data accessibility, reducing operational processes, and supporting the monitoring of research processes and decision-making within the Research Unit.