BUILDING DATA MARTS IN TEACHING MANAGEMENT: A CASE STUDY IN CENTER FOR HUMAN RESOURCE DEVELOPMENT
Received: 21st July 2022; Revised: 10th October 2022, 19th October 2022, 31st October 2022; Accepted: 8th November 2022
DOI:
https://doi.org/10.20319/pijtel.2022.63.0114Keywords:
Data Warehouse, Data Mart, Teaching Management, Information Systems, Decision MakingAbstract
This research is a series of researches with the theme Smart-Pusdiklat in the environment of State Cyber and Crypto Agency (BSSN). The locus chosen is the Human Resources Development Center (Pusbang) which is a subset of BSSN. Pusbang is a supporting element of the duties and functions of BSSN, which has the task of carrying out functional position coaching, and developing human resource competencies in the field of cyber security. The research question expressed is how to make leaders at Pusbang and stakeholders can make more comprehensive and fast decisions in managing institutions with the help of data warehouses. The researcher conducted a projection to build a data warehouse, which was then focused on becoming a specific data mart, and explained how users could access it for teaching management purposes at Pusbang. This research uses exploratory research methods with a qualitative approach. This method is intended to try a new phenomenon that may not have been before. This is the novelty value of this study. Researcher project the construction of 4 (four) data marts, namely JFKamsiber, References, Lecturer profiles, and Alumni data mart. Where this can make it easier for users to analyze, report and mine data in teaching management.
References
Asif, R., Merceron, A., Ali, S. A., & Haider, N. G. (2017). Analyzing undergraduate students’ performance using educational data mining. Computers & Education, 113, 177–194. https://doi.org/https://doi.org/10.1016/j.compedu.2017.05.007
Asropi. (2016). Analisis Penelitian. Modul Kewidyaiswaraan Berjenjang Tingkat Menengah. Lembaga Administrasi Negara.
Bassil, Y. (2012). A Data Warehouse Design for A Typical University Information System. In JCSCR Journal of Computer Science & Research Journal of Computer Science & Research (Vol. 1, Issue 6). http://www.jcscr.com
BSSN Regulations No. 6, Accessed Oct 1, 2022. Cyber and Crypto Agency Organization and Work Procedure. (2021). https://peraturan.bpk.go.id/Home/Details/174277/peraturan-bssn-no-6-tahun-2021
Creswell, J. W. (2014). Research-Design. Qualitative, Quantitative and Mixed MethodsApproaches (U. Nebraska-Lincoln, Ed.; 4th ed.). Sage Publication Inc.
D’Oca, S., & Hong, T. (2015). Occupancy schedules learning process through a data mining framework. Energy and Buildings, 88, 395–408. https://doi.org/https://doi.org/10.1016/j.enbuild.2014.11.065
Dharayani, R., Ayu Laksitowening, K., & Putri Yanuarfiani, A. (2015). Implementasi ETL (Extract, Transform, Load) Pangkalan Data Perguruan Tinggi dengan Menggunakan State-Space Problem. E_Proceeding of Engineering, 2(1), 1159–1165. https://openlibrarypublications.telkomuniversity.ac.id/index.php/engineering/article/view/2435
Duran-Dominguez, A., Gomez-Pulido, J. A., & Pajuelo-Holguera, F. (2018). Virtual Classrooms as Data Sources for Prediction Tools. PUPIL: International Journal of Teaching, Education and Learning, 2(2), 170–180. https://doi.org/10.20319/pijtel.2018.22.170180
Duran-Dominguez, A., Gomez-Pulido, J. A., & Pajuelo-Holguera, F. (2018). Virtual Classrooms as Data Sources for Prediction Tools. PUPIL: International Journal of Teaching, Education and Learning, 2(2), 170–180. https://doi.org/10.20319/pijtel.2018.22.170180
Golfarelli, M., Rizzi, S., & Saltarelli, E. (2000). Index selection techniques in data warehouse systems.
Gusti Ngurah Agung Trisna Putra, I., Nyoman Aditya Mahendra, I., Made Suwija Putra, I., Studi Teknologi Informasi, P., Teknik, F., Udayana, U., Raya Kampus Unud Jimbaran, J., & Kuta Sel, K. (2020). Implementasi ETL Data Warehouse dengan Konsep Fitur Metadata dan Cleansing Data. Jurnal Sistem Informasi, 9(2), 274–289. https://doi.org/10.32520/stmsi.v9i2.732
Hamoud, A. K., Ulkareem, M. A., Hussain, H. N., Mohammed, Z. A., & Salih, G. M. (2020). Improve HR Decision-Making Based on Data Mart and OLAP. Journal of Physics: Conference Series, 1530(1). https://doi.org/10.1088/1742-6596/1530/1/012058
Han, J., Kamber, M., & Pei, J. (2012). Data Mining. Concepts and Techniques, 3rd Edition (The Morgan Kaufmann Series in Data Management Systems) (Vol. 3). https://www.google.co.id/books/edition/Data_Mining_Southeast_Asia_Edition/AfL0t-YzOrEC?hl=id&gbpv=0
Indonesian MNDP. (2019). BSSN Launches National Cyber Security Occupational Map. Accessed Oct 1, 2022. Indonesian Ministry of National Development Planning. https://petaokupasi.bappenas.go.id/2020/08/05/bssn-luncurkan-peta-okupasi-nasional-keamanan-siber
Indonesian MNDP. (2021). One Data Portal. Find Government data easily! Indonesian Ministry of National Development Planning. Accessed Oct 1, 2022. Indonesian Ministry of National Development Planning. https://data.go.id/
Mirabedini, S. (2014). The Role of Data warehousing in Educational Data Analysis. Journal of Novel Applied Sciences, 3(1), 1430–1445. https://jnasci.org/wp-content/uploads/2014/12/1439-1445.pdf
Narasimhan, G. (2014). Developing a Decision Support System Using Cancer Data Warehouse Cancer Spread Pattern-an Analysis using Classification and Prediction Techniques View Project Developing a Decision Support System Using Cancer Data Warehouse View project Developing a Decision Support System Using Cancer Data Warehouse Index Terms-Data warehouse, Cancer disease, ETL procedure, Decision Support System, Data Mining. Article in International Journal of Scientific and Engineering Research, 5(9). http://www.ijser.org
Oracle. (2022, October 17). What Is a Data Warehouse? Oracle Inc. https://www.oracle.com/database/what-is-a-data-warehouse/#:~:text=A
Rizzi, S., & Saltarelli, E. (2003). View Materialization vs. Indexing: Balancing Space Constraints in Data Warehouse Design. In J. Eder & M. Missikoff (Eds.), Advanced Information Systems Engineering (pp. 502–519). Springer Berlin Heidelberg. https://doi.org/https://doi.org/10.1007/3-540-45017-3_34
Romero, C., & Ventura, S. (2020). Educational data mining and learning analytics: An updated survey. WIREs Data Mining and Knowledge Discovery, 10(3), e1355. https://doi.org/https://doi.org/10.1002/widm.1355
Santoso, L. W., & Yulia. (2017). Data Warehouse with Big Data Technology for Higher Education. Procedia Computer Science, 124, 93–99. https://doi.org/10.1016/j.procs.2017.12.134
Subrahmanyam, V. v, & Doja, P. M. N. (2008). An UML Based Approach for Designing the Conceptual Model of a Data Warehouse. Conference: 3rd National Conference on Methods and Models in Computing (NCM2C-2008) At: JNU, New Delhi. https://www.researchgate.net/publication/315109300_An_UML_Based_Approach_for_Designing_the_Conceptual_Model_of_a_Data_Warehouse
Subrahmanyam, V., & Doja, M. (2011). A Data Mart Approach for a Centralized Egovernance Data Warehouse. Research Journal of Economics, Business and ICT, 1, 48–53. https://ojs.journals.cz/index.php/RJEBI/article/view/185
Sugiyono. (2018). Metode penelitian kuantitatif, kualitatif dan kombinasi (mixed methods) (Alfabeta, Ed.; 19th ed., Vol. 10). Alfabeta. https://opac.perpusnas.go.id/DetailOpac.aspx?id=853411
Suprijandoko, F. (2017). Transformasi Brand Lembaga Sandi Negara Menjadi Badan Siber dan Sandi Negara: Brand Management Dalam Proses Komunikasi Efektif Untuk Mendapatkan Dukungan Publik. NIPA International Seminar: Reconstructing Public Administration Reform to Build World Class Government., 789–799. https://doi.org/doi:10.13140/RG.2.2.33196.10887
Suprijandoko, F. (2018). Hypno-Andragogy 2.0: Transformation of Learning Process Using Hypnosis Method in Andragogy Class. PEOPLE: International Journal of Social Sciences, 4(3), 196–207. https://doi.org/10.20319/pijss.2018.43.196207
Suprijandoko, F. (2020). Smart-Pusdiklat: Proyeksi Model Scenario Building and Planning Dalam Transformasi Pusdiklat BSSN. Jurnal Kewidyaiswaraan, 5(2), 55–61. https://jurnalpjf.lan.go.id/index.php/jurnalkewidyaiswaraan/article/view/86/31
Syed Badrul Hisham, S. R. A. A. binti, Md Fadhil, M. binti, & Rasul, N. binti. (2020). Impact Of Learning Analytics Towards Students Performance. PEOPLE: International Journal of Social Sciences, 5(3), 457–474. https://doi.org/10.20319/pijss.2019.53.457474
Varshney, H. (2022, October 17). What is a Data Staging Area | Staging Data Simplified 101. Hevo Data Inc. https://hevodata.com/learn/data-staging-area/
Warnars, S. (2009). Desain ETL Dengan Contoh Kasus Perguruan Tinggi. Jurnal Informatika, 10(2), 86–93. https://doi.org/10.9744/informatika.10.2.86-93
Yu, X. (2021). The Application of Data Warehouse in Teaching Management in Colleges and Universities. Journal of Physics: Conference Series, 1738(1). https://doi.org/10.1088/1742-6596/1738/1/012090
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2022 Firman Suprijandoko
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
Copyright of Published Articles
Author(s) retain the article copyright and publishing rights without any restrictions.
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
