Application of Business Intelligence in Decision Making for Credit Card Approval

Admel Husejinovic; Nermina Durmić; Samed Jukić

doi:10.37380/jisib.v12i2.956

Authors

Admel Husejinovic International Burch University
Nermina Durmić International Burch University
Samed Jukić International Burch University

DOI:

https://doi.org/10.37380/jisib.v12i2.956

Keywords:

Business Intelligence, Chi-Square Test, Credit Card, Data Analysis, Linear Regression

Abstract

This paper aims to show how business intelligence can be applied in the credit card approval process. More specifically, the paper investigates how information like an applicant’s age, credit score, debt, income, and prior default can be used in credit card approval prediction.The dataset used for analysis is a publicly available dataset from the UCI machine learning repository. Logistic regression is used to make a prediction model with a reasonable number of attributes for a comprehensible business model. The Chi-square test of independence is used to test the dependence of credit card approval results with attributes. Research uncovers that prior default is supposed to be the most important attribute in the approval process. Finally, the authors propose several visualizations that could help make smarter decisions with effective credit risk assessment.

References

Alzeaideen, K. (2019) ‘Credit risk management and business intelligence approach of the banking sector in Jordan’, Cogent Business & Management. Cogent, 6(1). doi: 10.1080/23311975.2019.1675455.

Aruldoss, M. et al. (2014) ‘A survey on recent research in business intelligence’, Journal of Enterprise Information Management. doi: 10.1108/JEIM-06-2013-0029.

Balachandran, B. M. and Prasad, S. (2017) ‘Challenges and Benefits of Deploying Big Data Analytics in the Cloud for Business Intelligence’, Procedia Computer Science. Elsevier B. V., 112, pp. 1112–1122. doi: 10.1016/J.PROCS.2017.08.138.

Beltran, D. J. et al. (2021) ‘Credit card sales performance dashboard’, in Proceedings of the International Conference on Industrial Engineering and Operations Management, pp. 1–12.

Benton, J. (2020) Interpreting Coefficients in Linear and Logistic Regression, Towards Data Science. Available at: https://towardsdata

science.com/interpreting-coefficients-in-linear-and-logistic-regression-6ddf1295f6f1 (Accessed: 29 August 2022).

Bhatore, S., Mohan, L. and Reddy, Y. R. (2020) ‘Machine learning techniques for credit risk evaluation: a systematic literature review’, Journal of Banking and Financial Technology 2020 4:1. Springer, 4(1), pp. 111–138. doi: 10.1007/S42786-020-00020-3.

Bogetoft, P. (2012) ‘Performance Benchmarking’, in Performance Benchmarking. Boston, MA: Springer US (Management for Professionals). doi: 10.1007/978-1-4614-6043-5.

Bramer, M. (2016) Introduction to Data Mining. doi: 10.1007/978-1-4471-7307-6_1.

Brian, O. (2020) History of the Credit Card: Origins, Laws and Timeline - TheStreet, History of the Credit Card: Origins, Laws and Timeline. Available at: https://www.thestreet.com/personal-finance/credit-cards/history-of-credit-cards (Accessed: 21 July 2022).

Bridges, B. (2022) What Is APR On A Credit

Card?, Credit Cards. Available at: https://www.bankrate.com/finance/credit-cards/what-is-credit-card-apr/ (Accessed: 19 August

.

Brown, K. and Moles, P. (2014) ‘Credit risk management’, in Credit risk management, pp. 105–138.

Constance, S. (2022) Average Credit Card Debt In The U.S. | Bankrate, Credit Cards. Available at: https://www.bankrate.com/finance/credit-cards/states-with-most-credit-card-debt/ (Accessed: 21 July 2022).

Cortinhas, S. (2022) Credit Card Approvals |

Kaggle. Available at: https://www.kaggle.com/datasets/samuelcortinhas/credit-card-

approval-clean-data (Accessed: 11 August 2022).

Ćurko, K., Bach, M. P. and Radonić, G. (2007) ‘Business intelligence and business process management in banking operations’, in Proceedings of the International Conference on Information Technology Interfaces, ITI, pp. 57–62. doi: 10.1109/ITI.2007.4283744.

Dahiru, T. (2013) ‘P-Value’, Encyclopedia of Radiation Oncology, 6(1), pp. 692–692. doi: 10.1007/978-3-540-85516-3_649.

Dieker, N. (2022) How Your Credit Card Limit Is Determined, Bankrate. Available at: https://www.bankrate.com/finance/credit-

cards/how-issuers-determine-credit-card-limits/ (Accessed: 19 August 2022).

Ghobadi, F. and Rohani, M. (2017) ‘Cost sensitive modeling of credit card fraud using neural network strategy’, Proceedings - 2016 2nd International Conference of Signal Processing and Intelligent Systems, ICSPIS 2016. Institute of Electrical and Electronics Engineers Inc. doi: 10.1109/ICSPIS.2016.7869880.

Gobat, J. (2012) Banks: At the Heart of the Matter. Available at: https://www.imf.org/external/pubs/ft/fandd/basics/bank.htm (Accessed: 11 August 2022).

Grant, W. and Wilson, G. K. (2012) ‘Consequences of the Global Financial Crisis’, The Consequences of the Global Financial Crisis: The Rhetoric of Reform and Regulation. Oxford University Press, p. 287. doi: 10.1093/ACPROF:OSO/9780199641987.001.0001.

Greg, M. (2021) Personal Loans vs. Credit Cards: What’s the Difference?, Personal Loans vs. Credit Cards: What’s the Difference? Available at: https://www.investopedia.com/articles/personal-finance/041415/pros-cons-personal-loans-vs-credit-cards.asp (Accessed: 23 July 2022).

