Integrasi Data Penelitian dan Pengabdian Dosen untuk Monitoring Berbasis Data Warehouse
Keywords:
Data Warehouse, Monitoring, Lecturer Research, Community Service, DashboardAbstract
The management of research and community service data of lecturers in higher education institutions requires an integrated system to support effective monitoring and reporting processes. At UIN Alauddin Makassar, research and community service data had previously been stored separately in Microsoft Excel files managed by different staff members, which made data processing, retrieval, and comprehensive analysis difficult. This study employed a quantitative approach with stages consisting of requirements analysis, system design, data warehouse implementation, and system testing. Data integration was carried out through the Extract, Transform, and Load process into a structured centralized data storage. System testing was conducted using the Black Box Testing method to ensure that all system functions operated according to user requirements. The results showed that the implementation of the data warehouse successfully integrated research and community service data in a structured manner, reduced data duplication, and improved efficiency in data retrieval and report generation. The developed system also provided monitoring reports in the form of a web-based dashboard that was informative and easy to understand. Therefore, the implementation of this data warehouse was able to assist the Institute for Research and Community Service (LP2M) in managing and monitoring lecturers’ research and community service activities more effectively and optimally.
Downloads
References
[1] Jamaluddin, J., Dwi Arianti, B. D., Novianti, B. A., & Asrobi, M. (2022). Desain Sistem Informasi Tri Dharma Perguruan Tinggi Univesitas Hamzanwadi. Infotek : Jurnal Informatika Dan Teknologi, 5(2), 392–401.
[2] Aqilah, A. S., Febrian, R., Kurniawan, I., Hakim, L., Winda, N., & Kholik, A. (2023). Analisis Pengelolaan Tri Dharma Perguruan Tinggi Dalam Bidang Penelitian Analysis Of The Management Of The Tri Dharma Of Higher Education In The Field Of Research. In Jurnal Sosial Humaniora (Vol. 1, Issue 3).
[3] Insani, R., Asfari, U., Armando, R., & Melyantara, I. A. K. A. (2022). Perancangan Data Warehouse Untuk Menunjang Akreditasi Program Studi. Jurnal Teknologi Informasi dan Ilmu Komputer (JTIIK), 9(4).
[4] Hendrawaty, M. (2024). Analisis dan Perancangan Data Warehouse pada PT. Polaris Sapta Manggala. Jurnal Ilmiah Binary STMIK Bina Nusantara Jaya Lubuklinggau, 6(1), 8–16.
[5] Nisa, K., Sugiarto, D., & Siswanto, T. (2021). Perancangan Data Warehouse Harga Pangan Di Wilayah Perumda Pasar Jaya. Explore: Jurnal Sistem Informasi Dan Telematika, 12(1), 47–55.
[6] Satrio, Y. D. (2021). A: Penerapan ETL (Extract Transform Load) untuk Integrasi Data SIMLITABMAS pada Aplikasi Pengelolaan Penelitian dan Pengabdian Masyarakat Universitas Dinamika (Doctoral dissertation, Universitas Dinamika). In (Doctoral dissertation, Universitas Dinamika).
[7] Azzahra, A., Aditya, P., & Wijaya, A. (2023). Literatur Review: Evaluasi Pemanfaatan Data Warehouse Dalam Transformasi Waktu. Jurnal Simasi : Jurnal Ilmiah Sistem Informasi, 3(2), 276–282.
[8] Santika, Y. K. (2021). Pembangunan Data Mart Pada Unit Klinik & Imunisasi Di Pt Biofarma (Doctoral dissertation, Universitas Komputer Indonesia).
[9] Selvianto, S. C., & Wijaya, A. (2025). Implementasi Data Warehouse Industri Film Menggunakan PostgreSQL. Jurnal Sistem Informasi dan Teknologi Peradaban, 6(2), 6-12.
[10] Febrian, G., & Tiur Gantini, S. T. (2022). Rancang Bangun Data Warehouse untuk Status Mahasiswa Menggunakan Snowflake Schema. Jurnal STRATEGI-Jurnal Maranatha, 4(1), 22-31.
[11] Hendra, H., Wahyuningsih, Y., & Mahendrasusila, F. (2024). Rancang bangun sistem proses transaksi perusahaan berbasis website dengan metode Agile Development. PROSISKO J. Pengemb. Ris. dan Obs. Sist. Komput, 11(1), 10-19.
[12] Perkasa, R. L. (2024). Rancang Bangun Aplikasi Sinaraja (Sinau Aksara Jawa) Berbasis Website. Jurnal Doctoral dissertation, 6(2), 25-32.
[13] Hidayat, A. R. (2021). Perancangan Sistem Informasi Pengelola Barang/Inventaris Di Jc Komp. IKRA-ITH Informatika: Jurnal Komputer dan Informatika, 5(1), 82-87.
[14] Hari Utami, F. (2022). Aplikasi Pelayanan Antrian Pasien Menggunakan Metode FCFS Menggunakan PHP dan MySQL. Jurnal Media Infotama, 18(1), 341139.
[15] Pertiwi, T. A., Luchia, N. T., Sinta, P., Dahlia, A., Fachrezi, I. R., & Aprinastya, R. (2023). Perancangan dan implementasi sistem informasi absensi berbasis web menggunakan metode Agile Software Development. Jurnal Testing Dan Implementasi Sistem Informasi, 1(1), 53-66.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Yunita Amalia
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
You are free to:
- Share — copy and redistribute the material in any medium or format for any purpose, even commercially.
- Adapt — remix, transform, and build upon the material for any purpose, even commercially.
- The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
- Attribution — You must give appropriate credit , provide a link to the license, and indicate if changes were made . You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- ShareAlike — If you remix, transform, or build upon the material, you must distribute your contributions under the same license as the original.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Notices:
You do not have to comply with the license for elements of the material in the public domain or where your use is permitted by an applicable exception or limitation .
No warranties are given. The license may not give you all of the permissions necessary for your intended use. For example, other rights such as publicity, privacy, or moral rights may limit how you use the material.
