BUILDING DATA MARTS IN TEACHING MANAGEMENT: A CASE STUDY IN CENTER FOR HUMAN RESOURCE DEVELOPMENT

Authors

  • Firman Suprijandoko M.IT (Computer Science), Senior Trainer (Widyaiswara Madya) at Center for Human Resource Development, National Cyber and Crypto Agency (BSSN), Jakarta, Indonesia

DOI:

https://doi.org/10.20319/pijtel.2022.63.0114

Keywords:

Data Warehouse, Data Mart, Teaching Management, Information Systems, Decision Making

Abstract

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

2022-11-15

How to Cite

Suprijandoko, F. (2022). BUILDING DATA MARTS IN TEACHING MANAGEMENT: A CASE STUDY IN CENTER FOR HUMAN RESOURCE DEVELOPMENT. PUPIL: International Journal of Teaching, Education and Learning, 6(3), 1–14. https://doi.org/10.20319/pijtel.2022.63.0114