Information Technology Reference
In-Depth Information
the existing school software it was proposed to hold a BI platform with pervasive
characteristics (PBI), applied to the area of Education, more specifically, school
clusters of elementary and secondary education. The work has directly contributed to
solving the initial problem: How does the education system can benefit from the
introduction of Business Intelligence techniques? With this solution it is possible to
check the information quality, improving business processes management, as well as
improving organizations (schools) performance, more specifically, in its decision
making. Now and using the PBI, they are able to have inside information at the
decision time. With this solution the schools can take decisions and provide more
accurate indicators in real-time taking advantages of a continuous data streaming.
These information will be always updated (autonomous tasks) and will be in constant
change, depending on stakeholders needs.
This article is divided into seven chapters. In chapter two is a framework of
Education in Portugal, the BI and Data Warehouse relationship and finally the
Pervasive BI. In chapter three is presented the methodology and the tools used to
carry out the prototype. In chapter four it is presented the architecture. In chapter five
the data model is presented and chapter six presents the indicators adopted and the
results obtained. Finally the conclusions are presented, as well as future work.
2
Background
2.1
Education in Portugal
The educational in Portugal at a non-graduated level has two levels, Basic and
Secondary. Basic is to students with at least of 9 years of education and secondary
from 9 to 12 years studying. This work was carried out in a real context using data
from a leading company in educational management (they provide the systems
present in the schools clusters). With the need to optimize the process of decision and
support the existing school software provided by the company it was proposed to hold
a BI platform, applied to the Education area. For the initial goals, it was necessary
collect data related to various schools in that encompassed from the registration
process to its completion within that school year. To do this it was necessary to
survey all the requirements, as well as study all the reports and Key Performance
Indicators (KPIs) already requested by the government. From there it was prepared a
dimensional model able to support the BI platform and answer to the government
requirements.
2.2
Business Intelligence and Data Warehouse
BI can be defined as a set of mathematical models and analysis methodologies that
exploit the available data to generate useful information and knowledge for making
complex decisions [1]. The main objective of BI is to provide useful knowledge,
using tools and methodologies able to enabling them to make timely and effective
decisions.
Search WWH ::
Custom Search