Business Intelligence for Insurance

Latest Tweets

Follow us on Twitter (offsite)

Insight Case Studies

These case studies are drawn from our 10+ years in business. We have organized these in chronological order with most recent example first and tags identifying major functions.

Please contact us if you require further examples or more details.


Multi-sponsor Experience Study

Insight Experience was used for the Society of Actuaries Retirement Plan Education Committee mortality study. Data had been provided to the SOA by six of the the largest pension plans.

The project had originally been attempted by an external researcher, who had been overwhelmed by the volume of the data and different formats that had been provided. This presented no challenge to Insight's ETL (Extraction Transformation and Loading) processes and the data loaded into the Insight Experience system for dynamic analysis.


Disability Insurance

A health insurance company specializing in disability insurance implemented Insight Enterprise to improve their overall reporting and analysis of their disability business.

Critical functionality included incidence and termination studies, claim movement and interest adjusted loss ratios. The system brought together data from two major administration systems originating from two seperately managed companies, two legacy systems, a new claim system and data from legacy claim systems that had been converted to a new system where closed claims had not beed converted.

To meet the experience study needs of the business 15 years of historical data was loaded into the system from the outset.

Insight Enterprise is also used to select model points for dynamic testing and sales award recognition. 


Source of Earnings

A large Canadian insurer needed to implement earnings by source rapidly. Having read 'The Analysis of Insurance Earnings' by John McGarry and Kevin Pledge, and seen presentation on the topic, they turned to Insight for the solution.

Insight Enterprise was implemented in a few months to contribute to the financial reporting requirements that year for individual life business. The scope of the project was later extended to include the Investment and Group Business divisions that had previously been operating on an IBM data warehouse solution. The conversion of these divisions to Insight Enterprise allowed the company to carry out a full range of actuarial analysis across all product lines, as well as provide comprehensive management information.