Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 187 views

    Mini Project DVT

    Uploaded by

    sumit kumar
    This document provides an overview of a mini project to create a data visualization story of car insurance key insights and findings using a provided car claim insurance dataset. It includes a table of contents and sections on the project objective, database overview, and executive summary. The database overview describes the various data fields in the car insurance claim dataset. The executive summary highlights some initial insights found, including that the highest claims occur within 12 years of purchasing insurance, most claims are filed by females and unmarried customers, and that urban residents and blue collar workers file more claims. It also provides a URL link to view the interactive data visualization dashboard.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Mini Project DVT

    Uploaded by

    sumit kumar
    187 views3 pages
    This document provides an overview of a mini project to create a data visualization story of car insurance key insights and findings using a provided car claim insurance dataset. It includes a table of contents and sections on the project objective, database overview, and executive summary. The database overview describes the various data fields in the car insurance claim dataset. The executive summary highlights some initial insights found, including that the highest claims occur within 12 years of purchasing insurance, most claims are filed by females and unmarried customers, and that urban residents and blue collar workers file more claims. It also provides a URL link to view the interactive data visualization dashboard.

    Original Description:

    Data Visualization

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an overview of a mini project to create a data visualization story of car insurance key insights and findings using a provided car claim insurance dataset. It includes a table of contents and sections on the project objective, database overview, and executive summary. The database overview describes the various data fields in the car insurance claim dataset. The executive summary highlights some initial insights found, including that the highest claims occur within 12 years of purchasing insurance, most claims are filed by females and unmarried customers, and that urban residents and blue collar workers file more claims. It also provides a URL link to view the interactive data visualization dashboard.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    187 views3 pages

    Mini Project DVT

    Uploaded by

    sumit kumar
    This document provides an overview of a mini project to create a data visualization story of car insurance key insights and findings using a provided car claim insurance dataset. It includes a table of contents and sections on the project objective, database overview, and executive summary. The database overview describes the various data fields in the car insurance claim dataset. The executive summary highlights some initial insights found, including that the highest claims occur within 12 years of purchasing insurance, most claims are filed by females and unmarried customers, and that urban residents and blue collar workers file more claims. It also provides a URL link to view the interactive data visualization dashboard.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    Mini Project:

    DVT PROJECT
    Model Report

    Table of Contents

     Project Objective
     Database overview
     Executive Summary

    PROBLEM OBJECTIVE:
    This project requires to prepare Data Visualization Story of Car Insurance Key Insights and Finding
    based of Car Claim Insurance dataset provided.

    Database Overview:
    Details of Car Claim Insurance dataset provided.

    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 Currentl Claimed amount
    CAR_AGE Age of car
    URBANICITY Where the car is being driven primarily

    Executive Summary:
    Insights By Vehicle:
    •Highest Claims are happening on or before 12 years after the customer
    taken Insurance. Most important note is customers are claiming
    insurance at ZERO years and drastically reduced age of 1.

    •Upward claim is happening after 5th year until 12 years.

    •Most of claim belongs to commercial cars. SUV cars are the most
    claimed vehicle.

    Insights By Customer:
    •Most of insurance claimed car owners are females and their frequency
    of claim also high compare with Male customers.

    •Unmarried customers are claiming high than married customer.

    •Urban customers are claiming the most.

    •Blue collar occupants are claiming high amount. Second high are
    clerical and third high are Professionals.
    URL :-
    https://public.tableau.com/profile/sumit.kumar8097#!/vizhome/Car_Insurance_Claim_Insights_DVT_Pr
    oject/CarInsuranceClaim

    You might also like