Implementing data-driven decision support system based on independent educational data mart

• Published in: International journal of electrical and computer engineering (Malacca, Malacca) Vol. 11; no. 6; p. 5301
• Main Authors: Hamoud, Alaa Khalaf, Hussein, Marwah Kamil, Alhilfi, Zahraa, Sabr, Rabab Hassan
• Format: Journal Article
• Language: English
• Published: Yogyakarta IAES Institute of Advanced Engineering and Science 01.12.2021
• Subjects: Data marts; Decision making; Decision support systems; Education; Knowledge bases (artificial intelligence); New technology; Online analytical processing; Performance evaluation; Privacy; Query processing; Students
• ISSN: 2088-8708; 2722-2578; 2088-8708
• DOI: 10.11591/ijece.v11i6.pp5301-5314

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.