The 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.
Insurance business domains
InsFocus BI's insurance data model covers all insurance business domains, as is covered in the insurance content page. Those domains include:
* Marketing
* Underwriting
* Claims
* Reinsurance
* Actuarial
* Accounting
Policy / section / claim granularity
Freed from the limits of traditional OLAP solutions, InsFocus BI's insurance data warehouse model details data to the lowest insurance granular level, including:
* Policy data
* Policy transactions (changes)
* Policy sections (coverages)
* Risk codes (specific values per product)
* Claims data
* Claim payments
* Claim outstanding estimate changes
* Collection data
* Client data
Optimized for insurance queries
InsFocus BI's data model was built for insurance from the ground up, and therefore is highly optimized for fast and flexible insurance-specific queries. A lot of work and effort has been put into each calculation method, index, fact table and other data structures, in order to speed up and facilitate typical insurance queries, such as:
* Earned and unearned calculations
* Issued, latest, exposed, in-force sums-insured
* For renewal and lapses
* Outstanding claim estimates
* Reinsurance cessions and margins
* Claim status filters (e.g. run-off)
Follows industry standards
InsFocus BI's data model is a star-schema dimensional model, closely following the Kimball approach for data warehousing. The data model has been developed for years following practices by Mark Kimball, TDWI, Microsoft and others, to achieve a highly efficient yet standards-compliant insurance data warehouse.
SOURCE:http://www.insfocus.com/product/insurance-data-model.html
Insurance business domains
InsFocus BI's insurance data model covers all insurance business domains, as is covered in the insurance content page. Those domains include:
* Marketing
* Underwriting
* Claims
* Reinsurance
* Actuarial
* Accounting
Policy / section / claim granularity
Freed from the limits of traditional OLAP solutions, InsFocus BI's insurance data warehouse model details data to the lowest insurance granular level, including:
* Policy data
* Policy transactions (changes)
* Policy sections (coverages)
* Risk codes (specific values per product)
* Claims data
* Claim payments
* Claim outstanding estimate changes
* Collection data
* Client data
Optimized for insurance queries
InsFocus BI's data model was built for insurance from the ground up, and therefore is highly optimized for fast and flexible insurance-specific queries. A lot of work and effort has been put into each calculation method, index, fact table and other data structures, in order to speed up and facilitate typical insurance queries, such as:
* Earned and unearned calculations
* Issued, latest, exposed, in-force sums-insured
* For renewal and lapses
* Outstanding claim estimates
* Reinsurance cessions and margins
* Claim status filters (e.g. run-off)
Follows industry standards
InsFocus BI's data model is a star-schema dimensional model, closely following the Kimball approach for data warehousing. The data model has been developed for years following practices by Mark Kimball, TDWI, Microsoft and others, to achieve a highly efficient yet standards-compliant insurance data warehouse.
SOURCE:http://www.insfocus.com/product/insurance-data-model.html
0 comments:
Post a Comment