Information Technology Reference
In-Depth Information
database (SQL). The ETL process is performed in the data processing subsystem. The
tasks associated to data validation and creation of new variables are executed in this
subsystem. The Business Intelligence subsystem is responsible to the development of
the Data Warehouse and induce data mining models always some new future
predictions is requested. This subsystem interacts with the Inference subsystems,
where it is all the data mining scenarios and business indicators. Finally it is Interface,
which is responsible for the system interaction with the user. This architecture is
composed by several intelligent agents which are responsible to automatize the tasks
of each subsystem [14]. These agents are responsible for: Automate data collection;
Data processing; Data Mining models Inductions; Information retrieval; Ensure the
data quality of the PBI system; Present the results in real time.
5
Data Warehouse
It was developed a data model (Fig. 3) allowing the organization to run the entire
business process dynamically. The data model consists in a set of tables which
support all the school management process. In this model is stored all the information
about the students enrolment, as well as their notes. It is also stored all the
information on the school management, from the disciplines, courses, student,
parents, professors, human resources and others.
This model comprised three facts tables. These tables contains all the KPIs
requested by the government that has available information to be produced. In this
model is kept all the relevant data for future analysis. There is a need to have three
fact tables due the fact of some dimensions are not interchangeable. This happens
because there are different records with different information and there are a certain
number of records that change throughout the year.
Fig. 3. Dimensional Model
Search WWH ::




Custom Search