Information Technology Reference
In-Depth Information
The Registration Evaluation table records the data about the student evaluations
and information about the conclusion year. In the Registration table is stored all the
information held in the beginning of the year. Teacher Fact table refers to all
information associated to teachers.
This DW has pre-defined ETL procedures for an automatic data handling and data
loading into the tables. The ETL system extracts data from the source systems,
enforcing data quality, standards consistency and combine separate data sources. If
appears new data with different patterns it will be necessary optimizing the ETL
system by adding or modifying the existing tasks.
6
Pervasive Business Intelligence Solution
6.1
Solution Features
The features of the platform took into account the whole process done and englobes a
set of pervasive features. Therefore, this platform meets some functional
characteristics:
Adaptability - The platform has the ability to automatically optimize models
with new data when necessary. This information is obtained from the results;
Real-time - by obtaining the data, this platform is able to present real-time
information (e.g. transitions, information concerning the registration, class,
household, etc).
Security - Data is stored and securely in the database, so that they can be
accessed by whomever they have access privileges.
Optimization - The models are updated over time, so that the platform is always
more precise and concise in presenting their results.
Accuracy - It is necessary to have available accurate and reliable data. For this it
is essential than the schools be able to providing such data validated.
Interoperability - The platform can integrate data from several data sources and
in different formats.
Context Awareness - The system was designed to adapt to a new environment
(i.e. new school cluster) and also has user access politics according to the context.
Autonomous ETL - All the ETL process is already defined and it is
automatically executed by the agents when a new set of data arrives.
6.2
Indicators
The KPIs are quantifiable measures used to understand whether the objectives are
being achieved or not. Consequently, these indicators determine whether to take
different attitudes to improve results. Therefore, defined a set of KPIs to make more
concise. The indicators reflect more the student's level, that is, everything that
encompasses from the stage of registration to the exit of ratings. The DW is prepared
to supply the PBI in order to create dashboards and indicators in the following
domains:
Search WWH ::




Custom Search