Glean

Here you can find information on the following topics:

What is Glean?

Glean is an experience analysis and data mining system which has been developed by SunGard. It provides sophisticated facilities for life companies to analyse their lapse, mortality and other experience and for general insurance companies to analyse their claims, conversion, retention and other experience. It enables actual rates to be analysed using traditional actuarial techniques, including comparisons with expected rates, but within a modern, easy to use application. However, it goes beyond this by also providing leading edge statistical modelling techniques that are widely used by general insurance actuaries when pricing motor and household business.

Glean is closely integrated into the highly successful Prophet financial modelling suite. It is therefore easily able to read the tables used in Prophet in order to calculate expected rates. It also includes Prophet's Data Conversion System for the manipulation of data, including the calculation of the exposure information.

back to top

Types of Analyses

Three different types of analysis can be carried out:

• Calculation of actual rates and averages - an intuitive "drill down" data analysis tool is provided. This uses data cubing techniques and charts to enable you to investigate the effect of any of the factors that may affect the experience, such as product type, age, policy year and distribution channel.
• Actual versus expected ratios - complete models of your expected rates/experience can be set up using tables of external data. These can then be compared with the actual rates/experience using the same powerful data analysis tool.
• Generalised Linear Modelling (GLM) - allows you to analyse your experience using sophisticated statistical techniques to determine the most significant factors affecting your experience.

Glean Excel Reporting is a Microsoft Excel™ add-in that you can use to create:

• Data Cube Reports
• GLM Model Reports

Glean Excel Reporting provides commands and functions that enable values from Glean results files to be included in reports. It also provides Microsoft Excel™ example templates.

back to top

Applications of Glean

Glean has applications in the life insurance, general insurance and other markets. For more information, choose one of the following:

Life Insurance

General Insurance

back to top

Who to contact?

Further details of Glean are available on request. For more information on Glean, or to arrange a demonstration of Glean, please contact your local SunGard account manager.

Other products:     Prophet Enterprise     |     Prophet Professional