Skip to content
OrionStats
Log inStart learning
← Project Lab
PROJECT 26Intermediate

Insurance Renewal Rate Analysis

Business scenario

Orion Insurance's renewal rate for travel policies is far below other lines. The head of insurance asks why and whether it matters.

Problem statement

Compute renewal rates by product, channel and claim experience, and quantify the premium at risk.

Learning objectives

  • Define the renewal denominator correctly
  • Compare renewal by segment
  • Quantify financial impact

Instructions

Renewal rate = policies renewed ÷ policies reaching end of term in the period. Exclude policies whose end_date is after the data cut-off.

Tasks

  1. Renewal rate by policy type and channel.
  2. Renewal by whether a claim was made and claim status.
  3. Premium at risk.
  4. Recommendations (is travel renewal even the right metric?).

Deliverables

  • SQL
  • Workbook
  • Recommendations

Evaluation rubric

CriterionWeightExcellentProficientDevelopingInsufficient
Data preparation & validation20%Correct filters and grain; validation checks documented and totals reconciled.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.
Metric definition25%Correct denominator and censoring.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.
Segment analysis15%Claims and channel effects analysed.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.
Interpretation & recommendations25%Clear, quantified conclusions tied to the business question, with limitations stated.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.
Presentation15%Concise, well-labelled outputs a manager can act on without explanation.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.