Full Access Tableau Desktop-Certified-Associate Tutorials

Custom geocoding means that you assign latitude and longitude coordinates toyour locations

so Tableau can plot them accurately.

Refer:https://help.tableau.com/current/pro/desktop/en-us/custom_geocoding.htm

Explanation:

Select New York State, you are getting only 3 products, and not 5.

Timeline Description automatically generated

You need to add State as a Context filter in the Top 5 profitable products View. For that, go to the Top 5 profitable products sheet. (click on small arrow)

Chart, bar chart Description automatically generated

Select Add to Context on the State filter

Graphical user interface, text, application, chat or text message Description automatically generated

A picture containing graphical user interface Description automatically generated

Explanation:

Go to the Map -> Map Layer

Cities Borders is not valid.

Graphical user interface, text, application, chat or text message Description automatically generated

Explanation:

Create a hierarchy of Segment, Category, Region and drop it into the rows.

Text Description automatically generated

Create profit ratio calculated field:

Graphical user interface, text Description automatically generated

Drop the profit and profit ratio fields to the view, your view will look like this:

Graphical user interface, text, application Description automatically generated

Now let's go through each answer option.

1) The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment - The profit ratio is -142.26% which is lowest overall so it is true.

2) The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765 - It is true, the profit ratio is 2.06%, which is third-lowest.

3) The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment - False, it is having a $2,245 profit.

4) The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment - False

Note: This is an easy question but time consuming, so attempt these types of questions in the end.