Comparative Study of Countries
Objective: To create a dashboard to compare all the parameters for different countries, to strategize market penetration and to target new customers.
Tasks: 1.Create a geographic map showing the countries' fields.
-
Color the map based on the income column from the secondary dataset •Include income group filter in the dashboard 2.Includea webpage to show data from the world bank webpage drivenby an URL action from a geography graph •Thecountry names on 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
4.Create Growth Indicator Shapes based on the Growth % • Growth indicator displays Negative, No Change, and Positive as values and corresponding shapes against it.
5.Create a trend line to show the selected category values •Theline shows an arrow or triangle at the last mark
6.Create a dashboard filter for income group to be applied for all charts with the filter action enabled in the map as well
7.Formatting should be done appropriately
Outcome:
- This project is designed to help companies to create an interactive dashboard and to compare the parameters for different countries.
- You should be able to strategize market penetration and target new customers.