Ask a Question
The Insurance BI Offshore Data Model
An Access Database
is available on demand.
have been defined in a Question to this Web Site.
We would be glad to have
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
KPIs" 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'
2) ER Model
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)
There are also designs for :-
Data Staging Process
Data Staging Tables
Database Answers Ltd.
February 5th. 2017
© DataBase Answers Ltd. 2017