Data Warehouse

The objective of this study is to verify the importance of the capabilities of cloud computing services in managing and analyzing big data in business organizations because the rapid development in the use of information technology in general and network technology in particular, has led to the trend of many organizations to make their applications available for use via electronic platforms hosted by various Companies on their servers or so-called cloud computing that have become an excellent opportunity to provide services efficiently and at low cost, but managing big data presents a definite challenge in the cloud space beginning with the processes of extracting, processing data, storing data and analyze it. Through this study, we dealt with the concept of cloud computing and its capabilities in business organizations. We also interpreted the notion of big data and its distinct characteristics and sources. Finally, the relationship between cloud computing with big data was also explained (extraction, storage, analysis).

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.