Strengthening of the Ecuciencia Platform through Data Analysis and Visualization at the Technical University of Cotopaxi

Abstract

This applied research work focused on strengthening the Ecuciencia platform at the Technical University of Cotopaxi through the implementation of data analysis and visualization using Power BI and PostgreSQL. A quantitative approach with a descriptive design was employed to conduct an extraction, transformation, and loading (ETL) process that ensured data quality and consistency. The objective was to develop intuitive and meaningful key performance indicators (KPIs) to evaluate the scientific production of faculty, aiding informed decision-making. The dashboard validation indicated high satisfaction regarding its usability and interactivity, highlighting its relevance for the university community. The findings demonstrate the importance of visualization technologies in research, promoting a dynamic and collaborative environment. This model can be replicated in other institutions to foster a data-driven culture centered on innovation and scientific advancement.