Integrasi Data Warehouse dan Sistem Informasi Geografis untuk Analisis Spasial Persebaran Mahasiswa Baru
DOI:
https://doi.org/10.55606/jupsim.v4i3.5460Keywords:
Data Warehouse, Decision Support System, GIS, New Student Distribution, Spatial AnalysisAbstract
Higher education institutions face challenges in managing large volumes of new student data, hindering strategic geographical distribution analysis. This research focuses on designing and building an integrated system utilizing a Data Warehouse and Geographic Information System (GIS) to analyze the distribution patterns of new students at UIN Alauddin Makassar. The system development uses the Waterfall model(I Putu Agus Eka Pratama, 2021), which includes structured stages from secondary data collection from the Academic Information System (SIAKAD), an ETL (Extract, Transform, Load) process into a Data Warehouse with a star schema architecture (Coronel & Morris, 2022), to spatial data visualization using GIS (Botha et al., 2023). The analysis of 15,826 student records from 2022-2024 reveals a high geographic concentration, with the top five regencies contributing 53.2% of all new students. The resulting web-based system provides an interactive thematic map that identifies regions with high applicant concentrations, offering strategic insights to support data-driven decision- making for university leadership (Corrin et al., 2023). This research demonstrates how the integration of Data Warehouse and GIS technology can optimize educational data governance and provide a solid foundation for strategic new student admission planning.
References
Adi Budi Santoso, & Wibawa, I. K. (2023). Perancangan dashboard eksekutif untuk pemantauan data penerimaan mahasiswa baru pada Institut Teknologi Telkom Purwokerto. JATI (Jurnal Mahasiswa Teknik Informatika).
Bhatia, P. (2020). Data mining and data warehousing: Principles and practical techniques. Cambridge University Press. https://doi.org/10.1017/9781108635592
Botha, Y., Yoseph, P. K., Kelen, & Risald. (2023). Sistem informasi geografis pemetaan sekolah dasar di Kabupaten Timor Tengah Utara berbasis web. Jurnal ..., 1, 1–8.
Coronel, C., & Morris, S. (2022). Database systems: Design, implementation, and management (14th ed.). Cengage.
Corrin, L., Henderson, M., & Kennedy, G. (2023). Learning analytics in higher education: A practical guide. Routledge.
Duckett, J. (2021). PHP & MySQL: Server-side web development. John Wiley & Sons.
I Putu Agus Eka Pratama. (2021). Metode waterfall dalam system development life cycle (SDLC). Jurnal Sains Komputer dan Informatika, 5, 791–801.
Lusianti, S. D., & Nugraha, I. H. (2025). Implementasi sistem informasi geografis dalam pemetaan data penduduk pada Kecamatan Kawalu. Jurnal Informatika dan Komputer, 9, 112–122. https://doi.org/10.26798/jiko.v9i1.1449
Mahfuz, A. (2020). Software testing: Theory and implementation. Independently published.
Ponniah, P. (2021). Data warehousing fundamentals for IT professionals. Wiley.
Ramadhan, J. A., Haniva, D. T., & Suharso, A. (2023). Systematic literature review penggunaan metodologi pengembangan sistem informasi waterfall, agile, dan hybrid. Journal Information Engineering and Educational Technology, 7.
Saily, S., Maizir, H., & Yasri, D. (2021). Pembuatan peta tematik menggunakan sistem informasi geografis (SIG) pada Desa Teluk Latak. CESD, 4(2). https://doi.org/10.25105/cesd.v4i2.12497
Suhirman. (2022). Data warehouse dan mining. In Dinamika Sistem Informasi.
Sulis, L. P. (2023). Perancangan data warehouse pada software laboratorium PT. Sainfest. Jurnal Ilmiah Sistem Informasi, 2(2), 30–38. https://doi.org/10.51903/juisi.v2i2.685
Yuningsi, P. D., & Utami, L. A. (2024). Sistem informasi online booking berbasis web pada Pheo Studi Salon. Jurnal Teknoinfo, 18, 193–200.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Jurnal Publikasi Sistem Informasi dan Manajemen Bisnis
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
