Business Intelligence System for Evaluation of Widyaiswara Ministry of Religious Affairs Performance
Sistem Business Intelligence untuk Evaluasi Kinerja Widyaiswara Kementerian Agama
Abstract
The Religious Research, Development and Training Agency of the Ministry of Religious Affairs as a supervisory unit for Widyaiswara functional positions, has the task of evaluating the performance of Widyaiswara of the Ministry of Religious Affairs. That demands the availability of a need for reports or data that presented quickly and accurately when the Widyaiswara performance evaluation process is conducted every year. The problem that occurs these days is that the data on the result of credit score of Widyaiswara assessment are stored in an unstructured excel file. This study utilizes the data warehouse and business intelligence in the process of Widyaiswara performance evaluation. The OLTP (Online Transaction Process) Data that presented for data warehouse is the result of credit score of Widyaiswara assessment. The planning of data warehouse conducted through nine-steps methodology that created by Kimball and Ross, then those data were analyzed using OLAP (Online Analytical Processing) in the application of qliksense in the form of dashboard business intelligence to present the data in a faster visual form. The result, giving the information to the leader to evaluate the performance of Widyaiswara, especially in making decision such as circular letter to improve the quality of Widyaiswara performance, the minimum score limit in the performance agreement, reward in the form of certificate of appreciation for the highest score and punishment in the form of warning letter for the low total score.
Downloads
References
C. Vercellis, Business Intelligence: Data Mining and Optimization for Decision Making. Wiley, 2009.
W. Grossmann and S. Rinderle-Ma, Fundamentals of Business Intelligence. Berlin, Heidelberg: Springer Berlin Heidelberg, 2015.
M. Muntean, L. G. Cabău, and V. Rînciog, “Social Business Intelligence: A New Perspective for Decision Makers,” Procedia - Soc. Behav. Sci., vol. 124, pp. 562–567, 2014, doi: 10.1016/j.sbspro.2014.02.520.
M. A. Aufaure, R. Chiky, O. Curé, H. Khrouf, and G. Kepeklian, “From Business Intelligence to semantic data stream management,” Futur. Gener. Comput. Syst., vol. 63, no. C, pp. 100–107, Oct. 2016, doi: 10.1016/j.future.2015.11.015.
F. Azma and M. A. Mostafapour, “Business intelligence as a key strategy for development organizations,” Procedia Technol., vol. 1, pp. 102–106, Jan. 2012, doi: 10.1016/j.protcy.2012.02.020.
P. F. Kurnia and Suharjito, “Business Intelligence Model to Analyze Social Media Information,” in Procedia Computer Science, 2018, vol. 135, pp. 5–14, doi: 10.1016/j.procs.2018.08.144.
P. Hawking and C. Sellitto, “Business Intelligence Strategy,” Int. J. Enterp. Inf. Syst., vol. 11, no. 1, pp. 1–12, Jan. 2015, doi: 10.4018/ijeis.2015010101.
R. Kimball and J. Caserta, The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning Conforming, and Delivering Data. Wiley, 2004.
W. H. Inmon, Building the Data Warehouse. (Fourth Ed.). Wiley Pub, 2005.
A. S. Girsang and A. Purwanto, “Controlling system for stock raw material for production planning and inventory control in a pharmacy company,” Int. Rev. Mech. Eng., vol. 11, no. 11, pp. 855–861, Nov. 2017, doi: 10.15866/ireme.v11i11.12330.
A. S. Girsang and C. W. Prakoso, “Data warehouse development for customer WIFI access service at a telecommunication company,” Int. J. Commun. Antenna Propag., vol. 7, no. 2, pp. 114–124, Apr. 2017, doi: 10.15866/irecap.v7i2.11736.
A. S. Girsang et al., “Decision support system using data warehouse for hotel reservation system,” in Proceedings - 2017 International Conference on Sustainable Information Engineering and Technology, SIET 2017, 2018, vol. 2018-Janua, pp. 369–373, doi: 10.1109/SIET.2017.8304166.
O. P. Rahadian, M. Hidayati, M. Sujono, A. S. Girsang, and S. M. Isa, “Business Intelligence for a Digital Music Content Provider,” in 1st 2018 Indonesian Association for Pattern Recognition International Conference, INAPR 2018 - Proceedings, 2019, pp. 123–127, doi: 10.1109/INAPR.2018.8627051.
A. S. Girsang, D. A. Sunarna, A. Syaikhoni, and A. Ariyadi, “Business Intelligence for Education Management System,” in 2019 International Conference of Computer Science and Information Technology, ICoSNIKOM 2019, 2019, doi: 10.1109/ICoSNIKOM48755.2019.9111559.
K. Wahyudi, J. Latupapua, R. Chandra, A. S. Girsang, and S. M. Isa, “Business Intelligence for Employment Classification in Jakarta Government Data,” in Proceeding - 2019 International Conference on ICT for Smart Society: Innovation and Transformation Toward Smart Region, ICISS 2019, 2019, doi: 10.1109/ICISS48059.2019.8969851.
K. C. Susena, D. M. Simanjuntak, Parwito, W. Fadillah, Yulyardo, and A. S. Girsang, “Business Intelligence for Evaluating Loan Collection Performance at Bank,” in 2018 International Conference on Orange Technologies, ICOT 2018, 2018, doi: 10.1109/ICOT.2018.8705829.
R. Kimball and M. Ross, The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence Remastered Collection. 2016.
Copyright (c) 2020 Jurnal RESTI (Rekayasa Sistem dan Teknologi Informasi)
This work is licensed under a Creative Commons Attribution 4.0 International License.
Copyright in each article belongs to the author
- The author acknowledges that the RESTI Journal (System Engineering and Information Technology) is the first publisher to publish with a license Creative Commons Attribution 4.0 International License.
- Authors can enter writing separately, arrange the non-exclusive distribution of manuscripts that have been published in this journal into other versions (eg sent to the author's institutional repository, publication in a book, etc.), by acknowledging that the manuscript has been published for the first time in the RESTI (Rekayasa Sistem dan Teknologi Informasi) journal ;
