Insurance KPI Assignments

Assignments mirror common insurance analytics questions.

Metrics focus:

• policy count per customer
• written vs earned premium
• claim severity by product line
• policy retention (active rate) by product line

Claim severity is the average incurred cost per claim. Underwriters track it alongside loss ratio: a product line can have few claims (low frequency) but expensive ones (high severity).

Work at claim grain: each claim maps to exactly one policy, so a direct join to ins_policies cannot fan out.

Retention proxy: of all policies ever written in each product line, what share is still in force? Cancelled policies count against the rate.

This is a simplified one-period view of retention. Production retention compares renewals across policy years.

Finish the track with:

• Insurance Case Study Capstone