Feature spotlights

Business Terms

With no modeling or abstraction involved, Business Terms define in plain business language the industry concepts that are involved in the insurance industry. Clearly defined business terms help standardization and communication within an organization. Mapping to the data models make it possible to create a common, enterprise wide picture of the data requirements and transform them into IT data structures.

Supportive Content

Supportive Content captures non-reporting requirements in a particular domain and relates those to the data warehouse model entities, relationships and attributes. It provides a method of mapping both external and internal terms from business standards and other requirements to the Business Terms and to the Atomic and Dimensional Warehouse Models.

Analytical Requirements

Analytical Requirements reflect the most common queries and analyses for business performance measurement and reporting, while supporting other analytical functions, such as ad hoc reporting and decision support. Over 140 predefined business reporting requirement templates are provided addressing the common business reporting and analysis requests from risk, finance, compliance, CRM and line-of-business users.

Business Data Model

This is the first point where various business requirements are brought together and modeled in an entity relationship format. This component includes common design constructs that can transform into separate models for dedicated purposes, such as an operational data store, warehouses and data marts. Designed for the insurance industry, the BDM (Business Data Model) contains thousands of business definitions and provides an enterprise wide view of data common to all insurers.

Atomic Warehouse Model

The AWM (Atomic Warehouse Model) is a logical model consisting of the data structures typically needed by an insurer for a data warehouse. The comprehensive logical data models contain the predefined data warehouse structures required to store all financial services data in an efficient layout for historical and atomic data.

Dimensional Warehouse Model

The DWM (Dimensional Warehouse Model) provides the data design support needed to transform the enterprise level business requirements into business specific and efficient structures dedicated to the design of a dimensional data repository. The comprehensive logical data models contain the predefined data warehouse structures required to store all financial services data in an efficient layout for analytics.

Compliance and enterprise risk management

IIW covers enterprise risk management, finance and compliance reporting (including Solvency II - Quantitative Impact Study 5 (QIS5) and Consultation Paper 58 (CP58) support). It also provides support for Sarbanes-Oxley Act, claims, intermediary performance, basic life and pension actuarial, corporate pensions compliance, risk management visibility and more.

Integration

Can be integrated with best in class applications needed in data warehousing phases such as Business Glossary, ETL, Insurance Analytics, Data Mining, OLAP environments such as IBM Cognos business intelligence and CRM tools. Uses a Kimball dimensional model approach based on business solution templates to integrate with IBM Netezza data warehouse appliances.

Learn more

Buy now and get started