Use of Data Warehouse and Data Mining for Academic Data: A Case Study at a National University
Keywords:
Data Warehouse, Data Mining, Academic Data, Decision Support, Higher Education.Abstract
Universities must optimize their information resources to enhance organizational performance and support strategic decision-making. However, academic data stored in multiple operational systems often remains fragmented and difficult to analyze comprehensively. This study aims to develop a data warehouse and apply data mining techniques to integrate and analyze academic data at the National University (UNAS), Jakarta. The data warehouse was designed using a star schema model, integrating academic records from various operational databases into a centralized repository. Mondrian and JPivot were utilized for multidimensional data presentation, while Classification-Based Association (CBA) and Association Rule techniques were applied to uncover hidden patterns within the data. The results show that the data warehouse significantly improves reporting efficiency, reducing processing time from one month to one day. Data mining analysis further revealed characteristic patterns among students in selecting specialization programs based on academic performance. These findings demonstrate that the integration of data warehousing and data mining supports more accurate reporting, informed decision-making, and data-driven academic planning.
References
. Paulraj Ponniah. 2020. Data Warehousing Fundamentals. Wiley-Interscience Publication.
. Jeffrey A. Hoffer, Mary B. Prescott, dan Fred R. McFadden. 2021. Modern Database Management. Seventh Edition. Prentice Hall.
. Kathleen Polo, Juan Gonzales dan Edwin Rojas. 2024. Quick Tutorial about Mondrian Datamart. International Potato Center (CIP). Research Informatics Unit (RIU).
. Witten, Ian H dan Eibe Frank, 2022. Data Mining : Practical Machine Learning Tools and Technique. Second Edition. Morgan Kaufmann.
. http://www.comp.nus.edu.sg. Retrieved May 07, 2022. Data Mining II. Classification Based Association (CBA).
. Edastama, P., Dudhat, A., & Maulani, G. (2021). Use of data warehouse and data mining for academic data: A case study at a national university. International Journal of Cyber and IT Service Management, 1(2), 206-215. https://doi.org/10.34306/ijcitsm.v1i2.55
. Roelofs, E., Persoon, L., Nijsten, S., Wiessler, W., Dekker, A., & Lambin, P. (2013). Benefits of a clinical data warehouse with data mining tools to collect data for a radiotherapy trial. Radiotherapy and Oncology, 108(1), 174-179. https://doi.org/10.1016/j.radonc.2012.09.019
. Breault, J. L., Goodall, C. R., & Fos, P. J. (2002). Data mining a diabetic data warehouse. Artificial intelligence in medicine, 26(1-2), 37-54. https://doi.org/10.1016/S0933-3657(02)00051-9
. Luo, J., Xu, J., Aldosari, O., Althubiti, S. A., & Deebani, W. (2022). Design and implementation of an efficient electronic bank management information system based data warehouse and data mining processing. Information Processing & Management, 59(6), 103086. https://doi.org/10.1016/j.ipm.2022.103086
. Ren, S., Sun, Q., & Shi, Y. (2010, April). Customer segmentation of bank based on data warehouse and data mining. In 2010 2nd IEEE International Conference on Information Management and Engineering (pp. 349-353). IEEE. https://doi.org/10.1109/ICIME.2010.5477693
Moscoso-Zea, O., & Luján-Mora, S. (2016, September). Datawarehouse design for educational data mining. In 2016 15th International Conference on Information Technology Based Higher Education and Training (ITHET) (pp. 1-6). IEEE. https://doi.org/10.1109/ITHET.2016.7760754
. Ningning, G. (2010, July). Proposing data warehouse and data mining in teaching management research. In 2010 International Forum on Information Technology and Applications (Vol. 1, pp. 436-439). IEEE. https://doi.org/10.1109/IFITA.2010.286
. Jollyta, D., Ramdhan, W., & Zarlis, M. (2020). Konsep data mining dan penerapan. Deepublish.
. Tahyudin, I., Putra, I. M., & Syafa’at, A. Y. (2021). Data Mining Dan Data Warehouse Menggunakan Aplikasi KNIME (Vol. 1). Zahira Media Publisher.
. Berson, A., & Smith, S. J. (1997). Data warehousing, data mining, and OLAP. McGraw-Hill, Inc..
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Muhammad Iqbal, Muhammad Hasyim As’ary
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
