Pre-Order Your Tableau Desktop Certified Associate Exam Desktop-Certified-Associate

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.

Explanation:

Drop the Latitude and Longitude fields to Rows and Columns shelf respectively. Or double click on these fields.

Drop the Location field to Filter shelf, select the Location as Colombia.

Drop the Name field to the Label.

To show the cities go to the Map -> Map layer and Check the Cities.

Graphical user interface, text, application Description automatically generated

Drop the Deaths and Year fields to the Tooltip. Now your view looks like this:

Map Description automatically generated

Zoom-in the map, you will find Purace is the nearest one in the Popayán city and Dona Juana was having 55 deaths.

Map Description automatically generated

Explanation:

Create a calculated field as:

Graphical user interface, text, application Description automatically generated

Drop this field to Rows and Total Death to the Columns. And Select the Quick Table Calculation-> Percent of Total.

Graphical user interface, application Description automatically generated

Graphical user interface, application, table, Word Description automatically generated