Resumo:
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.
