Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are a data analyst working for an insurance company. The company is expanding and wants to open new branches in various parts of the

You are a data analyst working for an insurance company. The company is expanding and wants to open new branches in various parts of the world. Your task is to compare various parameters such as income, life insurance share, market share, penetration, the ratio of reinsurance accepted, and retention ratio of different countries using the sample insurance dataset and world development indicators dataset. Objective: Create a dashboard to compare all the parameters mentioned above for different countries, strategize market penetration, and to target new customers. Datasets: Primary Dataset – Insurance Sample Dataset Secondary Dataset – Global Financial Development Database Note: 

Use Data Blending with Relationships between Country Code, Country, and Year Steps to Perform: Create a geographic map showing the countries' fields. Color the map based on the income column from the secondary dataset Include an income group filter in the dashboard Include a webpage to show data from the world bank webpage driven by an URL action from a geography graph The country names in the map will act as the trigger https://en.wikipedia.org/wiki/Country 

Create a KPI Table to show the comparison between the selected period and the period prior to the selected one Create two parameters for Year Selection and Category Selection Category parameter includes life insurance share, market share, penetration, the ratio of reinsurance accepted, and retention ratio Create a calculated field to calculate the Growth % Create a table to show these values Title should be updated based on the category selection Create Growth Indicator Shapes based on the Growth % Growth indicator displays Negative, No Change, and Positive as values and corresponding shapes against it Create a trend line to show the selected category values.

The line shows an arrow or triangle at the last mark Create a dashboard filter for income group to be applied for all charts with the filter action enabled in the map as well Formatting should be done appropriately.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

1 Create a geographic map showing the countries fields The first step in creating a dashboard to compare various parameters such as income life insurance share market share penetration the ratio of re... 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

Business Statistics for Contemporary Decision Making

Authors: Ken Black

6th Edition

978-0470409015, 9780470559062, 470409010, 470559063, 978-0470910184

More Books

Students also viewed these Marketing questions

Question

Discuss the various types of policies ?

Answered: 1 week ago

Question

Briefly explain the various types of leadership ?

Answered: 1 week ago

Question

Explain the need for and importance of co-ordination?

Answered: 1 week ago

Question

Explain the contribution of Peter F. Drucker to Management .

Answered: 1 week ago