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