A large international insurer needed to update their mortality and lapse study process. Their current process did not cover all their business and a system conversion threatened the studies that were currently available.
Insight Enterprise handles mortality, lapse and any other exit reason as a single process; deaths and lapses are simply exits with different exit reason. Insight’s ETL (Extraction Transformation and Loading) process consolidated data from multiple distinct sources, including legacy systems, resulting in a uniform view of data.
In addition to the benefits that were derived from the cleansed data, the company discovered that the supporting analytics, in particular Policy Movement, provided reports they had attempted to produce from an earlier data warehouse project. The prior project had failed due to the unanticipated complexity of changes over time, this is not an issue for Insight Enterprise due to our unique temporal data model.