International Journal of Information Engineering and Electronic Business (IJIEEB)
IJIEEB Vol. 12, No. 6, 8 Dec. 2020
Cover page and Table of Contents: PDF (size: 1738KB)
Implementation of Business Intelligence to Determine Evaluation of Activities (Case Study Indonesia Stock Exchange)
Full Text (PDF, 1738KB), PP.51-67
Views: 0 Downloads: 0
Author(s)
Ali Fajri
1,*
Ardiles Sinaga
1
Index Terms
Business intelligence, data warehouse, etl, classification, naive bayes classifier, activites evaluation
Abstract
This study aims to examine how to evaluate the activities undertaken in IDX. By building the system "business intelligence implementation to determine the evaluation of activities ". Where in this study also used the algorithm Naive Bayes in the process of data classification activities that have been done. The approach to the development of this software is through the study of libraries, data collection, system design, system implementation, Test systems and analysis. The tools used in the development of this software are Pentaho, PostgreSQL (as a data processing tool), Microsoft Excel (as a tool for creating training data), XAMPP (as a Web server tool) and the encoding used in this software development is the PHP CodeIgniter framework (as the backend), Highcharts (as Dashboard views) and DataTables (as table views). In this study, authors build software that is expected to help the Directorate of Development (RPE) in conducting evaluation activities in IDX. The analysis of the study uses variables from budget-realization data and activity categories as comparators to figure out the activity status. The study also used IDX activity data in 2018 to implement a built-in system. The results of this study show that the realization of the budget and category of this activity strongly affects the activities that will be evaluated or not evaluated. Activities in each of the IDX representative offices are also potentially to be evaluated, depending on the value of the budget specified in the training data set.
Cite This Paper
Ali Fajri, Ardiles Sinaga, "Implementation of Business Intelligence to Determine Evaluation of Activities (Case Study Indonesia Stock Exchange)", International Journal of Information Engineering and Electronic Business(IJIEEB), Vol.12, No.6, pp. 51-67, 2020. DOI:10.5815/ijieeb.2020.06.05
Reference
[1]Rahmat Tri Yunandar, Amir and Khairul Rizal, “Perancangan Data Warehouse Untuk Informasi Strategi Studi Kasus Penerimaan Siswa Baru STIE Binaniaga Bogor”, Journal of Computer Engineering AMIK BSI, Indonesia, Vol. 06, No.1, January 2020.
[2]Masdiana Sagala, “Implementasi Data Warehouse Pada Perpustakaan Universitas Katolik Santo Thomas”, Journal Unika Informatics Engineering St. Thomas (JTIUST), Indonesia, Vol. 03, No.01, June 2018.
[3]Vishal Gour, Dr. S.S.Sarangdevot, Govind Singh Tanwar and Anand Sharma, “Improve Performance of Extract, Transform and Load (ETL) in Data Warehouse”, International Journal on Computer Science and Engineering, Vol. 02, No.03, 2010.
[4]WANG Yijun and WANG Jun, “Application of Highcharts in the Analysis of the Multi-source Track Inspection Data”, International Conference on Mechatronics, Electronic, Industrial and Control Engineering, 2015.
[5]Jin Bao Song, Jin Hong Song, Jian Ping Chai and Yue Yang, “Data Visualization of the Advertising Exchange Flow Statements Generation System on Demand Side Platform Based on Highcharts”, MATEC Web of Conferences, 63, 05029 (2016).
[6]Ramos Somya and Setiawan Chandra Utama, “PERANCANGAN CUSTOMER RELATIONSHIP MANAGEMENT BERBASIS WEB DENGAN LIBRARY JQUERY RESPONSIVE DATATABLES”, Journal of Information Systems at Indagiri Islamic University, Indonesia, Vol. 08, No.9, September 2019.
[7]Budi Ramadhani, “KLASIFIKASI METODE NAIVE BAYES UNTUK KELANCARAN PEMBAYARAN KREDIT LEASING SEPEDA MOTOR”, Technologia, Indonesia, Vol. 08, No.03, July - September 2017.
[8]Bustami, “PENERAPAN ALGORITMA NAIVE BAYES UNTUK MENGKLASIFIKASI DATA NASABAH ASURANSI”, Journal Informathic Malikussaleh Releut University, Indonesia, Vol. 08, No.01, January 2014.
[9]Budi Harijanto, Yuri Ariyanto and Luthfia Miftahurroifa, “PENERAPAN ALGORITMA NAÏVE BAYES UNTUK KLASIFIKASI RETENSI ARSIP”, Journal Informathic Polinema Malang Polytechnic, Indonesia, Vol. 04, Edition.02, Februari 2018.
[10]Marhalim AR Walad Mahfuzhi and Sandhi Fernandes, Yuri Ariyanto and Luthfia Miftahurroifa, Pembuatan Aplikasi Pendukung Keputusan Beasiswa Tidak Mampu Dengan Metode Naive Bayes”, Muhammadiyah Bengkulus University, Indonesia.
[11]M. Golfarelli, S. Rizzi, and I. Cella, “Beyond Data Warehousing: What’s Next In Business Intelligence?” in DOLAP ’04, Washington DC, 2004
[12]S. Negash, and P. Gray, (2003). “Business Intelligence”, in Americas Conference on Information Systems (AMCIS), 2003.
[13]Dedi Lazwardi, “IMPLEMENTASI EVALUASI PROGRAM PENDIDIKAN DI TINGKAT SEKOLAH DASAR DAN MENENGAH”, Al-Idarah: Islamic Education Journal, Indonesia, Vol. 02, 2017.
[14]Saeed Rouhani, Sara Asgari and Seyed Vahid Mirhosseini, “Review Study: Business Intelligence Concepts and Approaches”, American Journal of Scientific Research, 2012.
[15]Dr. H.M. Fauzan, S.H., M.H. and Baharuddin Siagian, S.H., M.Hum., “Kamus Hukum dan Yurisprudensi”, Kencana, Indonesia, 1182 pages, December 2016.
[16]Salwa Mohammed Nejres, “Analysis of Data Warehousing and Data Mining in Education Domain”, International Journal of Advances in Computer Science and Technology, Vol. 04, No.04, April 2015.
[17]Jan Van den Bussche., “Database Theory, Yuri, and Me”, Kencana, Indonesia, January 2010.
[18]MATTEO GOLFARELLI, DARIO MAIO and STEFANO RIZZI, “THE DIMENSIONAL FACT MODEL: A CONCEPTUAL MODEL FOR DATA WAREHOUSES”, International Journal of Cooperative Information Systems, June 1998
[19]W. H. Inmon, “Building the Data Warehouse”, Wiley, New York, NY, USA, 3rd edition, 2002.
[20]R. Kimball, L. Reeves, W. Thornthwaite, M. Ross, and W. Thornwaite, “The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses, Wiley, New York, NY, USA, 1998.
[21]Pouria Kaviani and Mrs. Sunita Dhotre,“Short Survey on Naive Bayes Algorithm”, International Journal of Advance Engineering and Research Development, Vol. 04, No.11, November 2017.
[22]Euis Nina Saparina Yuliani, Heru Subawanto and Anggi Oktaviani, “Business Intelligence Dashboard Implementation on a Travel Agency in Jakarta”, International Journal of Advanced Engineering Research and Science, Vol. 04, No. 6, June 2017
[23]Bernhard Wieder and Maria-Luise Ossimitz, “The impact of Business Intelligence on the quality of decision making – a mediation model”, Procedia Computer Science, October 2015
[24]Shaheb Ali, Shah J. Miah and Shahadat Khan, “ANALYSIS OF INTERACTION BETWEEN BUSINESS INTELLIGENCE AND SMES: LEARN FROM EACH OTHER”, Journal of Information Systems and Technology Management, Vol. 14, No. 02, May/August 2017
[25]Pirttimäki V, Lönnqvist A, Karjaluoto A, “Measurement of business intelligence in a Finnish telecommunications company”, Electron J Knowledge Management, 2006
[26]Azoff, M. and Charlesworth, I., “The New Business Intelligence, a European Perspective, Butler Group”, White Paper, 2004
[27]Muhmmad I. Nofal and Zawiyah M. Yusof, “Integration of Business Intelligence and Enterprise Resource Planning within Organizations”, Procedia Technology, 2013
[28]Hergovind Singh and Harsh Vardhan Samalia, “A Business Intelligence Perspective for Churn Management”, Procedia Technology, 2013