Optimizing OLAP Cube for Supporting Business Intelligence and Forecasting in Banking Sector

The data stored in data warehouse is used for making strategic decisions by integrating heterogeneous data from multiple sources at a single storage place, where data is used for querying and analysis purposes. With the advancement in the technology, Business Analytics and Business intelligence are being increasingly used in the financial sector for forecasting business decisions. Many On-Line Analytical Processing (OLAP) tools are being largely explored that can contribute to business decision making. Banking operation handles a lot of data as they operate daily. Subsequently, preparing of this tremendous volume of information requires instant and quick tools that can process the information at high processing speeds. Through this research paper, we represent the OLAP cube as one of the tools which can be used for business analysis. A case study of a bank and loan approval process is considered as one of the areas for implementation and analysis of business decisions using business intelligence which can serve as a key factor for increasing intelligence in the banking sector to make reliable business decisions. Higher management can forecast and predict various outcomes from the bank data warehouse using On-Line Analytical Processing technology which provided a multidimensional view of the data. Analysts can make business decisions by analyzing the reports and pattern trends in the graphs. Management can modify existing policies and procedures to increase the growth of the bank and can have a healthy competition with their competitors.

[1]  Radu Prodan,et al.  Automated bank cheque verification using image processing and deep learning methods , 2020, Multimedia Tools and Applications.

[2]  G F Akhmedyanova,et al.  Algorithms for synthesizing management solutions based on OLAP-technologies , 2018 .

[3]  Alex Berson,et al.  Data Warehousing, Data Mining, and OLAP , 1997 .

[4]  P. Agrawal,et al.  Visualizing Clouds on Different Stages of DWH - An Introduction to Data Warehouse as a Service , 2012, 2012 International Conference on Computing Sciences.

[5]  Hussein A. Abdou,et al.  Credit Scoring, Statistical Techniques and Evaluation Criteria: A Review of the Literature , 2011, Intell. Syst. Account. Finance Manag..

[6]  Abba Suganda Girsang,et al.  Analysis Students' Graduation Eligibility Using Data Warehouse , 2018, 2018 International Conference on Information Management and Technology (ICIMTech).

[7]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[8]  Kusrini Kusrini,et al.  On-Line Analytic Processing (OLAP) modeling for graduation data presentation , 2017, 2017 2nd International conferences on Information Technology, Information Systems and Electrical Engineering (ICITISEE).

[9]  William R. Keeton,et al.  Why do banks' loan losses differ? , 1987 .

[10]  Prateek Agrawal,et al.  Bank Cheque Validation Using Image Processing , 2019 .

[11]  Anindya Datta,et al.  A Conceptual Model and Algebra for On-Line Analytical Processing in Decision Support Databases , 2001, Inf. Syst. Res..

[12]  Seema Purohit,et al.  Credit evaluation model of loan proposals for Indian Banks , 2011, 2011 World Congress on Information and Communication Technologies.

[13]  Alexandr Konikov,et al.  Research of the possibilities of application of the Data Warehouse in the construction area , 2018 .

[14]  Arpita Mathur,et al.  Design of OLAP Cube for Banking System of India , 2016 .

[15]  Thomas Neumuth,et al.  OLAP Technology for Business Process Intelligence: Challenges and Solutions , 2007, DaWaK.

[16]  Hamid Pirahesh,et al.  Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals , 1996, Data Mining and Knowledge Discovery.

[17]  Vikram Bali,et al.  Storage and Retrieval of Software Component using Hadoop and MapReduce , 2017 .

[18]  Torben Bach Pedersen,et al.  Contextualizing data warehouses with documents , 2008, Decis. Support Syst..

[19]  Gopal K Gupta,et al.  Introduction to Data Mining with Case Studies , 2011 .

[20]  Torben Bach Pedersen,et al.  Multidimensional Database Technology , 2001, Computer.

[21]  James A. Senn.  Information Technology in Business: Principles, Practices, and Opportunities , 1994 .

[22]  Harsh Dev,et al.  Design of Data Cubes and Mining for Online Banking System , 2011 .

[23]  Helen Hasan,et al.  Using OLAP and multidimensional data for decision making , 2001 .

[24]  Stephen R. Gardner.  Building the data warehouse , 1998, CACM.