Insurance Car Claim Project Data Visualisation

Data Visualization Project Car Claim
Insurance
Project Objective
The main aim of the project is to analyse the dataset of car insurance using tableau. The analysis and
recommendations will cater towards the business objective of a Typical Insurance Company providing
car insurance to both personal and commercial users.
Assumptions
1) There are several factors which are provided in the dataset. However, there may be other unseen
factors that are not considered
2) YOJ and birthdate will lead to number of years/age computed as at 2020.
3) The dashboard presented are intended to analyse the car insurance claims in details, in order for the
insurance company to have an informed understanding of their customer base and to provide a better
customer service.
Data Dictionary
The dataset has data on 10284 client’s car insurance information, it includes the customer
demographic information (birthdate, income, value of house owned, marital status, gender, education
level, occupation, travel time.), the insurance claim information (worth of car, claim amount, claim
frequency, age of car etc).
Car Owner and Driver are same

Assumption
Amounts are in Dollars ($)
ID Identification Variable
Number of teenagers among the car owner's children who can
KIDSDRIV
drive a car.
BIRTH Date of birth of the driver
HOMEKIDS No of childern the car owner has
Years on Job. How many years has the owner of the car been
YOJ
working?
INCOME Income of the driver
PARENT1 Is the car owner a Single Parent
HOME_VAL Value of the house owned by the car owner
MSTATUS Marital status of the car owner
GENDER Gender of the driver
EDUCATION Maximum Education level of the driver
OCCUPATION Occupation of the driver
TRAVTIME Time taken to get to work on an average
CAR_USE Purpose of using the car
BLUEBOOK What is the worth of the car. Value of the Vehicle (in dollars)
CAR_TYPE Car type
OLDCLAIM Total claim (in past 5 years - in dollars)
CLM_FREQ Number of claims (in past 5 years)
If car was in a crash, what is the currently claimed amount (in
CLM_AMT
dollars)
CAR_AGE Age of car
URBANICITY Where the car is being driven primarily
Creation of New Calculated fields

The following new calculated fields are created for the running of the datasheets.
1)Age group computation
2)Claim Frequency computation
3) Computation of Claim amount range

4)Creation of Multi-Dimension parameter [to be used in Top N Customer]
5) Creation of Multi-Dimension parameter [to be used in Demographics of

Client]
6) Dashboard Follows
6.1) Client Demographics Dashboard
6.2) Car Type vs Other Dimensions

6.3) Claim Frequency vs Car Type
6.4) SUV Insurance for Female Driver

6.5)Claim Amount for Car type and Gender
9)Occupation vs Education
Major findings:
1) Income range of the majority of customers<100,000.
2) Occupation wise students and homemakers are the major group with car insurance
3) From the perspective of education, graduates of high school and Bachelors buy car insurance.
4) Professionally, jobless, blue collar, clerks and students prefer to buy car insurance. However, the
underlying reason is not clear at this point.
10) Income Range vs Car Type
In this datasheet, the type of car bought by the income range can lead to the following conclusion:
1) Income Range<50000 and between 50000-100000, has a strong preference for Minivan and SUV.
2) The other income ranges does not exhibit any strong liking for any specific car type
11)Education vs Income Range
It is quite evident that the income range of highly educated customers are much higher than
those who have passed high school or less. It is also evident that female customers have a
higher income in every education group compared to their male counterparts.
12)Gender vs Car Type

Female customers buy car insurance more than the male customers. Also, female customers
has a strong affinity for SUV and sports car.
13)Car Demographics
In this datasheet, we can conclude of the following points on car’s demographics:
• Car Worth decreases with time

• SUV and Minivan retains their value for a longer time
14)Claims Dashboard
The insurance claims dashboard has been prepared to provide a quick-access snapshot of all the
relevant information.
Major findings are
• Highest number of insurance claim is amongst SUV and minivans
• Majority of claims are by female customers
• Majority of claims are in the initial years of purchase; claims decrease with age of the vehicle
Frequency of insurance claim is highest in the initial years of car age
15) Top 5 customers

Top 5 customer claims are
• Pickup with 1 yr age
• Van with an age of 3 yrs
• Sports car in the first year
• Very old Parcel trucks with age of ~ 12 yrs
• Minivans with age of ~ 6 yrs
16)Top claim by car type

Top claims with respect to car type belongs to the SUV group.
17) Storyboard
2 storyboards have been created to explore the insurance claims of
• Female SUV owners
• Male drivers
17.1) Car Insurance for Female Drivers

