Pervasive Business Intelligence Platform to Improve the Quality of Decision Process in Primary and Secondary Education – A Portuguese Case Study - New Contributions in Information Systems and Technologies - page 159

technical feasibility. Regarding the former, if the company's decisions are taken based
on the instinct of decision-makers and not on the facts that there is, must be pointed
out that a DW will not bring them significant benefits. Otherwise, if these decisions
are based on facts presented on the company's activity, then a DW will have a
significant weight in the decision-makers choices [11].

3.2 Tools Selection

The tools used to implement the PBI were: SQL Server and QlikView. SQL Server
was used to make the whole process of extraction, transformation and loading data
(ETL) [12]. QlikView [13] was the tool chosen to make the whole BI process. Despite
being a tool with particular characteristics, capable of supporting invasive solutions,
performs well in terms of real-time dashboards, a high level of security and have a
high degree of data security. As a first step it was made the ETL. Then the data was
prepared in order to corresponding to indicators made. Finally it was developed the
dashboards.

4 Platform Architecture

The main objective of this prototype is to help schools in their decision process,
making them easier and containing information in real-time. The architecture (Fig. 2)
is divided in five subsystems [14]. Data Acquisition refers to the collection of data by
the entities (data source). These data can be in two formats universal (XML) or

Fig. 2. Architecture retrieved from [14]