DESCRIPTION
Problem Statement: Create a dashboard to do a comparative study on various parameters of different countries using the sample insurance dataset and world development indicators dataset.
Datasets Primary Dataset – Insurance Sample Dataset
Secondary Dataset – Global Financial Development Database
Hint: (Use Data Blending with Relationships between Country Code, Country, and Year)
Dashboard Description A geographic map showing countries field. Color the map based on Income column from the secondary dataset.
Include a filter of income group to the dashboard
Include a webpage to show data from world bank webpage driven by an URL action from geography graph.
The country names in the map will act as the trigger https://data.worldbank.org/country/?view=chart
Create a KPI Table to show the comparison between the selected period and the prior period to the selected one.
Create two parameters for Year Selection and Category Selection.
Category Parameter to have Life Insurance Share, Market Share, Penetration, Ratio of Reinsurance Accepted & Retention Ratio
Create a calculated field to calculate the Growth %.
Create a table to show these values as shown.
Title to be updated based on the category selection
Create Growth Indicator Shapes based on the Growth %.
Growth indicator to display Negative, No Change and Positive as values and corresponding shapes against it.
Create a trend line to show the selected category values.
The line to show with a arrow/triangle at the last mark
Dashboard filter for income group to be applied for all charts with the filter action enabled in the map as well
Formatting to be done appropriately