Qlik Case Studies Berenberg Bank Uses QlikView for Transparent Customer Relations

Edit This Case Study Record

	Berenberg Bank Uses QlikView for Transparent Customer Relations Qlik

Berenberg Bank Uses QlikView for Transparent Customer Relations

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Finance & Insurance
Applicable Functions	Sales & Marketing Business Operation
Use Cases	Predictive Quality Analytics
Services	Data Science Services System Integration
Challenge	Berenberg Bank, a Swiss bank specializing in investment advice and asset management, was seeking to improve its customer relations management. The bank wanted to provide its staff with a toolset that would optimize their consultancy services through classic ABC customer analyses and individual reviews of customer data. The bank's management wanted an improved overview of the entire customer situation, including the composition of the customer portfolio, the number of new customers won, and the income produced with various products in different market segments. The bank also wanted each consultant to be able to access the appropriate figures for the profit margin account to monitor yields and losses on the portfolio. The data required for these analyses came from various sources, and the only way to analyze this data was via a laborious, error-prone, and rather protracted journey with Excel spreadsheet software. Read More
About Customer	Berenberg Bank is a Swiss bank that specializes in investment advice and asset management. The bank is part of the long tradition of private banking in Switzerland, with around 35% of private and institutional assets managed in banks operating in this sector. One of the bank's guiding themes is to combine tradition with innovation in all aspects of customer relations. The bank is committed to this principle, as evidenced by its introduction of a Business Intelligence (BI) system. The bank's investment consultants need answers to questions such as 'What investment ideas and what conditions can I offer the customer?' and 'Which new customers have been attracted to the bank recently and which have left it?' Read More
Solution	Berenberg Bank decided to integrate all the data into a shared data model, which would make it possible to access a convenient BI solution as a front-end application. The bank designed its own data warehouse into which financial data from TCS BaNCS, Access, and Excel are transferred via special interfaces. The bank chose QlikView as the appropriate and convenient software to assess and present data. QlikView was chosen for its high level of flexibility in terms of use and price structure. The bank found the ideal consultant in iNFORMATEC, an IT provider with extensive BI expertise and considerable experience in the banking and financial services. iNFORMATEC only needed about three days to implement the infrastructure, set up the client programs, and install Set-Up with the first templates. The IT provider later installed an access control which, for reasons of security, restricted access to the entire database to certain authorized users. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Finance & Insurance

Applicable Functions

Sales & Marketing

Business Operation

Use Cases

Predictive Quality Analytics

Services

Data Science Services

System Integration

Challenge

Berenberg Bank, a Swiss bank specializing in investment advice and asset management, was seeking to improve its customer relations management. The bank wanted to provide its staff with a toolset that would optimize their consultancy services through classic ABC customer analyses and individual reviews of customer data. The bank's management wanted an improved overview of the entire customer situation, including the composition of the customer portfolio, the number of new customers won, and the income produced with various products in different market segments. The bank also wanted each consultant to be able to access the appropriate figures for the profit margin account to monitor yields and losses on the portfolio. The data required for these analyses came from various sources, and the only way to analyze this data was via a laborious, error-prone, and rather protracted journey with Excel spreadsheet software.

About Customer

Berenberg Bank is a Swiss bank that specializes in investment advice and asset management. The bank is part of the long tradition of private banking in Switzerland, with around 35% of private and institutional assets managed in banks operating in this sector. One of the bank's guiding themes is to combine tradition with innovation in all aspects of customer relations. The bank is committed to this principle, as evidenced by its introduction of a Business Intelligence (BI) system. The bank's investment consultants need answers to questions such as 'What investment ideas and what conditions can I offer the customer?' and 'Which new customers have been attracted to the bank recently and which have left it?'

Solution

Berenberg Bank decided to integrate all the data into a shared data model, which would make it possible to access a convenient BI solution as a front-end application. The bank designed its own data warehouse into which financial data from TCS BaNCS, Access, and Excel are transferred via special interfaces. The bank chose QlikView as the appropriate and convenient software to assess and present data. QlikView was chosen for its high level of flexibility in terms of use and price structure. The bank found the ideal consultant in iNFORMATEC, an IT provider with extensive BI expertise and considerable experience in the banking and financial services. iNFORMATEC only needed about three days to implement the infrastructure, set up the client programs, and install Set-Up with the first templates. The IT provider later installed an access control which, for reasons of security, restricted access to the entire database to certain authorized users.

Impact #1	QlikView has proved invaluable as a management tool. The bank can now quickly see which, and in what way, consultants have developed. It can pinpoint where there are differences in the profitability of customer relations, which recommendations the various consultants are giving their customers, and to what extent these are being used.
Impact #2	The range of QlikView applications will grow in future at Berenberg Bank in Switzerland. These will include risk management and credit business scheduling and reporting.

Impact #1

QlikView has proved invaluable as a management tool. The bank can now quickly see which, and in what way, consultants have developed. It can pinpoint where there are differences in the profitability of customer relations, which recommendations the various consultants are giving their customers, and to what extent these are being used.

Impact #2

The range of QlikView applications will grow in future at Berenberg Bank in Switzerland. These will include risk management and credit business scheduling and reporting.

Benefit #1	About 30 staff use QlikView for various analyses and reports with around 100,000 data records imported daily.
Benefit #2	At each month end, data is available the next day and not, as used to be the case, two or three weeks later.

Benefit #1

About 30 staff use QlikView for various analyses and reports with around 100,000 data records imported daily.

Benefit #2

At each month end, data is available the next day and not, as used to be the case, two or three weeks later.

Download PDF Version

Overview

Berenberg Bank Uses QlikView for Transparent Customer Relations

Operational Impact

Quantitative Benefit