Data Warehouse Model for Insurance

Poslovna Inteligencija Insurance Data Warehouse Data Model (PI Insurance DWH Model) is a standard industry data warehouse model applicable for both life and non-life insurances. Based on data represented in the model, all standard insurance reporting and analysis Data Marts can be delivered.
PI Insurance DWH Model is based on industry best practices, developed and applied during data warehouse system implementations in Basler osiguranje Zagreb. Also, it is open for necessary alterations and modifications required for each insurance customer.
PI Insurance DWH Model is based on strong Primary Key - Foreign Key relationships that will assure consistency in the model itself and in content of implementation Data Warehouse System. Physical model implementations can be in every standard RDBMS.
PI Insurance DWH Model is developed with CA ERWin and will require ERWin license to view or change. Model can be exported to any other standard database modeling tool format.
In the current version 1.3 of the model, model has more than 170 Entities (Tables) grouped in 13 Subject areas:
  1. Actuary Subject area
  2. Business Items and KPI's Subject area
  3. CAPEX Subject area
  4. Claims Subject area
  5. Customer Subject area
  6. ETL Process Execution Audit Subject area
  7. Finance 
  8. Human Resources Subject area
  9. Investments Subject area
  10. OPEX Subject area
  11. Products Subject area
  12. Sales Subject area.
Color-coding of tables and Subject areas in the model is as follows:
White - common business and infrastructure tables
Yellow - Customer tables, Product tables
Light Green - Policy tables, Payment tables, Sales tables, Actuary tables
Blue - Claim tables
Grey - Finance, Human Resources tables
Visual representation of Main Subject Area, which consists of all PI Insurance DWH Model Entities:
PI Ins DWH Model-MainSubjectAre
In PI Insurance DWH Model, semantic data model is actually integrated with logical data model in several ways:
- Relationships between the various entities are named and they describe type of relationships
- Naming conventions for entities and attributes is respected throughout the model
- All attributes have a domain. Domains are not only generic (String, Number, Date), but also context-specific and descriptive of attribute role (Name, Address, ID, Telephone Number).
PI Insurance DWH Model is customizable per customer specific requests. There are several types of customizations:
- Customizing of existing Entities including changing attribute properties (name, type, and description), adding new attributes, adding indexes etc.
- Creating of new Entities if there is a requirement for a new dimension or new aggregation
- Adding new Subject areas with multiple entities that will cover new business areas 
- Customizing of physical model - defining pertitions, block sizes etc.
Parent Category: Solutions

Subscribe to newsletter



ferari mini logo

6774 – FAIR




ISO 27001 Slika 2

AmCham Member 2015 Logo


Through education and training we allow our clients to completely utilize implemented tools in everyday business. We provide trainings for specific tools, DWH and BI methodologies and tailor made training for the purposes of specific projects.


We provide services needed for successful design, development and implementation of Big Data Processing and Analytics systems. Big data analytics is the concept of data analysis and deriving useful information from large volumes of data that is rapidly being generated in modern business.


MDM system provides a holistic, single view of foundational business entities, commonly referred to as master data such as customers, employees, citizens, locations and products. Successful MDM projects facilitate better operational efficiency, higher customer loyalty and successful compliance efforts.


Strategic consulting is a service provided by our top management consultants who have wide expertise in business processes in most industries in design and implementation of various types of business strategies.


Our methodology for managing and supervising of projects is characterized by the speed in which first useful results are produced, efficiency in implementation, the flexibility of the methodology, the effectiveness of risk management, quality assurance and optimization of project documentation.


Implementation  of intelligent information systems for support of the business decision making process is our primary field of activity. According to our clients' needs and expectations, we will provide either turnkey solutions or work together with our clients experts on implementation projects.


Nearshoring services

Our company is providing nearshoring development services for implementation of DWH/BI/PM systems for clients in different countries in EU. We can combine shorter on-site visits with majority of the activities done off-site through secure connection.



In order to view this object you need Flash Player 9+ support!

Get Adobe Flash player

Powered by RS Web Solutions