DATA VISUALISATION
Car Claim Insurance
05/04/2020
Prakash Jha
Contents
Project Objective...................................................................................................................................2
Data Set Overview.................................................................................................................................2
Executive Summary...............................................................................................................................3
Data Visualisation – Step by step approach...........................................................................................4
Environment Set up and Data Import................................................................................................4
URL for the Assignment Submitted........................................................................................................4
Insight from the Data & Data Visualisation............................................................................................4
Project Objective
This project requires to prepare Data Visualization Story of Car Insurance Key Insights and Finding based
of Car Claim Insurance dataset provided.
Data Set Overview
Few of the details of Car Claim Insurance dataset provided for analysis is captured in the table below
ID ID OF CUSTOMER
KIDSDRIV Total No of kids the car driver has
BIRTH Date of birth
HOMEKIDS No of kids the driver has at home
YOJ Year in which the car owner applied for the car insurance policy
INCOME Income
PARENT1 If car owner has his parents
HOME_VAL Value of the house owned
MSTATUS Marital status
GENDER Gender
EDUCATION Education level
OCCUPATION Occupation level
TRAVTIME Travel time taken taken in minutes(On an average)
CAR_USE Purpose of using the car
BLUEBOOK What is the worth of the car
CAR_TYPE Car type
OLDCLAIM Previous claim
CLM_FREQ How often claimed
CLM_AMT Currently Claimed amount
CAR_AGE Age of car
URBANICITY Where the car is being driven primarily
Executive Summary
The Tableu dashboards are intended to analyse Car Insurance Claims in Detail and to support further
decision making in providing better Customer Care.
This project is an open ended problems. We need to analyze different variables impacting high or low
claim amount and claim frequency and build a story accordingly.
It is assumed that the year in which the car owner applied for the car insurance policy is current year
minus the number of total years given in the data set.
Claim amount & Claim Frequency are dependent variables and other variables like gender, Mstatus ,
Homekids, Car Types , Education, Occupation, Income , Parents, Car Age, YOJ, Parents, Urbancity,
Birth etc are independent variables.
We will try to analyse univariate and /or multivariate analysis to identify the relationship and impact
of each variable on car insurance claim amount & claim frequency.
Data Visualisation – Step by step approach
Environment Set up and Data Import
Tableu Public was used for the analysis of the data set given
The Data in the excel file was imported to the tableu environment by connecting the source
file.
Figure:- Tableu File importing the Car Insurance Data Set to the Environment
The worksheet Car Insurance data is dragged and dropped in the sheet environment to analyse
the data imported.
URL for the Assignment Submitted
https://public.tableau.com/profile/prakash8611#!/vizhome/DVTAssignment_Prakash/CarClaimInsur
ance?publish=yes
Insight from the Data & Data Visualisation
1. Urban area noted high number of claims than rural area across all the Vehicle Type.
2. SUV, Pickup and Mini Van are top three preferred cars by blue collar Occupation individuals.
3. Blue collar drivers are the topmost who has highest income and high claim amount.
4. Doctors are the safest drivers who has less claim amount with less frequency.
5. Among Commercial Vehicle Pick Up Van has the highest Claim Amount and it is SUV for
the Private Owners which has the highest Claim Amount.
6. Among Commercial Vehicle Sports Car has the least Claim Amount and in case of Private
owners it is Van that has the least claim.
7. Claim Frequency by Female is higher than that of the Male Counter Part.
8. When it comes to Commercial Vehicle it is Male has highest claim and in case of Private
Vehicle the females have higher claim.
9. Those who have Mini Van have higher Income indicating the People with high income prefer
to won Mini Van.
10. Also a Male prefers a Mini Van and a female prefers a SUV
11. It is observed that the 4th Quarter has seen higher claim across years then the other quarter.
12. In Age group of 54 to 78 the claim frequency and amount has been higher indicating with
Age higher claim
13. A married female with Phd has the least claim frequency
14. A married female with high school Education and married status has highest claim also,
indicating education is also an important contributor for ensuring safe driving.
15. Panel truck is the safest car with kids driving and SUV the most unsafe this is highlighted by
the least claim and highest claim respectively.
