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








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








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.







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