Open AccessImplementing data-driven decision support system based on independent educational data mart
Author(s) -
Alaa Khalaf Hamoud,
Marwah Kamil Hussein,
Zahraa Alhilfi,
Rabab Hassan Sabr
Publication year - 2021
Publication title -
international journal of power electronics and drive systems/international journal of electrical and computer engineering
Language(s) - English
Resource type - Journals
eISSN - 2722-2578
pISSN - 2722-256X
DOI - 10.11591/ijece.v11i6.pp5301-5314
Subject(s) - online analytical processing , computer science , decision support system , data warehouse , key (lock) , process (computing) , field (mathematics) , business intelligence , data science , measure (data warehouse) , database , multidimensional data , data mining , knowledge management , process management , computer security , engineering , mathematics , pure mathematics , operating system
Decision makers in the educational field always seek new technologies and tools, which provide solid, fast answers that can support decision-making process. They need a platform that utilize the students’ academic data and turn them into knowledge to make the right strategic decisions. In this paper, a roadmap for implementing a data driven decision support system (DSS) is presented based on an educational data mart. The independent data mart is implemented on the students’ degrees in 8 subjects in a private school (Al-Iskandaria Primary School in Basrah province, Iraq). The DSS implementation roadmap is started from pre-processing paper-based data source and ended with providing three categories of online analytical processing (OLAP) queries (multidimensional OLAP, desktop OLAP and web OLAP). Key performance indicator (KPI) is implemented as an essential part of educational DSS to measure school performance. The static evaluation method shows that the proposed DSS follows the privacy, security and performance aspects with no errors after inspecting the DSS knowledge base. The evaluation shows that the data driven DSS based on independent data mart with KPI, OLAP is one of the best platforms to support short-to-long term academic decisions.