Data Warehouse for Study Program Accreditation Data Management at Private University X
Abstract
Technological advancements in the Fourth Industrial Revolution have transformed higher education, yet accreditation processes often suffer from inefficient data management, causing delays, inconsistencies, and limited monitoring of performance indicators. This study designs a data warehouse integrated with a dashboard and Early Warning System (EWS) to improve accreditation data management at University X, West Jakarta. Using Kimball’s Dimensional Model, data were structured into fact and dimension tables, with collection methods including interviews with the Head of the IT Department and document analysis of accreditation processes. Descriptive statistics were applied to identify trends and patterns. The dashboard enables real-time visualisation of key metrics, while the EWS issues alerts on missing or outdated data. Results show that the snowflake schema enhances data organisation and clarity, reducing manual processing and facilitating proactive monitoring. The system supports more efficient accreditation management and strengthens institutional readiness for assessment.
Keywords
References
T. R. Lam, D. Trisnawarman, and Hugeng, “Rice planting decision support system using the fuzzy simple additive weighting (SAW) method,” International Journal of Applied Science, Technology, and Engineering (IJASTE), vol. 1, no. 2, pp. 440–445, May 2023.
F. Yang and S. Gu, “Industry 4.0, a revolution that requires technology and national strategies,” Complex & Intelligent Systems, vol. 7, no. 3, pp. 1311–1325, Jun. 2021.
J. T. Beng, S. Tiatri, F. Lusiana, and V. H. Wangi, Intensity of gadgets usage for achieving prime social and cognitive health of adolescents during the COVID-19 pandemic, 2020.
A. Acevedo-De-los-Ríos and D. R. Rondinel-Oviedo, “Impact, added value and relevance of an accreditation process on quality assurance in architectural higher education,” Quality in Higher Education, vol. 28, no. 2, pp. 186–204, 2022.
J. O. Fernandes and B. Singh, “Accreditation and ranking of higher education institutions (HEIs): Review, observations and recommendations for the Indian higher education system,” The TQM Journal, vol. 34, no. 5, pp. 1013–1038, Nov. 2022.
S. M. Naidas, “Tracer study of AB English graduates of Adventist University of the Philippines from 2016 to 2022,” Adventist University of the Philippines Research Journal, vol. 26, pp. 1–12, Jul. 2023.
S. Tiatri and T. Jap, “Preliminary investigation on the effectiveness of a thinking skill training in Indonesia: ‘Thinking skills training with digital technology,’” [Online]. Available: https://www.researchgate.net/publication/285813877
J. S. Jwo, C. S. Lin, and C. H. Lee, “An interactive dashboard using a virtual assistant for visualizing smart manufacturing,” Mobile Information Systems, vol. 2021, Art. no. 5592764, pp. 1–12, 2021.
R. Meckawy, D. Stuckler, A. Mehta, T. Al-Ahdal, and B. N. Doebbeling, “Effectiveness of early warning systems in the detection of infectious diseases outbreaks: A systematic review,” BMC Public Health, vol. 22, no. 1, Dec. 2022.
BAN-PT, Kriteria dan Prosedur IAPT 3.0. [Online]. Available: https://www.banpt.or.id/wp-content/uploads/2019/09/Lampiran-02-PerBAN-PT-3-2019-Kriteria-dan-Prosedur-IAPT-3_0.pdf. [Accessed: Aug. 16, 2025].
BAN-PT, Akreditasi Program Studi: Kriteria dan Prosedur. [Online]. Available: https://www.banpt.or.id/wp-content/uploads/2019/10/Lampiran-2-PerBAN-PT-5-2019-tentang-IAPS-Kriteria-dan-Prosedur.pdf. [Accessed: Aug. 16, 2025].
H. Gaussdb, Official Textbooks for Huawei ICT Academy: Database Principles and Technologies-Based On.
A. Satheesh and A. Kumar, “An object-oriented database design for effective classification,” International Journal of Intelligent Systems and Applications in Engineering (IJISAE), vol. 10, no. 1, pp. 45–52, 2022. [Online]. Available: www.ijisae.org
R. Kimball, The Data Warehouse Toolkit. 3rd ed. Hoboken, NJ, USA: Wiley, 2013.
A. Philipps and R. Mrowczynski, “Getting more out of interviews: Understanding interviewees’ accounts in relation to their frames of orientation,” Qualitative Research, vol. 21, no. 1, pp. 59–75, Feb. 2021.
I. Gusti, A. Agung, O. Dewi, and G. A. Agung, “Understanding data collection methods in qualitative research: The perspective of interpretive accounting research,” Journal of Tourism Economics and Policy, vol. 1, no. 1, pp. 1–9, 2021, doi: 10.38142/jtep.v1i1.102.
ن. ع. عداس عنع, “تحديات في تطبيق الاعتماد الأكاديمي بالتعليم العالي في المملكة العربية السعودية,” Journal of King Abdulaziz University: Environmental Design Sciences, vol. 12, no. 1, pp. 101–116, Jan. 2019.
M. Breslin, “Data warehousing battle of the giants: Comparing the basics of the Kimball and Inmon models—Introduction and context,” Business Intelligence Journal, Winter 2004, pp. 47–53.
How To Cite This :
Refbacks
- There are currently no refbacks.
