• +91- 9640901313
    casehelpdesk@ibsindia.org

Microsoft SQL Server Based OLAP Technology at Raiffeisen Bank International

Microsoft SQL Server Based OLAP Technology at Raiffeisen Bank International
Case Code: CLIT010
Case Length: 5 Pages
Period: 2012
Pub Date: 2020
Teaching Note: Available
Price: Rs.200
Organization: Raiffeisen Bank International AG
Industry: Banking
Countries: Austria
Themes: Business Intelligence Systems, Business Analytics, Data Warehouse, IT Infrastructure
Microsoft SQL Server Based OLAP Technology at Raiffeisen Bank International

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.

Issues

  • Use of OLAP for Business Intelligence and analytics
  • Understand the reporting benefits achieved by implementing OLAP


Introduction

Raiffeisen Bank International AG (RBI), an Austrian Bank headquartered in Vienna, was one of the most preferred banks in Austria as well as in Central and Eastern Europe and Asia.

The bank dealt with a humongous amount of data pertaining to its customers. This data was also frequently used to create reports for analysis and evaluation of business. The bank was therefore using the business analytics tool Online Analytical Processing (OLAP) (Exhibit I) for its reporting and analysis purposes. It was using OLAP with IBM Cognos.

By 2019, the company had 46,873 employees and offered its services to close to 16.7 million customers through 2000 business outlets.

Over a period of time, an increase in the number of customers also led to an increase in the data and also to the bank’s business requirements, which called for more refined analytical reports. The bank wanted a sophisticated and powerful Business Intelligence (BI) tool while at the same time wanting to keep its costs low. So it decided to use the Microsoft OLAP tool which would expand the existing reporting and analysis instead of completely replacing the existing system of business intelligence analysis.

Keywords

Business Intelligence; OLAP; Reporting; Data Processing;Raiffeisen Bank; Analysis of business; evaluation of business; Online Analytical Processing; Business Intelligence tool

Buy this case study (Please select any one of the payment options)

Price: Rs.200
Price: Rs.200
PayPal (4 USD)

Custom Search