Insurance Star Schema

This track uses a simplified insurance model.

New to dimensional modeling? Read Star Schema Basics first; it explains facts, dimensions, and grain, which this page assumes.

Core entities:

• ins_customers (dimension: one row per customer)
• ins_policies (dimension: one row per policy; each policy belongs to exactly one customer)
• ins_premium_facts (fact, grain: one row per policy per month)
• ins_claims (fact, grain: one row per claim)

• customers 1->many policies via customer_id
• policies 1->many premium_facts via policy_id
• policies 1->many claims via policy_id

Continue with:

• Insurance Graded Drills (Easy → Hard)
• Insurance KPI Assignments