Application of Business Intelligence in Decision Making for Credit Card Approval
DOI:
https://doi.org/10.37380/jisib.v12i2.956Keywords:
Business Intelligence, Chi-Square Test, Credit Card, Data Analysis, Linear RegressionAbstract
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.
Downloads
Published
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
