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.

Open →

Dataset A — Part 2: Predictive Modeling

In Progress

R-based predictive modeling of written premium, loss ratio, and retention ratio using regression, tree-based models, and mixed effects models.

View →

Dataset B: Schedule P / Reserving Methods

Planned

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

View →

Excel / VBA Implementation

Planned

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

View →