Scribd
Upload
2K views4 pages

Data Visualization in Tableau - Project

This document analyzes car insurance claim data to provide insights for policyholders and insurers. The analysis visualized key metrics like claim rates based on demographics, occupation, education, car type, and more. It found that males, urban dwellers, singles, and those in certain occupations had higher claim rates. Kid drivers and private drivers also contributed to more claims. SUVs and minivans saw more claims. The analysis recommends measures like tracking devices for kids, higher premiums for certain vehicles and demographics, and focusing on lower risk rural policyholders.

Uploaded by

Tunde Asaaju
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2K views4 pages

Data Visualization in Tableau - Project

This document analyzes car insurance claim data to provide insights for policyholders and insurers. The analysis visualized key metrics like claim rates based on demographics, occupation, education, car type, and more. It found that males, urban dwellers, singles, and those in certain occupations had higher claim rates. Kid drivers and private drivers also contributed to more claims. SUVs and minivans saw more claims. The analysis recommends measures like tracking devices for kids, higher premiums for certain vehicles and demographics, and focusing on lower risk rural policyholders.

Uploaded by

Tunde Asaaju
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

D ATA V ISUALIZATION IN

TABLEAU
Car Insurance Claim –Data Analysis

Insights for Policyholders and Insurers

Babatunde Asaaju
7/10/2020
7/10/2020

DATA VISUALIZATION IN TABLEAU


Car Insurance Claim –Data Analysis

https://public.tableau.com/profile/babatunde1254#!/vizhome/CarInsuranceClaim-
DataAnalysis/CarInsuranceClaimDataAnalysis?publish=yes

Executive Summary

The analyzed raw dataset has 1000 rows with 20 variables


classified into dimensions and measures on car insurance claim.
The analysis helps to display visuals as metrics for insights that
could guide policyholders and insurers in making important
decisions.

Data preparation was carried out to ensure cleaned and well


interpreted dataset.

Claim-rates Overview:

a. Policyholders Demographic
Factor Claim-rates
Gender
Female Low
Male High
Area
Highly Urban/Urban High
Highly Rural/Rural Low
Marital Status
Single High
Married Low

b. Policyholders Occupation: Policyholders in three occupations


(Blue Collar, Clerical and Professional) contributed to the
major claim frequency and amount in the past 5years.
c. Kid driving has very significant effect on the claim-rates
possibly due to inexperience.

1
7/10/2020

d. Policyholders are classified into two by car use; Private and


Commercial Policyholders. Private policyholders have high
claim-rates which may be due to self-drive (non-professional
driving skill).
e. Policyholders Education: High claim-rates is common with
High School Policyholders.
f. Policyholder Car Type: SUV, Minivan and Pickup are major
car types with most of the claim amount.

Parameter filter was used to provide value visualization for claim


frequency and amount.

Also, dashboard action was setup to vary the impact of areas on


category of policyholders/

Visual Screenshots

2
7/10/2020

Inferences:
 Insurer must ensure to put in place mechanism such CCTV
integrated tracking device in an insured car to detect and
deter kid driving as it contributes majorly to incidents for
high claim frequency.
 Insurance policy for SUV and Minivan must be expensive so
as to cover for possible loss because they are car types within
reach of High School policyholders and kid driving.
 Market focus should be more on policyholders in highly
rural/rural because rate of incident for claim is relatively
low.
 Married policyholders are more cautious.

You might also like