Sistema de visualización científica de datos para el monitoreo de resultados de aprendizaje de los proyectos curriculares Tecnología en Sistematización de Datos e Ingeniería Telemática

Abstract

The Universidad Distrital Francisco José de Caldas, through its Data Systematization Technology and Telematics Engineering programs, currently lacks a visualization system that allows users to easily consult and understand the learning outcomes for each semester and course. Instead, it relies on an Excel file that stores all the information about the learning outcomes in a large matrix, which is difficult to query and interpret due to its extensive and complex format. This document presents the development of a more convenient and secure way to visualize learning outcomes through the implementation of a TypeScript-based solution aimed at improving the data structure within the matrix. The information is reorganized into a tabular format, making it suitable for use as a data source in Power BI, where exploratory analysis can be performed using Power Query and its features, and descriptive analysis can be conducted with Power BI, revealing data patterns and graphically representing the information to facilitate interpretation. Beyond the technical component, this project also seeks to promote the effective use of the university’s cloud tools by proposing solution architectures that generate a tangible organizational impact: improving the traceability of learning outcomes, reducing errors in data consolidation, and strengthening evidence-based decision-making.