Perancangan Datamart Nilai Akademik Siswa Pada SMA Z Bekasi
Abstract
Pemantauan prestasi akademik siswa merupakan aspek penting dalam meningkatkan kualitas pendidikan di sekolah. SMA Z Bekasi membangun dashboard analitik untuk membantu pemantauan prestasi akademik siswa. Dalam pembangunan dashboard tersebut, diperlukannya datamart yang memiliki peran penting dalam pengelolaan nilai akademik secara efisien dan terstruktur, serta menyatukan data dalam satu sumber dan format. Penelitian ini bertujuan untuk merancang datamart yang mengakomodasi kebutuhan pengelolaan data nilai akademik siswa secara terpusat. Datamart dirancang menggunakan pendekatan dimensional modeling dengan metode star schema, yang mencakup tabel fakta nilai akademik dan tabel dimensi seperti siswa, mata pelajaran, dan periode waktu. Proses pengembangan meliputi tahapan extract, transform, and load ETL, sehingga data dari berbagai sumber dapat diintegrasikan dengan baik. Hasil penelitian menunjukkan bahwa datamart yang dirancang berhasil meningkatkan efisiensi pengelolaan dan analisis data akademik, serta mendukung proses pengambilan keputusan terkait evaluasi prestasi akademik di SMA Z Bekasi. Implementasi ini juga memudahkan pelaporan dan pemantauan nilai siswa secara lebih cepat dan akurat.
References
Amin, M., Sutrisman, A., & Dwitayanti, Y. (2021). Development of Star-Schema Model for Lecturer Performance in Research Activities. International Journal of Advanced Computer Science and Applications, 12. https://doi.org/10.14569/IJACSA.2021.0120909
Ari Putra, R., Khalid, K., & Rolliawati, D. (2021). Implementasi Dashboard Akademik Bebasis Website Berdasarkan Instrumen Akreditasi Program Studi 4.0. Systemic: Information System and Informatics Journal, 7(1), 1–9. https://doi.org/10.29080/systemic.v7i1.1310
Braojos, C., Rodríguez-Domínguez, C., Daniela, L., & Carranza-García, F. (2023). An Analytical Dashboard of Collaborative Activities for the Knowledge Building. Technology, Knowledge and Learning. https://doi.org/10.1007/s10758-023-09644-y
Castillo-Cordero, L., Contreras-Chihuán, M., & Meneses-Claudio, B. (2024). Datamart for the analysis of information in the sales process of the company WC HVAC Engineering. Data and Metadata, 3, 184. https://doi.org/10.56294/dm2024184
Chauhan, S., Gupta, P., Palvia, S., & Jaiswal, M. (2021). Information Technology Transforming Higher Education: A Meta-Analytic Review. Journal of Information Technology Case and Application Research, 23(1), 3–35. https://doi.org/10.1080/15228053.2020.1846480
Fahrezy, H., Silaen, T., & Henderi, P. (2020). MODEL INFORMATION DASHBOARD NILAI SISWA: TOOLS MONITORING HASIL BELAJAR. Jurnal Ilmiah Matrik, 22, 36–42. https://doi.org/10.33557/jurnalmatrik.v22i1.837
Hamoud, A. K., Hussein, M. K., Alhilfi, Z., & Sabr, R. H. (2021). Implementing data-driven decision support system based on independent educational data mart. International Journal of Electrical and Computer Engineering (IJECE), 11(6), 5301. https://doi.org/10.11591/ijece.v11i6.pp5301-5314
Huberts, L. C. E., Schoonhoven, M., & Does, R. J. M. M. (2022). Multilevel process monitoring: A case study to predict student success or failure. Journal of Quality Technology, 54(2), 127–143. https://doi.org/10.1080/00224065.2020.1828008
Irvan, O., Beng, J. T., & Trisnawarman, D. (2020). DASHBOARD PENGUKURAN KINERJA PROGRAM STUDI PERGURUAN TINGGI. Jurnal Ilmu Komputer dan Sistem Informasi, 8(1), 126. https://doi.org/10.24912/jiksi.v8i1.11483
Jap, T., Amanto, A., Aurelia, A., Chandra, D., Mandey, K., Ramadhani, L., Stephanie, R., & Tiatri, S. (2023). Designing mathematics, science, and reading competency dashboard using business intelligence algorithm. Dalam AIP Conference Proceedings. https://doi.org/10.1063/5.0127648
Khan, I., Ahmad, A. R., Jabeur, N., & Mahdi, M. N. (2021). An artificial intelligence approach to monitor student performance and devise preventive measures. Smart Learning Environments, 8(1). https://doi.org/10.1186/s40561-021-00161-y
Kusnardi, H., Jap, T., & Sutrisno, T. (2023). Dashboard design for predicting the investment value of houses at region Y using database analysis through the DES method. AIP Conference Proceedings, 20141. https://doi.org/10.1063/5.0127641
Lee, Y., & Cho, J. (2023). Analysis of Course Data for Curriculum Review and Improvement. International Journal on Advanced Science, Engineering and Information Technology, 13(3), 1094–1099. https://doi.org/10.18517/ijaseit.13.3.18462
Muhafidin, D. (2020). Improving Quality of Higher Education Using Academic Information System as a Public Administration Service: The Case of Indonesia. Journal of Social Studies Education Research / Sosyal Bilgiler Eğitimi Araştırmaları Dergisi, 11(1), 127–136. http://e-resources.perpusnas.go.id:2048/login?url=https://search.ebscohost.com/login.aspx?direct=true&db=ehh&AN=143126679&site=ehost-live
Najm, I., Mohammed Dahr, J., Hamoud, A., Hashim, A., Akeel, W., Kamel, M. B., & Humadi, A. (2022). OLAP Mining with Educational Data Mart to Predict Students’ Performance. Informatica, 46. https://doi.org/10.31449/inf.v46i5.3853
Nor Hafiza Haron, Ramlan Mahmood, Noornajwa Md Amin, Airuddin Ahmad, & Siti Robaya Jantan. (2024). An Artificial Intelligence Approach to Monitor and Predict Student Academic Performance. Journal of Advanced Research in Applied Sciences and Engineering Technology, 44(1), 105–119. https://doi.org/10.37934/araset.44.1.105119
Rainardi, V. (2008). Building a Data Warehouse (11 ed., Vol. 11). Apress. https://doi.org/10.1007/978-1-4302-0528-9
Spits Warnars, H. L. H., Warnars, L. S., Ramadhan, A., Siswanto, T., & Doucet, A. (2024). Data Warehouse Design for Firefighters Operational at the DKI Jakarta Fire Department. TEM Journal, 13(1), 365–376. https://doi.org/10.18421/TEM131-38
Sugiyanti, S. D., Widayanti, R., Ulum, M. B., Firmansyah, G., & Azizah, A. H. (2022). Design Dashboard Monitoring Teacher Performance Assessment at Cinta Kasih Tzu Chi High School. IAIC Transactions on Sustainable Digital Innovation (ITSDI), 4(1), 46–56. https://doi.org/10.34306/itsdi.v4i1.569
Suharso, W., Fardiansa, A., Munarko, Y., & Wibowo, H. (2021). IMPLEMENTASI STAR SCHEMA PADA STUDI KASUS PERPUSTAKAAN BERSKALA UNIVERSITAS. SINTECH (Science and Information Technology) Journal, 4(1), 1–11. https://doi.org/10.31598/sintechjournal.v4i1.446
Suhendro, D.-. (2020). PENGEMBANGAN DATA WAREHOUSE SEBAGAI SARANA PENUNJANG KEGIATAN AKADEMIK INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL. JIKA (Jurnal Informatika), 4(2), 45. https://doi.org/10.31000/jika.v4i2.2466
Syaputra, A. (2020). Sistem Monitoring Prestasi Akademik Siswa Pada Sekolah Menengah Atas Negeri 5 Pagar Alam. Jurnal Ilmiah Informatika, 5, 76–84. https://doi.org/10.35316/jimi.v5i2.949
Zainuddin, M. I. I. Bin, & Judi, H. M. (2022). Personalised Learning Analytics: Promoting Student’s Achievement and Enhancing Instructor’s Intervention in Self-regulated Meaningful Learning. International Journal of Information and Education Technology, 12(11), 1243–1247. https://doi.org/10.18178/ijiet.2022.12.11.1745
Ari Putra, R., Khalid, K., & Rolliawati, D. (2021). Implementasi Dashboard Akademik Bebasis Website Berdasarkan Instrumen Akreditasi Program Studi 4.0. Systemic: Information System and Informatics Journal, 7(1), 1–9. https://doi.org/10.29080/systemic.v7i1.1310
Braojos, C., Rodríguez-Domínguez, C., Daniela, L., & Carranza-García, F. (2023). An Analytical Dashboard of Collaborative Activities for the Knowledge Building. Technology, Knowledge and Learning. https://doi.org/10.1007/s10758-023-09644-y
Castillo-Cordero, L., Contreras-Chihuán, M., & Meneses-Claudio, B. (2024). Datamart for the analysis of information in the sales process of the company WC HVAC Engineering. Data and Metadata, 3, 184. https://doi.org/10.56294/dm2024184
Chauhan, S., Gupta, P., Palvia, S., & Jaiswal, M. (2021). Information Technology Transforming Higher Education: A Meta-Analytic Review. Journal of Information Technology Case and Application Research, 23(1), 3–35. https://doi.org/10.1080/15228053.2020.1846480
Fahrezy, H., Silaen, T., & Henderi, P. (2020). MODEL INFORMATION DASHBOARD NILAI SISWA: TOOLS MONITORING HASIL BELAJAR. Jurnal Ilmiah Matrik, 22, 36–42. https://doi.org/10.33557/jurnalmatrik.v22i1.837
Hamoud, A. K., Hussein, M. K., Alhilfi, Z., & Sabr, R. H. (2021). Implementing data-driven decision support system based on independent educational data mart. International Journal of Electrical and Computer Engineering (IJECE), 11(6), 5301. https://doi.org/10.11591/ijece.v11i6.pp5301-5314
Huberts, L. C. E., Schoonhoven, M., & Does, R. J. M. M. (2022). Multilevel process monitoring: A case study to predict student success or failure. Journal of Quality Technology, 54(2), 127–143. https://doi.org/10.1080/00224065.2020.1828008
Irvan, O., Beng, J. T., & Trisnawarman, D. (2020). DASHBOARD PENGUKURAN KINERJA PROGRAM STUDI PERGURUAN TINGGI. Jurnal Ilmu Komputer dan Sistem Informasi, 8(1), 126. https://doi.org/10.24912/jiksi.v8i1.11483
Jap, T., Amanto, A., Aurelia, A., Chandra, D., Mandey, K., Ramadhani, L., Stephanie, R., & Tiatri, S. (2023). Designing mathematics, science, and reading competency dashboard using business intelligence algorithm. Dalam AIP Conference Proceedings. https://doi.org/10.1063/5.0127648
Khan, I., Ahmad, A. R., Jabeur, N., & Mahdi, M. N. (2021). An artificial intelligence approach to monitor student performance and devise preventive measures. Smart Learning Environments, 8(1). https://doi.org/10.1186/s40561-021-00161-y
Kusnardi, H., Jap, T., & Sutrisno, T. (2023). Dashboard design for predicting the investment value of houses at region Y using database analysis through the DES method. AIP Conference Proceedings, 20141. https://doi.org/10.1063/5.0127641
Lee, Y., & Cho, J. (2023). Analysis of Course Data for Curriculum Review and Improvement. International Journal on Advanced Science, Engineering and Information Technology, 13(3), 1094–1099. https://doi.org/10.18517/ijaseit.13.3.18462
Muhafidin, D. (2020). Improving Quality of Higher Education Using Academic Information System as a Public Administration Service: The Case of Indonesia. Journal of Social Studies Education Research / Sosyal Bilgiler Eğitimi Araştırmaları Dergisi, 11(1), 127–136. http://e-resources.perpusnas.go.id:2048/login?url=https://search.ebscohost.com/login.aspx?direct=true&db=ehh&AN=143126679&site=ehost-live
Najm, I., Mohammed Dahr, J., Hamoud, A., Hashim, A., Akeel, W., Kamel, M. B., & Humadi, A. (2022). OLAP Mining with Educational Data Mart to Predict Students’ Performance. Informatica, 46. https://doi.org/10.31449/inf.v46i5.3853
Nor Hafiza Haron, Ramlan Mahmood, Noornajwa Md Amin, Airuddin Ahmad, & Siti Robaya Jantan. (2024). An Artificial Intelligence Approach to Monitor and Predict Student Academic Performance. Journal of Advanced Research in Applied Sciences and Engineering Technology, 44(1), 105–119. https://doi.org/10.37934/araset.44.1.105119
Rainardi, V. (2008). Building a Data Warehouse (11 ed., Vol. 11). Apress. https://doi.org/10.1007/978-1-4302-0528-9
Spits Warnars, H. L. H., Warnars, L. S., Ramadhan, A., Siswanto, T., & Doucet, A. (2024). Data Warehouse Design for Firefighters Operational at the DKI Jakarta Fire Department. TEM Journal, 13(1), 365–376. https://doi.org/10.18421/TEM131-38
Sugiyanti, S. D., Widayanti, R., Ulum, M. B., Firmansyah, G., & Azizah, A. H. (2022). Design Dashboard Monitoring Teacher Performance Assessment at Cinta Kasih Tzu Chi High School. IAIC Transactions on Sustainable Digital Innovation (ITSDI), 4(1), 46–56. https://doi.org/10.34306/itsdi.v4i1.569
Suharso, W., Fardiansa, A., Munarko, Y., & Wibowo, H. (2021). IMPLEMENTASI STAR SCHEMA PADA STUDI KASUS PERPUSTAKAAN BERSKALA UNIVERSITAS. SINTECH (Science and Information Technology) Journal, 4(1), 1–11. https://doi.org/10.31598/sintechjournal.v4i1.446
Suhendro, D.-. (2020). PENGEMBANGAN DATA WAREHOUSE SEBAGAI SARANA PENUNJANG KEGIATAN AKADEMIK INSTITUT SAINS DAN TEKNOLOGI AL-KAMAL. JIKA (Jurnal Informatika), 4(2), 45. https://doi.org/10.31000/jika.v4i2.2466
Syaputra, A. (2020). Sistem Monitoring Prestasi Akademik Siswa Pada Sekolah Menengah Atas Negeri 5 Pagar Alam. Jurnal Ilmiah Informatika, 5, 76–84. https://doi.org/10.35316/jimi.v5i2.949
Zainuddin, M. I. I. Bin, & Judi, H. M. (2022). Personalised Learning Analytics: Promoting Student’s Achievement and Enhancing Instructor’s Intervention in Self-regulated Meaningful Learning. International Journal of Information and Education Technology, 12(11), 1243–1247. https://doi.org/10.18178/ijiet.2022.12.11.1745
Published
2024-11-21
Section
Articles
Copyright (c) 2024 Andrew Haikal Marcydiaz, Febby Nurul Fitriya, Alice Shizuka Hutagaol, Dedi Trisnawarman, Jap Tji Beng
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
