Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Display all the leading measures like - the number of claims, the amount claimed, amount claimed on the property, and the amount claimed on the

 

 Display all the leading measures like - the number of claims, the amount claimed, amount claimed on the property, and the amount claimed on the vehicle.          

 

2. Identify the correlation between the age of the customer and the total amount claimed by them. Is there any trend or pattern in the values?

 

3. Show location-wise incident counts across a geo-map

 

4. Have a dashboard representing the following information:          

  1. Gender-wise incidents and claims
  2. The number of claims by Incident Severity
  3. The number of claims by Incident Types
  4. The number of claims based on auto_year (use binning concept)
  5. The number of claims by auto_make

Motorcare is an insurance company and has shared its claims data. The data is about all the incidents that happened in 2015 and claims that were called for. As a data analyst, you have to import the data in Power BI, apprehend the data and extract meaningful insights from the data. The problem aims to get a clear understanding of Power BI as a visualisation tool. You have to explore all the techniques that can be used in analysing data using a visualisation tool. To analyse the data solve the questions below:

Step by Step Solution

3.37 Rating (144 Votes )

There are 3 Steps involved in it

Step: 1

Here are the steps to analyze the Motorcare insurance claims data in Power BI 1 To display leading ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Finance questions

Question

What are the pros and cons of credit? Critical T hinking

Answered: 1 week ago