Reference no: EM133871163
Data Visualisation and Communication
Assessment - Insights on Car Theft for Insurance Premiums
Task
As a group of Business Analytics professionals working in a New Zealand company specialising in car insurance, your task is to analyse a dataset to uncover insights relating to risks leading to vehicle theft in New Zealand. You will create a presentation document that includes key indicators that will allow decision-makers to adjust insurance premiums based on the risks identified.
Assessment Description
You work in an analytics team in a New Zealand company specialising in car insurance. Your team has been asked to determine risk indicators, including which locations and types of vehicles are more likely to result in a theft. This in turn will influence the setting of insurance premiums. Get online assignment help in the USA!
To perform this analytics task, your team will need to generate some hypotheses and test whether each hypothesis could lead to a lower or higher rate of car theft, if the hypothesis is true. Also discuss limitations of the data set in arriving at firm conclusions.
Using the provided dataset (three data tables), your team will create a presentation identifying the indicators or risk factors associated with vehicle thefts. This will influence the setting of car insurance premiums for your company in New Zealand. Your visualisation will include key (dot) points that comment on greater risks, thereby impacting car insurance premiums - location, car make etc.
Your team have been provided with 3 data tables. Your team firstly needs to connect the data tables in either Power BI or Tableau.
Assessment Instructions
Form groups of 3-4. If you do not have a group your teacher will allocate you to a group in class. During class in week 10 you will be required to create a presentation document (i.e. PowerPoint or other document) presenting your hypothesis. At the end of class you will upload your presentation to Turnitin on MyKBS. There is no need to verbally present your slides to your fellow students.
Note: A full report will be written individually in Assessment 4, in the form of an insightful story that assists your employer with decisions about insurance premiums, based on propensity of vehicle theft.