Unified solution for reports and dashboards

Built on the latest technologies for Web applications – HTML5, CSS3, and ASP.NET MVC, InsFocus’ user interface is a unified single point of contact between the user and the system for report creation, analysis and dashboards.

Optimized insurance data model

The InsFocus DW model is an optimized star-schema dimensional model, adapted specifically for insurance companies’ data. The system’s data model is seamlessly designed for performance optimization and stores granular policy, coverage, claim and claimant details, enabling flexible drill-down functionality and line reporting. The data model contains:

  • 400 Insurance KPI’S
  • 200 Report Templates
  • 60 Integration Scripts
  • 40 Calculation Templates

True self service solution

Defining new reports requires only a few simple steps, which business users can learn in a very short period. Users can define ad-hoc queries independently without the need to engage the company’s IT department. Additionally library reports can be used as a basis for creating and saving their personal versions.

Dynamic insurance calculations

InsFocus embeds open SQL calculation templates that perform insurance calculations (such as unearned premiums) at run-time. These templates can be customized and new calculation templates can be defined to perform complex calculations at runtime. Out of the box templates handle exposure calculations, unearned premiums, renewal analysis, outstanding claims, and many more.

Unlimited drill-down and drill-through

Unlike systems with rigid drill-down hierarchy, InsFocus BI enables drill-down (row/column) and drill-through (cell) to any defined dimension, organizational member or time period, as far down as the client, policy or individual claim level. This helps users understand the facts underlying any displayed result.

Unlimited risk parameters

InsFocus provides a unique risk parameter mechanism that combines the different insurance products’ specific attributes into a single uniform data model. Examples of such risk parameters are model, manufacturing year and driver age in motor insurance, profession and age in professional indemnity, etc. Built on a customizable mechanism, it allows defining an unlimited number of parameters for every dimension.

Time bases

Insurance time dependencies are built into the system’s data model and calculation methods, offering analysis capabilities from different time perspectives and meeting the information needs of business users. Time bases include operational, financial, underwriting, accident and snapshot options, altering the way measurements are calculated and providing full analysis of time base interdependencies.

Triangulation and extrapolation

A built-in triangulation statistics mechanism provides the ability to compare measurements on any time base to any dependent time base (e.g. claim payments by financial year can be compared to accident year). Using a built-in Chain-Ladder extrapolation mechanism, the company’s actuaries can estimate the IBNR reserves required for a particular line of business.

Report scheduler

Users can schedule BI reports that run automatically at predefined schedules and are dispatched in a number of ways.

  • Reports can be scheduled to run daily, weekly or monthly.
  • Results can sent as a formatted HTML, PDF or Excel.
  • Results can also be sent via SMS directly to executive’s cell phones.

Data-level, role-level and restriction-based permissions

InsFocus BI contains enterprise security measures that control users’ functionality and access to business intelligence data on three levels:

  • Data level permissions allow users to view only data defined in their organizational domain.
  • Role level permissions prevents users from performing actions they are not allowed to carry.
  • Restriction based permissions control which items (measurements) and dimensions are available for each user group.