Microsoft SQL Server Based OLAP Technology at Raiffeisen Bank International
Details
CLIT010
5
2012
YES
300
Raiffeisen Bank International AG
Banking
Austria
Business Intelligence Systems,Business Analytics; Data Warehouse; IT Infrastructure
Abstract
Raiffeisen Bank International AG (RBI), an Austrian Bank, headquartered in Vienna was one of the most preferred banks in the Austria as well as Central and Eastern Europe and Asia. The bank was dealing with humongous amount of data of its customers. Frequently this data was also used to create reports for analysis and evaluation of business. The bank was therefore using business analytics tool – Online Analytical Processing (OLAP) for its reporting and analysis purpose. The bank was using OLAP with IBM Cognos. Over a period of time, increase in number of customers also increased the data. And so did their business requirements which called for more refined analytical reports. The bank wanted a sophisticated and powerful Business Intelligence (BI) tool but at the same time wanted to keep its costs low. So the bank decided to use Microsoft OLAP tool which would expand the existing reporting and analysis instead of completely replacing the existing system of business intelligence analysis. Microsoft OLAP tool proved quite beneficial to the company. The reporting and analysis became precise as all unwanted data was filtered in early stages of analysis. Removal of unwanted data also made reporting process more flexible as employees were now able to select the data required for their reports instead of getting the entire database to go through.
Learning Objectives
The case is structured to achieve the following Learning Objectives:
- Use of OLAP for Business Intelligence and analytics
- Understand the reporting benefits achieved by implementing OLAP
Keywords
Business Intelligence; OLAP; Reporting; Data Processing; Raiffeisen Bank; Analysis of business; evaluation of business; Online Analytical Processing; Business Intelligence tool