InsFocus BI - Infrastructure Features

InsFocus BI is based on a robust, feature-rich infrastructure, which ensures high performance and reliability for business intelligence.

Home » InsFocus BI Product » Infrastructure Features
Report library

Infrastructure Features

InsFocus BI's insurance data model design follows industry-proven dimension-modeling standards, and stores data at the lowest possible level of granularity. Concise policy information is detailed down to the coverage and risk parameter level. Claim information includes individual payments, historical reserve estimates and full tracking of claim status changes. The model is optimized for fast and flexible querying via InsFocus BI’s Query Engine. The insurance data warehouse’s design in not limited as is the case with traditional OLAP data models, and provides unrivaled query and analysis flexibility.


FEATURES INCLUDE:

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, thus enabling widespread system use across the organization while maintaining information accessibility control.
  • Role level permissions prevents users from performing actions they are not allowed to, enabling definitions of users that can not define new reports, can not print and export, etc.
  • Restriction based permissions control which items (measurements) and dimensions are available for each user group, enabling definitions such as claims-only user, sales-only user and so on.

Central system administration

Manage InsFocus BI's business intelligence software from anywhere using the System Center. This software module provides the tools for the company’s system administrator to perform administrative tasks, view system logs, change settings, define new users and edit query items and dimensions building blocks. All this is accomplished using a fast and simple interface.

Report scheduler

Any user with appropriate permissions 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
  • Schedule cab include reports saved in library or queries not even saved
  • Results are sent as a template-based, formatted, HTML mail
  • Results can also be sent via SMS directly to executive’s cell phones

Secure SOA with RESTful services

InsFocus BI is fully SOA based, exposing all system functionalities as secure HTTP Web services. The Web services follow the common REST (Representational State Transfer architecture) patterns, allowing easy discovery and use of services. This feature is extremely useful in connecting InsFocus to other applications in the organization.

Results can be returned as XML (used in all high-level languages), JSON (used in JavaScript) and HTML (for direct display).

Pre-aggregation mechanism

The system builds a set of aggregation tables at the end of each ETL session based on company specific definitions. These tables enable InsFocus to return the majority of queries in seconds, while retaining unlimited drill-down and reporting capabilities.

Data warehouse-centric ETL

InsFocus’ data integration module is written over Microsoft SSIS to handle the loading of InsFocus BI’s insurance data warehouse model from a large number of source systems. The module is designed to integrate data from different sources – relational databases such as SQL, Oracle or DB2, text (flat) files, Excel tables, XML files and online web sites.

The data integration processes provide solutions to common data warehousing issues such as slowly-changing dimensions, staging area maintenance, surrogate key generation, erroneous data handling, and process logging.

The module is completely table-driven, and can be fully customized with an insurance company’s data structures. Advanced support for incremental data loading enables the company to implement end-of-day loading with very short run times.