A Story board has been created to explore and analyse the insurance claims female SUV owners.
The main reason for choosing this storyboard is due to the fact that majority of insurance claims are
from female drivers most of whom drive SUV.
Point 1: Focus on the SUV and the car worth
SUV
SUV is a common car purchased amongst all income groups
In terms of car worth, it is relatively high in value
Point 2: Focus on Female driver for SUV

Income range for female drivers is not high but they are the highest number of owners for SUV
Regardless of occupation that the female drivers are their preference car type is SUV
Point 3: Claim Amount for SUV
In general, the claim for SUV is the highest among all car types
Point 4: Female driver claim for SUV

The claim amount that female driver lodge for SUV is substantially high
Point 5: Insurance claim for SUV
This table tells us throughout the life cycle of the SUV, there is high claim amount for the SUV
insurance.
17.2) Car Insurance for Male drivers

Story board created is to explore the insurance claims for male drivers.
Point 1: Focus on the minivan and pickup and their car worth
Majority of instance claim amongst males are from Minivan and Pickup drivers.
Most of these are used for commercial purpose
The vehicle retain their value even with age.
Point 2: Focus on minivan and pickup for male drivers
Point 3: Claim amount for Minivan and pickup

Claim value for minivan and pickup is extremely high in the initial years of the car life.
Point 4: Male driver claim for minivan and pickup

Among the male drivers, the minivan and pickup claim value is very high compare to the other
vehicle types.
It is also surprising to see sports car and SUV is really not popular among the male
Point 5: Insurance claim for minivan and pickup
Insurance claim value of minivan and pickup is high in the initial years and the value will go down.
However, it is not error-free as the insurance claim is still relatively high along the years.
18)Recommendations
Based on the analysis of the provided data, some recommendations are provided in the table below
Criteria Recommendation
Price range for car types Insurance for SUV/Pickup/Minivan and Panel
truck to be provided at a premium pricing
Based on Income range For an entry point of customers, insurance

premium to be lowered to gather a larger market
share
Based on past claims Customers with lower past claims should be
provided with an incentive for purchasing new
insurance
Visualization Tableau public Link details:

Dashboard 1:
https://public.tableau.com/profile/suriyakala.v8355#!/vizhome/Car
insurancedatavisualizationprojectdashboard1/Customersclaimcrit
eriaDashboard?publish=yes
Dashboard 2:
insurancedatavisualizationprojectdashboard2/Femaledriverclaimf
orSUVDashboard?publish=yes
Dashboard 3:
insurancedatavisualizationprojectdashboard3/Claimamntforcartyp
eandgenderDashboard?publish=yes
Dashboard 4:
insurancedatavisualizationprojectdashboard4/Clientsdemocratics
Dashboard?publish=yes
Dashboard 5:
insurancedatavisualizationprojectdashboard5/Cartypevsotherdim
ensionsandmeasuresDashboard?publish=yes
Story 1:
insurancedatavisualizationprojectstory1/CarinsuranceforFemaleS
UVowners?publish=yes
Story 2:
insurancedatavisualizationproject/Carinsuranceformaledrivers

Insurance Car Claim Project Data Visualisation

Uploaded by

Copyright:

Available Formats

Insurance Car Claim Project Data Visualisation

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Insurance Car Claim Project Data Visualisation

Uploaded by

Copyright:

Available Formats

Data Visualization Project Car Claim

Car Owner and Driver are same

Creation of New Calculated fields

1)Age group computation

2)Claim Frequency computation

3) Computation of Claim amount range

5) Creation of Multi-Dimension parameter [to be used in Demographics of

6.1) Client Demographics Dashboard

6.2) Car Type vs Other Dimensions

6.4) SUV Insurance for Female Driver

10) Income Range vs Car Type

12)Gender vs Car Type

• Car Worth decreases with time

15) Top 5 customers

16)Top claim by car type

17.1) Car Insurance for Female Drivers

Point 2: Focus on Female driver for SUV

Point 3: Claim Amount for SUV

Point 4: Female driver claim for SUV

Point 5: Insurance claim for SUV

17.2) Car Insurance for Male drivers

Point 2: Focus on minivan and pickup for male drivers

Point 3: Claim amount for Minivan and pickup

Point 4: Male driver claim for minivan and pickup

Point 5: Insurance claim for minivan and pickup

Based on Income range For an entry point of customers, insurance

Visualization Tableau public Link details:

You might also like