BUILDING DATA WAREHOUSE FOR EMPLOYEE TRAINING MINISTRY OF LAW AND HUMAN RIGHTS
Abstract
In order to improve and expand each employee's competency and knowledge, education and training are crucial for the Ministry of Law and Human Rights. They may also be utilized for employee mapping. In the past, it was necessary to gather data on things like the number of employees who attended a particular training, which training had reached its participant quota, and the number of graduates in each training. This required extensive processing and repeated cross-checking of data sources to make sure the data was accurate and legitimate before it could be compiled into a table for analysis.
Information technology may be used to immediately process employee competence data and education and training results into information. Therefore, it is expected that the Nine Step method, which is part of the Kimball & Ross (2010), methodology will simplify and accelerate the process of processing training data into information presented for analysis and reporting purposes at the leadership level in each work unit.
Keywords: data warehouse, OLAP, ETL, pentaho, kemenkumham, training
Full Text:
PDFReferences
Ben Moussa, N., & El Arbi, R. (2020). The impact of Human Resources Information Systems on individual innovation capability in Tunisian companies: The moderating role of affective commitment. European Research on Management and Business Economics, 26(1), 18–25. https://doi.org/10.1016/j.iedeen.2019.12.001
Bpsdm. (2023). E-learning Kemenkumham. E-Learning Kemenkumham. https://e-learning.kemenkumham.go.id/
Celko’s, J. (2014). Complate Guide to NoSQL.
Haleem, A., Javaid, M., Qadri, M. A., & Suman, R. (2022). Understanding the role of digital technologies in education: A review. Sustainable Operations and Computers, 3(May), 275–285. https://doi.org/10.1016/j.susoc.2022.05.004
Kwon, I. H. (2014). Book Review: Process Mining: Discovery, Conformance and Enhancement of Business Processes. In Healthcare Informatics Research (Vol. 20, Issue 2). https://doi.org/10.4258/hir.2014.20.2.157
Lokaadinugroho, I., Girsang, A. S., & Burhanudin, B. (2021). Tableau Business Intelligence Using the 9 Steps of Kimball’s Data Warehouse & Extract Transform Loading of the Pentaho Data Integration Process Approach in Higher Education. Engineering, MAthematics and Computer Science (EMACS) Journal, 3(1), 1–11. https://doi.org/10.21512/emacsjournal.v3i1.6816
Pelser, T. G., & Gaffley, G. (2020). Implications of digital transformation on the strategy development process for business leaders. In Promoting Inclusive Growth in the Fourth Industrial Revolution (Issue January 2020). https://doi.org/10.4018/978-1-7998-4882-0.ch001
Raminhos, R., & Moura-Pires. (2007). Extraction and transformation of data from semi-structured text files using a declarative approach. ICEIS 2007 - 9th International Conference on Enterprise Information Systems, Proceedings, DISI(January 2007), 199–205. https://doi.org/10.5220/0002364201990205
Udayana, G. A., Mahendra, I. M. Y., Sukawirasa, I. K. A., Dimastawan Saputra, G. D., & Mahendra, I. B. M. (2021). Implementasi Data Warehouse Dan Penerapannya Pada PHI-Minimart Dengan Menggunakan Tools Pentaho dan Power BI. JELIKU (Jurnal Elektronik Ilmu Komputer Udayana), 10(1), 163. https://doi.org/10.24843/jlk.2021.v10.i01.p19
Ummah, M. S. (2019). Building Open Source ETL Solutions with Pentaho Data Integration. In Sustainability (Switzerland) (Vol. 11, Issue 1). http://scioteca.caf.com/bitstream/handle/123456789/1091/RED2017-Eng-8ene.pdf?sequence=12&isAllowed=y%0Ahttp://dx.doi.org/10.1016/j.regsciurbeco.2008.06.005%0Ahttps://www.researchgate.net/publication/305320484_SISTEM_PEMBETUNGAN_TERPUSAT_STRATEGI_MELESTARI
Università, L., Sociali, S., Guido, ", Roma, C. ", & Chiara Benfatto, D. M. (2022). Dottorato di Sistemi Informativi Aziendali XXII Ciclo Human Resource Information Systems and the performance of the Human Resource Function Tesi di dottorato.
DOI: http://dx.doi.org/10.26798/jiss.v3i2.1500
Article Metrics
Abstract view : 32 timesPDF - 11 times
Refbacks
- There are currently no refbacks.
Copyright (c) 2024 Ari Fauzi Mukti Nugroho, Rikie Kartadie, Latifah Nurrohmah Handayani, Nenen Isnaeni, Moh. Abdul kholik
JOURNAL OF INTELLIGENT SOFTWARE SYSTEMS
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.