Insurance Risk & Claims Analysis Dashboard

Project Overview:

An interactive analytics dashboard developed to evaluate insurance policy distributions, risk factors, and financial claim metrics. The project aims to provide deep, data-driven insights into policyholder demographics, vehicle usages, and claim amounts to help insurance firms optimize risk assessment and management strategies.

Key Insights & Metrics:

Financial & Policy Overview: Tracked 37,542.0 Total Policies with a Total Claim Amount of $187.8M, maintaining an average claim frequency of 0.5 and an average claim amount of $5.0K.

Demographic & Risk Segmentation: Analyzed policies by gender (18.8K Female, 18.7K Male), age groups, and education levels, alongside risk factors like "Kids Driving" and "Coverage Zone" (Urban vs. Rural).

Operational Trends: Visualized policy distributions based on vehicle characteristics, including "Car Use" (Commercial vs. Private), top car makes (led by Ford and Chevrolet), and historic "Car Year" trends using time-series charting.

Tools Used: Power BI / Excel for data cleansing, complex metric modeling, and advanced visual formatting.