Azure POC for Insurance Claims
Terms of Reference 
This Proof-of-Concept (POC) contains only the Entities required to support the baic functionality of Customer, Policies and Claims.

This is the overall Policies and Claims Data Model

Azure POC Data Model for Insurance Claims - Entity names
Step 1) Create Azure Tables for this POC 3NF Policies and Claims Data Model

Azure POC Data Model for Insurance Claims - Entity names
Step 2) Create Azure Tables for this POC Policies and Claims Dimensional Model
The purpose of this Model is to provide data for enquiries about Policies and Claims.

Azure POC Claims Dimensional Model
Step 3) Define KPI for Claims against Settlements using the Dimensional Model shown above.
           Review the available KPIs for Insurance

Step 4) Load POC Demo Data into the Dimensional Model

Step 5) Implement the KPIs with Azure BI.


© Database Answers Ltd. 2013