Insurance Analytics

This track is designed to feel like real insurance analytics work, not isolated SQL snippets. You will practice: policy portfolio analysis w...

This track uses a simplified insurance model. New to dimensional modeling? Read Star Schema Basics first; it explains facts, dimensions, and...

Before you write a single KPI query, meet the data. Analysts who skip this step ship wrong numbers with confidence. The routine is always th...

Auditing before analyzing is the job. Every loss ratio, severity, and retention number you ship later inherits whatever is wrong in the tabl...

These drills build insurance analytics fluency in increasing difficulty. Scoring suggestion: Easy drills: pass all Medium drills: pass at le...

Assignments mirror common insurance analytics questions. Metrics focus: policy count per customer written vs earned premium claim severity b...

A single portfolio-level loss ratio hides everything interesting. The questions underwriters actually ask are trend questions: is the ratio ...

Case brief: You are supporting an underwriting analytics review. Build a reliable KPI pack and then produce a policy watchlist for investiga...