Insurance Modeling

This is an ongoing personal project exploring P&C insurance data analysis, predictive modeling, and actuarial methods. Each module below uses real datasets and targets actuarially relevant problems.

Dataset A — Part 1: Lookup / Analytics Dashboard

Complete

Interactive SQL-backed dashboard for the Kaggle Agency Performance dataset with filters, charts, summary stats, yearly tables, and SQL transparency.

⭐ Dataset A — Part 2: Predictive Modeling

Complete

R-based predictive modeling of next-year written premium using regression, tree-based models, and mixed effects models.

Dataset B: Schedule P / Reserving Methods

TBD

CAS Schedule P reserving methods including chain ladder, Bornhuetter-Ferguson, Cape Cod, and reserve diagnostics.

Excel / VBA Implementation

TBD

Standalone Excel/VBA version of selected dashboards and actuarial calculations.