Análisis de datos e implementación de dashboards mediante una plataforma de Business Intelligence, sobre la plataforma de educación online "MOODLE" de la Universidad Católica de Santiago de Guayaquil.

Abstract

The present degree work shows the implementation of a business intelligence (BI) application for the teacher, over the Moodle platform from “Universidad Catolica de Santiago de Guayaquil”. The exposed topic has been proposed in the context of a world health crisis due to COVID-19, which has forced to change from face-to-face education to online learning. Mixed research methodology was applied since it was necessary to determine the activities and resources most used on Moodle through surveys, and the teacher experience on the platform handling through interviews. The development of the Business Intelligence solution was based on prototype methodology, to periodically show the diverse functional screens according to the requirements from UCSG Information Technology department; the screens that were integrated to the solution are about: Fulfillment, grades, forums and connections. It was investigated about the development of similar solutions in the market and in other universities; in the same way, a comparison between the top 3 business solution applications was done. The chosen BI tool for the project was Microsoft Power BI, in which 6 fact tables and 10 dimensional tables were created based on the fields and tables from Moodle, this allows the teacher to see the various graphics reports from different perspectives according to their needs. All these reports were uploaded to Power BI service on the cloud, for the access of the teachers without the necessity of installing a program. Finally, the implementation of a student follow-up application over Moodle was achieved, which allows the teacher, in their various subjects on the virtual platform, to obtain various graphics reports with indicators showing the status of their students.