Educational Data Mining and Data Warehouse Design Using Business Intelligence

Pankaj Saraswat; Swapnil Raj

doi:10.55524/ijircst.2022.10.1.17

Abstract

Business intelligence (BI) is basically a collection of programs, utilities and apps that allows you to analyze large quantities of data (Big Data). Every year, educational institutions deal with enormous amounts of Big Data. The use of business intelligence (BI) in these organizations is critical for improving processes and supporting decision-making. A Datawarehouse is the foundation of every BI project (DW). The scheme deliberations for implementing DW in any of the institutional setting are described in this article. Using educational data mining (EDM) methods, the DW shall be utilized in an information unearthing procedure to manage the statistics and facts for the study of vital accomplishment metrics. A knowledge management framework's main technical assets are a data warehouse (DW) and an enterprise architecture (EA) repository (KMF). The agenda further was created to provide order to the processes of knowledge generation, capture, transfer, and digitization. This handbook and the framework are two of the results of a private university's research effort. In addition, an illustrative example demonstrates picking of the finest technique in higher education. The stages for DW design are given in the case study. This research may help academics and practitioners who want to create a data warehouse to analyze data utilizing EDM methods.

Keywords

Business intelligence, Data Warehouse, Datawarehouse, Educational data mining, Knowledge management.

References

Business Intelligence & Knowledge Management - Technological Support for Strategic Management in the Knowledge Based Economy. Inform Econ J. 2008;
Al-Ahbabi S, Singh SK, Singh Gaur S, Balasubramanian S. A knowledge management framework for enhancing public sector performance. Int J Knowl Manag Stud. 2017;
Peña-Ayala A. Educational data mining: A survey and a data mining-based analysis of recent works. Expert Systems with Applications. 2014.
Gartner Says Worldwide Business Intelligence and Analytics Market to Reach $16.9 Billion in 2016 [Internet]. [cited 2018 Sep 10]. Available from: https://www.gartner.com/en/newsroom/press-releases/2016-02-03-gartner-says-worldwide-business-intelligence-and-analytics-market-to-reach-17-billion-in2016
Agarwal AK, Badal N. A novel approach for intelligent distribution of data warehouses. Egypt Informatics J. 2016;
Santoso LW, Yulia. Data Warehouse with Big Data Technology for Higher Education. In: Procedia Computer Science. 2017.
MaÅ›lankowski J. The Evolution of the Data Warehouse Systems in Recent Years. Finanse. 2013;
Moscoso-Zea O, Paredes-Gualtor J, Luján-Mora S. A Holistic View of Data Warehousing in Education. IEEE Access. 2018;
Kimball vs. Inmon Data Warehouse Architectures [Internet]. [cited 2018 Sep 10. Available from: https://www.zentut.com/data-warehouse/kimball-and-inmon-data-warehouse-architectures/
KumarYadav S, Pal S. Data Mining Application in Enrollment Management: A Case Study. Int J Comput Appl. 2012;

Cites this article as

P. Saraswat, S. Raj, "Educational Data Mining and Data Warehouse Design Using Business Intelligence", International Journal of Innovative Research in Engineering & Management (ijircst), Vol-10, Issue-1, Page No-97-101, 2022. Available from: https://doi.org/10.55524/ijircst.2022.10.1.17

Corresponding Author

Pankaj Saraswat

Assistant Professor, Department of Computer Science Engineering, Sanskriti University, Mathura, Uttar Pradesh

Download Full Paper

Download PDF

No. of Downloads: 41 | No. of Views: 1229

A Review of Generative AI and DevOps Pipelines: CI/CD, Agentic Automation, MLOps Integration, and LLMs

Satyadhar Joshi.

July 2025 - Vol 13, Issue 4
Cybersecurity Incident Detection (IDs) Using Machine Learning

Rehan Raja, Hiba Saleem, Shayan Ahmad, Mohd Arslaan, Nida Khan.

May 2025 - Vol 13, Issue 3
Ethical Challenges in Artificial Intelligence: A Review of Issues and Frameworks

Shivangi Srivastava.

May 2025 - Vol 13, Issue 3

Educational Data Mining and Data Warehouse Design Using Business Intelligence

Citations

Download Full Paper PDF

Total View 1229

Total Download 41