Qlik Case Studies Standard Life Gets ROI from QlikView in Just 10 Days

Edit This Case Study Record

	Standard Life Gets ROI from QlikView in Just 10 Days Qlik

Standard Life Gets ROI from QlikView in Just 10 Days

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
Challenge	Standard Life, a subsidiary of the Edinburgh-based Standard Life financial services group, was facing challenges in monitoring broker performance in near real time. The company was using Microsoft Excel spreadsheets with extracts from Microsoft SQL server data management software to prepare monitoring reports for distribution to management by email messaging. This process was laborious and time-consuming. Standard Life had two immediate priorities for any new business intelligence (BI) software. The first was for a persistency report showing which insurance policies have lapsed by broker for visibility by high ranking executives and actuaries. The second was to create a Management Information Pack with daily and monthly sales reports by broker for overview by senior management and sales managers. Read More
About Customer	Standard Life (Asia) Limited (“Standard Life”) in Hong Kong is a subsidiary of the Edinburgh-based Standard Life financial services group (“the Group”), which includes savings and investment businesses operating across global markets. In Hong Kong since 1999, Standard Life partners with financial advisors and other financial institutions to help customers accumulate wealth. The Group is listed on the London Stock Exchange and by the end of September 2011 had total assets under administration of £191 billion. Standard Life prides itself on customer information protection and service of world class standards. Because the company partners with financial advisors, performance analysis is crucial to the success of the business. Its core staff of 100 people in Hong Kong is relatively small, which puts a heavy reliance on third parties and performance monitoring. Read More
Solution	Standard Life deployed QlikView initially for a persistency report showing which insurance policies have been lapsed by brokers. The second application was a Management Information Pack analysing performance by broker. The breakthrough came in March 2011 from the expertise and specialist knowledge of the BI solution marketplace brought to Standard Life by QlikTech Hong Kong partner Velocity Business Solutions. Velocity organised a ‘Seeing is The breakthrough came in March 2011 from the expertise and specialist knowledge of the BI solution marketplace brought to Standard Life by QlikTech Hong Kong partner Velocity Business Solutions. Velocity offered Standard Life 10 days of consultancy work and created the first application for the broker persistency analysis in just six days. Subsequently, Standard Life started building a second application for five named users to provide a Management Information Pack. 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

Challenge

Standard Life, a subsidiary of the Edinburgh-based Standard Life financial services group, was facing challenges in monitoring broker performance in near real time. The company was using Microsoft Excel spreadsheets with extracts from Microsoft SQL server data management software to prepare monitoring reports for distribution to management by email messaging. This process was laborious and time-consuming. Standard Life had two immediate priorities for any new business intelligence (BI) software. The first was for a persistency report showing which insurance policies have lapsed by broker for visibility by high ranking executives and actuaries. The second was to create a Management Information Pack with daily and monthly sales reports by broker for overview by senior management and sales managers.

About Customer

Standard Life (Asia) Limited (“Standard Life”) in Hong Kong is a subsidiary of the Edinburgh-based Standard Life financial services group (“the Group”), which includes savings and investment businesses operating across global markets. In Hong Kong since 1999, Standard Life partners with financial advisors and other financial institutions to help customers accumulate wealth. The Group is listed on the London Stock Exchange and by the end of September 2011 had total assets under administration of £191 billion. Standard Life prides itself on customer information protection and service of world class standards. Because the company partners with financial advisors, performance analysis is crucial to the success of the business. Its core staff of 100 people in Hong Kong is relatively small, which puts a heavy reliance on third parties and performance monitoring.

Solution

Standard Life deployed QlikView initially for a persistency report showing which insurance policies have been lapsed by brokers. The second application was a Management Information Pack analysing performance by broker. The breakthrough came in March 2011 from the expertise and specialist knowledge of the BI solution marketplace brought to Standard Life by QlikTech Hong Kong partner Velocity Business Solutions. Velocity organised a ‘Seeing is The breakthrough came in March 2011 from the expertise and specialist knowledge of the BI solution marketplace brought to Standard Life by QlikTech Hong Kong partner Velocity Business Solutions. Velocity offered Standard Life 10 days of consultancy work and created the first application for the broker persistency analysis in just six days. Subsequently, Standard Life started building a second application for five named users to provide a Management Information Pack.

Impact #1	Two business critical applications in just 10 days
Impact #2	More productive customer meetings based on accurate data
Impact #3	Scalable for extension throughout the company

Impact #1

Two business critical applications in just 10 days

Impact #2

More productive customer meetings based on accurate data

Impact #3

Scalable for extension throughout the company

Benefit #1	Return on initial investment in three months

Benefit #1

Return on initial investment in three months

Download PDF Version

Overview

Standard Life Gets ROI from QlikView in Just 10 Days

Operational Impact

Quantitative Benefit