Qlik Case Studies MassMutual Asia Expedites Decision Making and Strengthens Competitiveness

Edit This Case Study Record

	MassMutual Asia Expedites Decision Making and Strengthens Competitiveness Qlik

MassMutual Asia Expedites Decision Making and Strengthens Competitiveness

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Finance & Insurance
Applicable Functions	Sales & Marketing
Use Cases	Predictive Quality Analytics Real-Time Location System (RTLS)
Services	Data Science Services
Challenge	MassMutual Asia was facing challenges with their previous Business Intelligence Systems (BIS). The systems were inflexible, had poor performance, and were unable to meet users’ requirements or provide on-time reports. This was affecting the efficiency of decision making and the competitiveness of their products and services. The company had tried to switch to another traditional BIS, but this also presented problems. The development tools lacked flexibility, many user requirements could not be fulfilled, and developers had to do extra programming and settings because of its architecture. The system also utilized tremendous resources and required many servers to run effectively, making maintenance costs high and increasing overall IT expenditure. Read More
About Customer	MassMutual Asia Ltd is a member of the MassMutual Financial Group, one of the largest global financial-services organizations. With headquarters located in Massachusetts, USA, its global operations network covers the United States, South America, Europe, and Asia, catering to the financial and insurance needs of 13 million individual and corporate customers. MassMutual has nearly 160 years of experience in risk- and wealth-management services and is ranked in the renowned FORTUNE 500 as one of the “Five Largest US Life Insurance Companies”. Assets under its management exceed US$420 billion. As the group’s flagship company for the development of risk and wealth-management businesses in the Asian region, MassMutual Asia is headquartered in Hong Kong, with a branch office in Macau. MassMutual Asia has over 2,000 consultants dedicated to providing customers with professional, one-stop risk and wealth-management services. In 2009, MassMutual Asia’s total premium income in Hong Kong and Macau was HK$3.3 billion. Read More
Solution	To provide BI reports on time to users within the company and reinforce its competitiveness in the insurance industry, MassMutual Asia Ltd adopted QlikView. This system monitors the number of front-line consultants, enhances their quality, increases product competitiveness, and analyzes the effectiveness of their promotions. QlikView's architecture is simpler, it can read directly from Oracle and SQL databases and transform the data to QlikView to compile the reports required by users. It is not necessary to extract it to a separate predefined database as in the case of other BIS, so it is nine times faster. With QlikView, users can read all reports on time at 9 a.m. every day. It completely solves the drill-down performance issue and users can instantly get access to useful business intelligence on which to base their decisions. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Finance & Insurance

Applicable Functions

Sales & Marketing

Use Cases

Predictive Quality Analytics

Real-Time Location System (RTLS)

Services

Data Science Services

Challenge

MassMutual Asia was facing challenges with their previous Business Intelligence Systems (BIS). The systems were inflexible, had poor performance, and were unable to meet users’ requirements or provide on-time reports. This was affecting the efficiency of decision making and the competitiveness of their products and services. The company had tried to switch to another traditional BIS, but this also presented problems. The development tools lacked flexibility, many user requirements could not be fulfilled, and developers had to do extra programming and settings because of its architecture. The system also utilized tremendous resources and required many servers to run effectively, making maintenance costs high and increasing overall IT expenditure.

About Customer

MassMutual Asia Ltd is a member of the MassMutual Financial Group, one of the largest global financial-services organizations. With headquarters located in Massachusetts, USA, its global operations network covers the United States, South America, Europe, and Asia, catering to the financial and insurance needs of 13 million individual and corporate customers. MassMutual has nearly 160 years of experience in risk- and wealth-management services and is ranked in the renowned FORTUNE 500 as one of the “Five Largest US Life Insurance Companies”. Assets under its management exceed US$420 billion. As the group’s flagship company for the development of risk and wealth-management businesses in the Asian region, MassMutual Asia is headquartered in Hong Kong, with a branch office in Macau. MassMutual Asia has over 2,000 consultants dedicated to providing customers with professional, one-stop risk and wealth-management services. In 2009, MassMutual Asia’s total premium income in Hong Kong and Macau was HK$3.3 billion.

Solution

To provide BI reports on time to users within the company and reinforce its competitiveness in the insurance industry, MassMutual Asia Ltd adopted QlikView. This system monitors the number of front-line consultants, enhances their quality, increases product competitiveness, and analyzes the effectiveness of their promotions. QlikView's architecture is simpler, it can read directly from Oracle and SQL databases and transform the data to QlikView to compile the reports required by users. It is not necessary to extract it to a separate predefined database as in the case of other BIS, so it is nine times faster. With QlikView, users can read all reports on time at 9 a.m. every day. It completely solves the drill-down performance issue and users can instantly get access to useful business intelligence on which to base their decisions.

Impact #1	Implementation required only 6 months to carry out. This was 4 to 6 times faster than previous systems which took 2 to 3 years.
Impact #2	ETL shortened from 3 hours down to 20 minutes (9 times faster).
Impact #3	All BI reports could be produced before 9 a.m. every day and be provided to all department users.

Impact #1

Implementation required only 6 months to carry out. This was 4 to 6 times faster than previous systems which took 2 to 3 years.

Impact #2

ETL shortened from 3 hours down to 20 minutes (9 times faster).

Impact #3

All BI reports could be produced before 9 a.m. every day and be provided to all department users.

Benefit #1	Implementation time reduced by 4 to 6 times.
Benefit #2	ETL process is 9 times faster.
Benefit #3	50% savings on development and maintenance time.

Benefit #1

Implementation time reduced by 4 to 6 times.

Benefit #2

ETL process is 9 times faster.

Benefit #3

50% savings on development and maintenance time.

Download PDF Version

Overview

MassMutual Asia Expedites Decision Making and Strengthens Competitiveness

Operational Impact

Quantitative Benefit