Implementation of a Business Intelligence Model for Analysis Banking and Credit Management

Nilo Legowo, Achmad Yodan Gimpalas

Abstract


The 2008 global financial crisis affected the pace of the economy by reducing the level of public trust in banks. Seeing these conditions, Bank XYZ needs to know and analyze the factors that influence bank lending. Debtor data processing at Bank XYZ is well integrated, but in fact, Bank XYZ still needs to pay attention to the principle of prudence in making decisions to provide credit facilities to debtors with minimal risk so that credit can be extended consistently and based on sound credit principles. In monitoring and analyzing the credit system at Bank XYZ, there is one factor that serves as a reference for measuring a bank's ability to bear the risk of credit failure by debtors through NPLs (non-performing loans). In addition to NPLs, the growth in the number of debtors, the amount of credit disbursement, the amount of outstanding credit provided in various sectors, and the amount of collectibility of debtors also play an important role in decision-making by management; therefore, the author proposes a business intelligence model to analyze credit data at XYZ Bank in the form of data visualization in dashboard form. The dashboard was built using the Tablue for Students software. The results of this study are a business intelligence model in the form of a dashboard application to be able to monitor debtor data growth, analyze loans extended in various economic sectors, and analyze outstanding loans using the NPL value as a reference based on credit quality as a decision support tool.

Keywords


Business Intelligence; Dashboard; Non Performing Loan (NPL)

Full Text:

PDF

References


R. Akbar and M. Octaviany, “Perancangan Visualisasi Dashboard dan Clustering dengan Menerapkan Business Intelligence pada Dinas DPMPTSP Kabupaten Dharmasraya,” J. Edukasi dan Penelit. Inform., vol. 7, no. 3, p. 340, 2021, doi: 10.26418/jp.v7i3.49719.

S. Pada, B. Umum, D. Indonesia, and P. Tahun, “CBAM-FE Faktor-Faktor Yang Berpengaruh Dalam Penentuan,” CBAM-FE Unissula, vol. 1, no. 1, pp. 61–74, 2012.

D. Chen Sami, N. Dessy Rumlaklak, E. S. Y Pandie, and I. Komputer, “‘Jurnal TRANSFORMASI (Informasi & Pengembangan Iptek)’ (STMIK BINA PATRIA) ANALISA TRANSAKSI SISTEM KREDIT MENGGUNAKAN METODE ONLINE ANALYTICAL PROCESSING,” J. Transform., vol. 18, no. 1, pp. 54–65, 2022.

A. Aprianti and W. Wulandari, “Pengaruh Lingkungan Kerja Non Fisik Terhadap Disiplin Kerja Pegawai Pada Badan Perencanaan dan Pembangunan Daerah (BAPPEDA) Kota Bima,” J. Akuntansi, Manajemen, Bisnis dan Teknol., vol. 2, no. 2, pp. 246–253, 2022, doi: 10.56870/ambitek.v2i2.54.

C. E. Budiawan and S. Halim, “Perancangan Dashboard Monitoring Contract Lifecycle Management pada PT X,” J. Titra, vol. 10, no. 2, pp. 57–64, 2022, [Online]. Available: https://publication.petra.ac.id/index.php/teknik-industri/article/view/12843.

R. M. Widagdo and A. W. Utami, “Rancang Bangun Sistem Informasi Pemasaran (SIP) Business Intelligence Berbasis WEB-GIS pada PT.SPINDO Tbk,” J. Emerg. Inf. Syst. Bus. Intell., vol. 3, no. 4, pp. 53–63, 2022, [Online]. Available: https://ejournal.unesa.ac.id/index.php/JEISBI/article/view/48368%0Ahttps://ejournal.unesa.ac.id.

E. Paradis, B. O’Brien, L. Nimmon, G. Bandiera, and M. A. T. Martimianakis, “Design: Selection of Data Collection Methods,” J. Grad. Med. Educ., vol. 8, no. 2, pp. 263–264, 2016, doi: 10.4300/JGME-D-16-00098.1.

A. A. Quality, “AQuA Performance Testing Criteria.” [Online]. Available: https://www.appqualityalliance.org/aqua-performance-test-criteria.

J. D. Woollins, “The Preparation and Structure of Metalla-Sulphur/Selenium Nitrogen Complexes and Cages,” Stud. Inorg. Chem., vol. 14, no. C, pp. 349–372, 1992, doi: 10.1016/B978-0-444-88933-1.50023-4.

L. S. Utami and S. Musyarofah, “Analisis Pengetahuan dan Sikap Warga Desa Wahas dan Kampung Ampel Maghfur terhadap Gizi Seimbang, Protokol Kesehatan, dan Vaksinasi COVID-19,” J. Ilm. Permas J. Ilm. STIKES Kendal, vol. 11, no. 1, pp. 1–8, 2021.

T. A. Ghaffur, “Analisis Kualitas Sistem Informasi Kegiatan Sekolah Berbasis Mobile Web Di Smk Negeri 2 Yogyakarta,” Elinvo (Electronics, Informatics, Vocat. Educ., vol. 2, no. 1, pp. 94–101, 2017, doi: 10.21831/elinvo.v2i1.16426.

V. H. Pranatawijaya, W. Widiatry, R. Priskila, and P. B. A. A. Putra, “Penerapan Skala Likert dan Skala Dikotomi Pada Kuesioner Online,” J. Sains dan Inform., vol. 5, no. 2, pp. 128–137, 2019, doi: 10.34128/jsi.v5i2.185.

D. Daryanto, M. K. Anam, Y. Efendi, and R. Rahmaddeni, “Pengujian ISO 25010 Pada Smart Chair Akupresure Berbasis Internet Of Things (IoT),” J. Media Inform. Budidarma, vol. 6, no. 3, p. 1476, 2022, doi: 10.30865/mib.v6i3.4134.




DOI: http://dx.doi.org/10.38101/sisfotek.v13i2.7298

Refbacks

  • There are currently no refbacks.


 

JURNAL SISFOTEK GLOBAL

Organized by: Research Center and Community Development
Published by: Institut Teknologi dan Bisnis Bina Sarana Global
Jl. Aria Santika No.43A, Margasari, Kec. Karawaci, Kota Tangerang, Banten 15114
Phone. +62 552 2727
Email: lppm@global.ac.id

INDEXED BY:

   


Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License..
Based on a work at https://journal.global.ac.id/index.php/sisfotek/index.