Criação de um ambiente de inteligência de negócios para auxílio à tomada de decisão baseado no desempenho acadêmico dos discentes de graduação da Universidade Federal de Itajubá

Abstract

This work proposes the creation of a business intelligence pilot project that can provide information, in a friendly and intuitive way, about the academic performance of undergraduate students, to the managers of these courses, in order to assist them in their taking of decisions. Providing these managers with specific data, information and knowledge is a way to help them during their management, so that they do not need to act without the support of consistent information, which can result in unproductive actions that will not achieve the desired result. The impact of the volume, speed and variety of information to which organizations are exposed require innovative and quick responses for decision making, especially related to information retrieval and automatic knowledge extraction, which consolidate the importance of high performance management. For this, managers must have at their fingertips, tools that can provide the information they need in a friendly and intuitive way. In this environment, managers will be able to carry out analyzes on academic data collected from students, such as grades, results, academic indexes, attendance, course time, way of entering the university, and other information. Thus, they will be able to use this information to assist them in their decision-making. In the development of this work, the Soft System Methodologic methodology and the Kimball methodology were applied to the development of the Business Intelligence Data Warehouse. First, a requirements analysis was carried out through two surveys: a questionnaire for undergraduate course coordinators, and a documental survey on the service system for users of the university's information systems. A triangulation of the collected data was then carried out to find out if they are present in the academic system's database. To complete the construction of the Data Warehouse, its dimensional model was developed. This Data Warehouse will be used to feed an OLAP tool, which will provide information in a friendly and intuitive way to course managers to assist them in their decision making. The cycle ends with the evaluation of this tool by the managers and, if there are new suggestions to improve it, the cycle will start again. With this work, initially, a pilot project will be created to meet an old need within the university, which is to provide undergraduate course managers with information in a friendly, easy-to-read, graphic format, about the academic performance of undergraduate course students, to assist them in their decision-making.