Data Model for Insurance Data Warehouse


Printer-friendly version

Insurance Data Warehouse / Dimensional Model

An Access Database is available on demand.

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 :-

3NF Data Model

Insurance 3NF Data Model

Dimensional Model

Insurance Dimensional Model

There are also designs for :-

Data Staging Tables

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
February 8th. 2013