Hayes, A. (2022) Chi-Square (χ2) Statistic. Available at: https://www.investopedia.com/terms/c/chi-square-statistic.asp (Accessed: 27 August 2022).

Infographic (2021) Credit Card Statistics: Global Facts, Data, and Figures. Available at: https://rcbcbankard.com/blogs/credit-card-statistics-global-facts-data-and-figures-16 (Accessed: 29 August 2022).

Jankovic, D. (2021) A Simple Interpretation of Logistic Regression Coefficients, Towards Data Science. Available at: https://towards

datascience.com/a-simple-interpretation-of-logistic-regression-coefficients-e3a40a62e8cf (Accessed: 29 August 2022).

Kibria, M. G. and Sevkli, M. (2021) ‘Application of Deep Learning for Credit Card Approval: A Comparison with Two Machine Learning Techniques’, International Journal of Machine Learning and Computing, 11(4), pp. 286–290. doi: 10.18178/ijmlc.2021.11.4.1049.

King, M. (2022) 6 Key Differences Between Data Analysis and Reporting, 6 Key Differences Between Data Analysis and Reporting. Available at: https://databox.com/data-analysis-reporting (Accessed: 28 July 2022).

Luthi, B. and Karp, G. (2021) How to Apply for a Credit Card So You’ll Get Approved, NerdWallet. Available at: https://www.nerdwallet.

com/article/credit-cards/apply-for-a-credit-card (Accessed: 19 August 2022).

Maalouf, M. (2011) ‘Logistic regression in data analysis: An overview’, International Journal of Data Analysis Techniques and Strategies, 3(3), pp. 281–299. doi: 10.1504/IJDATS.2011.041335.

Mchugh, M. L. (2013) ‘The Chi-square test of independence Lessons in biostatistics’, Biochemia Medica, 23(2), pp. 143–9. Available at: http://dx.doi.org/10.11613/BM.2013.018.

McKinney, W. (2009) ‘pandas: a Foundational Python Library for Data Analysis and Statistics’, Python for high performance and scientific computing, 14(9), pp. 1–9. doi: 10.1002/mmce.20381.

Mehanović, D. and Durmić, N. (2022) ‘Case Study Application of Business Intelligence in Digital Advertising’, International Journal of E-Business Research. IGI Global, 18(1), pp. 1–16. doi: 10.4018/IJEBR.293294.

Nithya, N. and Kiruthika, R. (2021) ‘Impact of Business Intelligence Adoption on performance of banks: a conceptual framework’, Journal of Ambient Intelligence and Humanized Computing. Springer Berlin Heidelberg, 12(2), pp. 3139–3150. doi: 10.1007/s12652-020-02473-2.

Pandas (2022) pandas.crosstab — pandas 1.4.3 documentation, API reference. Available at: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.crosstab.html (Accessed: 27 August 2022).

Pérez-Martín, A., Pérez-Torregrosa, A. and Vaca, M. (2018) ‘Big Data techniques to measure credit banking risk in home equity loans’, Journal of Business Research. Elsevier, 89, pp. 448–454. doi: 10.1016/J.JBUSRES.2018.02.008.

Peussa, A. (2016) ‘Credit Risk Scorecard Estimation By Logistic Regression’, Faculty of Science Tekijä, Författare., (May), p. 33.

Rafi, K. A. and S.M.K, Q. (2012) ‘Business Intelligence : An Integrated Approach’, Business Intelligence Journal, 5(1), pp. 64–70.

Shift (2021) Credit Card Statistics - Shift Processing, Credit Card Statistics. Available at: https://shiftprocessing.com/credit-card/ (Accessed: 21 July 2022).

Siddiqi, N. (2012) Credit Risk Scorecards, Credit Risk Scorecards. doi: 10.1002/9781119201731.

Sphinx (2008) scipy.stats.chi2_contingency — SciPy v1.9.1 Manual, API reference. Available at: https://docs.scipy.org/doc/scipy/reference/generated/scipy.stats.chi2_contingency.html (Accessed: 27 August 2022).

Statsmodels (no date). Available at: https://pypi.org/project/statsmodels/ (Accessed: 15 August 2022).

Tabul8tor (2019) How do Credit Cards work?. Anyone who owns a credit or debit card, How do Credit Cards work? Available at: https://medium.com/@tabul8tor/how-do-credit-cards-work-a15596e14860 (Accessed: 21 July 2022).

Talend (no date) What is a Data Mart? (vs a Data Warehouse), Talend. Available at: https://www.talend.com/resources/what-is-data-mart/ (Accessed: 28 August 2022).

Ubiparipovi, B. and Durkovic, E. (2011) ‘Application of Business Intelligence in the Banking Industry’, Management Information Systems, 6, pp. 23–30. Available at: http://www.ef.uns.ac.rs/mis/archive-pdf/2011 - No4/MIS2011_4_4.pdf.

Uppal, J. Y. and Ullah Mangla, I. (2013) ‘Extreme loss risk in financial turbulence – evidence from the global financial crisis’, Managerial Finance. Emerald Group Publishing Ltd., 39(7), pp. 653–666. doi: 10.1108/03074351311323446/FULL/XML.

Watson, H. J. and Wixom, B. H. (2007) ‘The current state of business intelligence’, Computer, 40(9), pp. 96–99. doi: 10.1109/MC.2007.331.

Widow, J. (1992) ‘Research problems in data warehousing’, in Proceedings of the fourth international conference on Information and knowledge management, pp. 25–30.