Database Answers Zurich, Switzerland (Click for Zurich Insurance Web Site)

Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
The Insurance BI Offshore Data Model   
An Access Database is available on demand.

The Requirements have been defined in a Question to this Web Site.

We would be glad to have your comments.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.

Here's some very useful information about Insurance Data Standards from ACORD, which was built on the Prima Reference Data Model.

KPIs are very useful and here are two sources :-
  • KPIs for Insurance
  • 49 "smartKPIs" for Insurance

    Our Entities in the ERD are aligned with the "Primary Objects in the ACORD Data Model".

    1) Conceptual Data Model
    we start with a simple KPI like '% Successful Claims'

    Insurance Conceptual Data Model
    2) ER Model
    (Phase 2)
    On Jan 06th I revised the Model after my discussion with ACORD.

    3) Dimensional Model
    We will modify this Dimensional Model to keep it in line with our ERD Phase 1)

    Insurance Dimensional Model

    There are also designs for :-
  • Data Staging Process
  • Data Staging Tables

    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    February 5th. 2017

  • © DataBase Answers Ltd. 2017
    About Us Contact Us