下载PDF
Qlik > 实例探究 > Berenberg Bank Uses QlikView for Transparent Customer Relations
Qlik Logo

Berenberg Bank Uses QlikView for Transparent Customer Relations

技术
  • 分析与建模 - 实时分析
适用行业
  • 金融与保险
适用功能
  • 销售与市场营销
  • 商业运营
用例
  • 质量预测分析
服务
  • 数据科学服务
  • 系统集成
挑战
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.
关于客户
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?'
解决方案
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.
运营影响
  • 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.
  • 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.
数量效益
  • About 30 staff use QlikView for various analyses and reports with around 100,000 data records imported daily.
  • At each month end, data is available the next day and not, as used to be the case, two or three weeks later.

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

Thank you for your message!
We will contact you soon.