Uso de business intelligence para visualização de indicadores de evasão escolar no ensino superior

Abstract

School dropout is a phenomenon that affects various educational levels and modalities, characterized by the student’s abandonment or withdrawal from a particular institution or type of education. In this context, this study aimed to develop a Business Intelligence solution to analyze dropout data in higher education at the State University of Piauí (UESPI). To this end, an applied and descriptive methodology with a qualitative and quantitative approach was adopted. The method involved an ETL process and the modeling of a star schema. The resulting data were visualized through interactive dashboards, integrated into a web system developed using Looker Studio, a free and user-friendly tool. The results revealed significant dropout numbers, with a general rate of 43,08% across all UESPI campuses, peaking in the 2023.1 academic term. It was also observed that most dropout students are male and between 25 and 29 years old. It is concluded that it is necessary to implement public policies aimed at university retention, as well as adopt measures to understand the subjective causes of dropout in order to mitigate them.