Mapping Student Data for New Student Admissions Using a Data Warehouse at BPK PENABUR Jakarta
DOI:
https://doi.org/10.59261/jequi.v8i4.406Keywords:
Data warehouse, New Student Admissions, Dashboard, Data Integration, BPK PENABUR JakartaAbstract
Background: BPK PENABUR Jakarta, as an educational institution with a wide network, faces challenges in managing new student admissions (Penerimaan Siswa Baru, PSB) data spread across various platforms, such as PSB applications, Google Forms, and PDF documents. The manual process currently in use leads to inefficiency, data inaccuracies, and difficulties in data analysis.
Objective: This study aims to design a data warehouse-based solution to centrally integrate, store, and manage PSB data and develop a visual dashboard to support decision-making.
Methods: The research method employs Kimball’s Nine-Step Design Method, including business process identification, dimension and fact modeling, and the implementation of Extract, Transform, Load (ETL) processes using Pentaho Data Integration.
Results: The result is a data warehouse with a star schema that combines data from various sources and is equipped with an interactive dashboard to visualize information such as the number of students accepted, religious distribution, geographic distribution, and parental income. This implementation improves the efficiency of PSB data management, reduces dependence on manual processes, and enables faster and more accurate data analysis. Key success factors include management commitment, resource availability, and supporting infrastructure.
Conclusion: This research offers academic contributions to the development of educational information systems as well as practical benefits for BPK PENABUR Jakarta in optimizing the PSB process. Suggestions for further development include expanding data coverage, providing user training, and integrating the data warehouse with other Business Intelligence tools.
Downloads
References
Akter, M., & Kudapa, S. P. (2024). A Comparative Analysis Of Artificial Intelligence-Integrated BI Dashboards For Real-Time Decision Support In Operations. International Journal Of Scientific Interdisciplinary Research, 5(2), 158–191. Https://Doi.Org/10.63125/47jjv310
Anshari, S. F., & Retno, S. (2023). Penerapan Metode Nine-Step Kimball Dalam Pengolahan Data History Menggunakan Data Warehouse Dan Business Intelligence. Jurnal Ilmu Komputer, 16(1), 69–79. Https://Doi.Org/10.24843/JIK.2023.V16.I01.P07
Darmayanti, R. (2024). Research Design: Rnd Research Method. SSRN. Https://Ssrn.Com/Abstract=5012967
Gobel, C. D., Rahmisyari, R., & Arifin, T. (2026). Strengthening Managerial Capacity In The Management Of BOS Funds: Case Study From Educational Units In South Bolaang Mongondow Regency, Indonesia. Golden Ratio Of Data In Summary, 6(1), 1–18. Https://Doi.Org/10.52970/Grdis.V6i1.1813
Hariyawan, A. C., Purnomo, W., & Rahayudi, B. (2026). Pembangunan Dashboard Business Intelligence Untuk Monitoring Penjualan Menggunakan Metode Kimball (Studi Kasus: PT. Radnet Digital Indonesia). Jurnal Pengembangan Teknologi Dan Ilmu Komputer, 10(5).
Hutabarat, F. J. S. (2026). Implementasi Data Warehouse Dengan Pendekatan Nine-Step Kimball Dan Star Schema Untuk Analisis Data Karyawan (Studi Kasus: SMA Cendana Pekanbaru). Politeknik Caltex Riau.
Khan, B., Jan, S., Khan, W., & Chughtai, M. I. (2024). An Overview Of ETL Techniques, Tools, Processes And Evaluations In Data Warehousing. Journal On Big Data, 6(1), 1–20. Https://Doi.Org/10.32604/Jbd.2023.046223
Machireddy, J. R. (2023). Data Quality Management And Performance Optimization For Enterprise-Scale ETL Pipelines In Modern Analytical Ecosystems. Journal Of Data Science, Predictive Analytics, And Big Data Applications, 8(7), 1–26. Https://Helexscience.Com/Index.Php/JDSPABDA/Article/Download/2023-07-04/13
Matla, R. K. (2026). AI Agent–Enabled Predictive Analytics And Intelligent Dashboard Automation For Real-Time Decision Intelligence In Large Enterprises. 2026 5th International Conference On Sentiment Analysis And Deep Learning (ICSADL), 812–818.
Nurcahyo, K. E., & Nugroho, A. (2020). Pemetaan Data Siswa Menggunakan Data Warehouse Untuk Promosi Di SMK Z Mapping Student Data Using Data Warehouse For Promotion At Vocational High. Vol, 3, 55–66.
Pohan, I. A., Diana, N., Ibnusaputra, M., & Satria, F. (2026). Research Methodology. Mind Power Publishing.
Qibtiyah, S. M., Nugroho, A., & Firliana, R. (2022). Sistem Informasi Pengolahan Data Peminjaman Buku Di Taman Baca Dengan Menggunakan Data Warehouse. Jurnal Ilmu Komputer Dan Sistem Informasi (JIKOMSI), 5(2), 68–75.
Ramadhani, P. P., Hadi, S., & Rosadi, R. (2021). Implementation Of Data Warehouse In Making Business Intelligence Dashboard Development Using Postgresql Database And Kimball Lifecycle Method. 2021 International Conference On Artificial Intelligence And Big Data Analytics (ICAIBDA), 88–92. Https://Doi.Org/10.1109/ICAIBDA53487.2021.9689697
Reddy, S. (2026). Business Analytics: Theory To Practice. Educohack Press.
Savitri, N. K. W., Sandhiyasa, I. M. S., Fittryani, Y. P., Sudipa, I. G. I., & Putra, D. M. D. U. (2025). Design Of Real-Time Project Monitoring Dashboard Using Kimball’s Data Warehouse Approach And Google Data Studio. Sinkron: Jurnal Dan Penelitian Teknik Informatika, 9(3), 1050–1061. Https://Doi.Org/10.33395/Sinkron.V9i3.14801
Taqiyah, B. T. B. (2026). Penerapan Business Intelligence Dan Analisis Data Mining Untuk Prediksi Tren Penjualan Produk. Karapan Network Journal: Journal Computer Technology And Mobile Ad Hoc Network, 2(02).
Thenata, A. P., Agus, A., & Sinata, F. (2025). Perancangan Dan Analisis Data Warehouse Menggunakan Nine Step Design Pada Perusahaan SKY. Jurnal Algoritma, Logika Dan Komputasi, 8(1).
Tretko, V., Vasiutina, T., Kolomiiets, I., Iievliev, O., & Kramar, V. (2023). Functions And Principles Of Creating Quality Information Support For The Educational Space Of Higher Education Institution. Amazonia Investiga, 12(69), 51–60. Https://Doi.Org/10.34069/AI/2023.69.09.4
Wahid, A. M., Afuan, L., & Utomo, F. S. (2024). Enhancing Collaboration Data Management Through Data Warehouse Design: Meeting BAN-PT Accreditation And Kerma Reporting Requirements In Higher Education. Jurnal Teknik Informatika (JUTIF), 5(6), 1517–1527. Https://Doi.Org/10.52436/1.Jutif.2024.5.6.1747
Walha, A., Ghozzi, F., & Gargouri, F. (2024). Data Integration From Traditional To Big Data: Main Features And Comparisons Of ETL Approaches. The Journal Of Supercomputing, 80(19), 26687–26725. Https://Doi.Org/10.1007/S11227-024-06413-1
Yunandar, R. T., & Amir, A. (2020). Perancangan Data Warehouse Untuk Informasi Strategi Studi Kasus Penerimaan Siswa Baru STIE Binaniaga Bogor. Jurnal Khatulistiwa Informatika, 6(1), 111–120.
Zhang, Y. (2022). Challenges And Strategies Of Student Management In Universities In The Context Of Big Data. Mobile Information Systems, 2022(1), 3537468. Https://Doi.Org/10.1155/2022/3537468
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Eka Muliawan, Sani Muhamad Isa
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike 4.0 International (CC-BY-SA). that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
