Insurance Track Overview

This track is designed to feel like real insurance analytics work, not isolated SQL snippets.

You will practice:

• policy portfolio analysis
• written and earned premium metrics
• claims and loss-ratio style calculations
• fanout-safe modeling patterns

• SQL joins and grouped aggregations
• CTE basics
• ratio metrics with NULLIF to avoid divide-by-zero

1. Insurance Star Schema
2. Meet the Insurance Dataset
3. Data Quality Audit
4. Insurance Graded Drills (Easy → Hard)
5. Insurance KPI Assignments
6. Loss Ratio Trends & Claims Aging
7. Insurance Case Study Capstone

Milestone A: pass all easy drills and at least one medium drill.
Milestone B: pass at least one hard drill, then complete the KPI assignments.
Milestone C: complete capstone query and explain your metric tradeoffs.

Exit criteria:

• pass at least 80% of graded checks across drills + assignments
• complete capstone with a fanout-safe query shape