insurance and claim analysis

Key KPIs: Total policies (38K), total claim amount (187.82M), claim frequency (0.51), and average claim amount (5K).

Customer Demographics: Distribution of policies by gender and education level.

Claim Patterns:

By Car Use: Private vehicles account for 80.1% of claims.

By Car Make: Ford, Chevrolet, and Toyota dominate claim amounts.

By Coverage Zone: Urban and highly urban areas show the highest claim shares.

By Car Year: Trend showing claims over time.

By Age Group: Claim amount distribution across age segments.

Special Insights: Impact of kids driving on total claims and policies.