Business Intelligence Implementation using Power BI for Decision Making in Peruvian Banking Systems

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.