| |
Insurance |
Local Gov't |
Retail |
| BI Layer Data |
Time Period, Total Claims Settlement as % of Total Revenues from Policy Payments |
Time Period, Top 10 Services |
Time Period, Revenue, Location etc. |
Time Period, Feedback - Daily Complaints, etc. |
| KPIs |
Insurance Claims KPIs |
|
|
|
| BI Layer Format |
Line on Graph |
Pie Chart |
Line on Graph |
Line on Graph |
BI Layer Example
- SSAS (Cube)
- SSRS (eg Views)
|
 |
 |
|
|
Data Mart
- Oracle Apex
- SQL Server |
Time Period, Total Claims Settlement as % of Total Revenues from Policy Payments |
Time Period, Services |
Time Period, Location, Product, Revenue |
Time Period, Feedback Count |
Data Warehouse
- Oracle Apex
- SQL Server
- FastTrack DWH
|
Customers, Claims and Settlements |
Customers and Services |
Customer Sales |
Feedback |
Integrated Data Layer
- ETL,DQ, MDM,etc
eg SSIS
|
Transform to 3NF |
Transform to 3NF |
Sales and Master Data |
|
| Data Sources |
LOB Systems for Customers, Claims and Settlements |
LOB Systems for Benefits, Social Services and so on |
POS Log |
Comments Forms and Social Networks |
| Standard Data Model |
ACORD |
N/A |
ARTS |
