4.4 BI Data Model

The BI data model is a star schema for the fact tables FCT_INSURANCE_QUOTES, FCT_INSURANCE_QUOTE_REPORTS, FCT_COMMON_POLICY_SUMMARY, FCT_IPA_POLICY_SUMMARY, FCT_PFT_POLICY_SUMMARY, FCT_CLAIM_DETAILS, FCT_CLAIM_TRANSACTIONS, FCT_AGG_PRODUCER_SUMMARY, FCT_PRODUCER_APPOINTMENTS, and so on.

Following are the subject areas in the ERwin data model:

Figure 4-1 Insurance Quotes and Reports

Figure 4-2 Policy Summary

Figure 4-3 Policy Coverages

Figure 4-4 Policy Profitability

Figure 4-5 Aggregated Producer Summary and Producer Appointments

Figure 4-6 Claim Details

Figure 4-7 Claim Transactions