Customer Company Size
Large Corporate
Region
- America
Country
- United States
Product
- QlikView
Tech Stack
- SQL Server
- DB2
- Teradata
- Access
- Excel spreadsheets
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Customer Satisfaction
- Productivity Improvements
Technology Category
- Analytics & Modeling - Big Data Analytics
- Analytics & Modeling - Real Time Analytics
Applicable Functions
- Business Operation
- Sales & Marketing
Use Cases
- Predictive Maintenance
- Supply Chain Visibility
Services
- Data Science Services
About The Customer
Colonial Life, an affiliate of Unum Group, is a market leader in providing benefits solutions in one neat package: excellence in communications, enrollments, service, and personal insurance products and services that make benefits count for employers and their employees alike. For employees whose insurance plans leave them feeling vulnerable, Colonial Life can help restore peace of mind through personal insurance products that complete their coverage. Headquartered in Columbia, S.C., and founded in 1939, Colonial Life offers a broad line of personal insurance products including disability, accident, life, cancer, critical illness, hospital confinement and limited benefit medical coverage.
The Challenge
In 2005, Colonial Life's Business Intelligence and IT groups decided to provide improved analytic and reporting capabilities to its user community. However, it was imperative for user acceptance of any solution that it be as easy to use as possible at all skill levels. In addition, high transaction volumes among the company’s 60,000+ customer accounts meant that the chosen solution needed to aggregate information quickly and completely to facilitate decision-making. A visit to a data warehousing conference brought QlikView to the attention of Bryan Allen, the company’s Assistant Vice President of Business Intelligence. After an evaluation process put six tools through their paces, the Colonial Life team ultimately selected QlikView based on their capabilities, ease of use, and performance.
The Solution
Since the selection of QlikView, nearly 100 QlikView applications have been deployed across the company, with 400 internal users able to quickly analyze data volumes up to 50 million lines. Colonial Life offers customers state-of-the-art, flexible enrollment capabilities. The company’s web-based Harmony enrollment system allows not only enrollment, but field-based configuration and setup for each case. This system supports Colonial Life’s 7,800+ agents and brokers. Harmony quickly became a differentiator for Colonial Life, with field agents able to present products to customers and enroll them from the same application. However, a solution needed to be developed to support Harmony reporting to provide sales, marketing and finance teams with a comprehensive analysis of the data across product offerings, geographies and other key indicators. Harmony reporting using QlikView quickly filled the gap.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Remote Monitoring & Predictive Maintenance App for a Solar Energy System
The maintenance & tracking of various modules was an overhead for the customer due to the huge labor costs involved. Being an advanced solar solutions provider, they wanted to ensure early detection of issues and provide the best-in-class customer experience. Hence they wanted to automate the whole process.
Case Study
Remote Temperature Monitoring of Perishable Goods Saves Money
RMONI was facing temperature monitoring challenges in a cold chain business. A cold chain must be established and maintained to ensure goods have been properly refrigerated during every step of the process, making temperature monitoring a critical business function. Manual registration practice can be very costly, labor intensive and prone to mistakes.
Case Study
Predictive Maintenance for Industrial Chillers
For global leaders in the industrial chiller manufacturing, reliability of the entire production process is of the utmost importance. Chillers are refrigeration systems that produce ice water to provide cooling for a process or industrial application. One of those leaders sought a way to respond to asset performance issues, even before they occur. The intelligence to guarantee maximum reliability of cooling devices is embedded (pre-alarming). A pre-alarming phase means that the cooling device still works, but symptoms may appear, telling manufacturers that a failure is likely to occur in the near future. Chillers who are not internet connected at that moment, provide little insight in this pre-alarming phase.
Case Study
Aircraft Predictive Maintenance and Workflow Optimization
First, aircraft manufacturer have trouble monitoring the health of aircraft systems with health prognostics and deliver predictive maintenance insights. Second, aircraft manufacturer wants a solution that can provide an in-context advisory and align job assignments to match technician experience and expertise.
Case Study
Integral Plant Maintenance
Mercedes-Benz and his partner GAZ chose Siemens to be its maintenance partner at a new engine plant in Yaroslavl, Russia. The new plant offers a capacity to manufacture diesel engines for the Russian market, for locally produced Sprinter Classic. In addition to engines for the local market, the Yaroslavl plant will also produce spare parts. Mercedes-Benz Russia and his partner needed a service partner in order to ensure the operation of these lines in a maintenance partnership arrangement. The challenges included coordinating the entire maintenance management operation, in particular inspections, corrective and predictive maintenance activities, and the optimizing spare parts management. Siemens developed a customized maintenance solution that includes all electronic and mechanical maintenance activities (Integral Plant Maintenance).
Case Study
Asset Management and Predictive Maintenance
The customer prides itself on excellent engineering and customer centric philosophy, allowing its customer’s minds to be at ease and not worry about machine failure. They can easily deliver the excellent maintenance services to their customers, but there are some processes that can be automated to deliver less downtime for the customer and more efficient maintenance schedules.