Business Intelligence Implementation using Power BI for Decision Making in Peruvian Banking Systems
Business Intelligence Implementation using Power BI for Decision Making in Peruvian Banking Systems |
||
 |
 |
|
| © 2023 by IJETT Journal | ||
| Volume-71 Issue-4 |
||
| Year of Publication : 2023 | ||
| Author : Margarita Giraldo Retuerto, Brian Malaver Tuero, Laberiano Andrade-Arenas |
||
| DOI : 10.14445/22315381/IJETT-V71I4P209 | ||
How to Cite?
Margarita Giraldo Retuerto, Brian Malaver Tuero, Laberiano Andrade-Arenas, "Business Intelligence Implementation using Power BI for Decision Making in Peruvian Banking Systems," International Journal of Engineering Trends and Technology, vol. 71, no. 4, pp. 97-108, 2023. Crossref, https://doi.org/10.14445/22315381/IJETT-V71I4P209
Abstract
The research work focuses on decision-making based on banking systems. The database of the banking systems has a number of related tables due to the large bank movements and bank transactions. Therefore, the information analysis is complicated, so they can subsequently make decisions in all areas of the banking system. The objective of the research work is to implement business intelligence using Power BI for decision-making in Peruvian banking systems. In this way, it contributes to the banking organizations achieving a future vision and having full visibility for decision-making. The methodology applied is Kimball, which allowed the development and design of business intelligence using Power BI in banking systems at a given time. The result obtained is detailed reports for decision-making, with important data regarding the movements carried out, thus showing the place where the greatest collection in movements has been obtained. The fixed deposit account is the type of card that obtained the highest amount of movements in dollars and soles within the banking systems. Thanks to the implementation of business intelligence, banking systems will have better visibility for decision-making.
Keywords
Banking system, Business intelligence, Decision making, Kimball methodology, Power BI.
References
[1] Jamaiah Yahaya et al., “The Implementation of Business Intelligence and Analytics Integration for Organizational Performance Management: A Case Study in Public Sector,” International Journal of Advanced Computer Science and Applications, vol. 10, no. 11, pp. 292–299, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[2] Acheampong Owusu et al., “Determinants of Business Intel- Ligence Systems Adoption in Developing Countries: An Empirical Analysis from Ghanaian Banks,” The Journal of Internet Banking and Commerce, vol. 24, no. 2, pp. 1–25, 2017.
[Google Scholar] [Publisher Link]
[3] M. R. Romagnano, “The Role of Business Intelligence and Business Analytics in Today's Organizations,” Eletronica Argentina-Brazil Magazine of Communication Information Technologies, vol. 1, no. 13, 2021.
[CrossRef] [Google Scholar] [Publisher Link]
[4] Youssra Riahi, "Business Intelligence: A Strategy for Business Development," SSRG International Journal of Economics and Management Studies, vol. 4, no. 9, pp. 1-5, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[5] Saeed Rouhani et al., “Business Intelligence Systems Adoption Model: An Empirical Investigation,” Journal of Organizational and End User Computing, vol. 30, no. 2, pp. 43–70, 2018.
[Google Scholar] [Publisher Link]
[6] Dan Clark, “Introducing Power BI Desktop,” Beginning Power BI, pp. 193–216, 2017.
[CrossRef] [Google Scholar] [Publisher Link]
[7] Alexi Delgado, Fernando Rosas, and Chiara Carbajal, “System of Business Intelligence in a Health Organization Using the Kimball Methodology,” IEEE CHILEAN Conference on Electrical, Electronics Engineering, Information and Communication Technologies, CHILECON 2019, pp. 1– 5, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[8] Deden Prayitno Deden, “Application of Business Intelligence for Banking Performance Based on Products Analysis,” International Journal of Progressive Sciences and Technologies, vol. 6, no. 2, pp. 554–569, 2018.
[CrossRef] [Google Scholar] [Publisher Link]
[9] T.Aditya Kumar, G.Sravanthi, and Dr.D. Ratna Deepthi, "Competitive Advantage through Business Intelligence for E-Commerce," International Journal of Computer and organization Trends, vol. 3, no. 6, pp. 43-48, 2013.
[Google Scholar] [Publisher Link]
[10] Sonali Mathur, Shankar Lal Gupta, and Payal Pahwa, “Optimizing OLAP Cube for Supporting Business Intelligence and Forecasting in Banking Sector,” Journal of Information Technology Management, vol. 13, no. 1, pp. 81–99, 2021.
[CrossRef] [Google Scholar] [Publisher Link]
[11] N. Nithya, and R. Kiruthika, “Impact of Business Intelligence Adoption on Performance of Banks: A Conceptual Framework,” Journal of Ambient Intelligence and Humanized Computing, vol. 12, no. 2, pp. 3139-3150, 2020.
[CrossRef] [Google Scholar] [Publisher Link]
[12] Remigiusz Tunowski, “Sustainability of Commercial Banks Sup- ported by Business Intelligence System,” Sustainability, vol. 12, no. 11, p. 4754, 2020.
[CrossRef] [Google Scholar] [Publisher Link]
[13] Hamad Salem Al-Merri, “The Impact of Business Intelligence on Strategic Performance in Commercial Banks Operating in the Sate of Kuwait,” International Business Research, vol. 13, no. 8, 2020.
[CrossRef] [Google Scholar] [Publisher Link]
[14] Baljit Singh, "Enterprise Reporting on SAP S/4HANA using Snowflake as Cloud Datawarehouse," International Journal of Computer Trends and Technology, vol. 71, no. 1, pp. 28-39, 2023.
[CrossRef] [Google Scholar] [Publisher Link]
[15] D. Rojas, and L. Zamudio, “Implementation of Business Intelligence, Using the Ralph Kimball Methodology, in Decision Making in the Sales Area, Company SID SAC,” Autonomous University of Peru, p. 164, 2016.
[Google Scholar] [Publisher Link]
[16] A. A. Yulianto, and Y. Kasahara, “Data Warehouse System for Multidimensional Analysis of Tuition Fee Level in Higher Education Institutions in Indonesia,” International Journal of Advanced Computer Science and Applications, vol. 11, no. 6, 2020.
[CrossRef] [Google Scholar] [Publisher Link]
[17] Gustavo R. Rivadera, “Kimball's Methodology for the Design of Data Warehouses (Data Warehouses),” Engineering Notebooks, no. 5, pp. 56–71, 2020.
[Google Scholar] [Publisher Link]
[18] Victor M. Parra et al., “Pentaho and Jaspersoft: A Comparative Study of Business Intelligence Open Source Tools Processing Big Data to Evaluate Performances,” International Journal of Advanced Computer Science and Applications, vol. 7, no. 10, 2016.
[CrossRef] [Google Scholar] [Publisher Link]
[19] Dhamotharan Seenivasan, "ETL (Extract, Transform, Load) Best Practices," International Journal of Computer Trends and Technology, vol. 71, no. 1, pp. 40-44, 2023.
[CrossRef] [Google Scholar] [Publisher Link]
[20] Salma El Janati, Abdelilah Maach, and Driss El Ghanami, “Learning Analytics Framework for Adaptive E- Learning System to Monitor the Learner’s Activities,” International Journal of Advanced Computer Science and Applications, vol. 10, no. 8, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[21] Rakesh Kumar et al., “Quality Assurance for Data Analytics,” International Journal of Advanced Computer Science and Applications, vol. 9, no. 8, 2018.
[CrossRef] [Google Scholar] [Publisher Link]
[22] Nawfal El Moukhi et al., “Merge of X-ETL and XCube towards a Standard Hybrid Method for Designing Data Warehouses,” International Journal of Advanced Computer Science and Applications, vol. 10, no. 10, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[23] Jamaiah Yahaya et al., “The Implementation of Business Intelligence and Analytics Integration for Organizational Performance Management: A Case Study in Public Sector,” International Journal of Advanced Computer Science and Applications, vol. 10, no. 11, 2019.
[CrossRef] [Google Scholar] [Publisher Link]
[24] Alexi Delgado, Fernando Rosas, and Chiara Carbajal, “System of Business Intelligence in a Health Organization Using the Kimball Methodology,” 2019 IEEE CHILEAN Conference on Electrical, Electronics Engineering, Information and Communication Technologies (CHILECON), IEEE, pp. 1–5, 2019.
[CrossRef] [Google Scholar] [Publisher Link]