Free and Premium Tableau Desktop-Certified-Associate Dumps Questions Answers

Explanation:

Drop the State field to a view, you will get >1k unknown.

Drop the Country to the Filters Shelf and Select the United States, all unknowns should be gone.

Also, drop the Order Date to the Filters Shelf and choose Years as:

Graphical user interface, application Description automatically generated

Check for the Year 2013.

Drop the Sales field to the Label in the Marks card, your view should look like this:

Graphical user interface Description automatically generated with medium confidence

Now use the Lasso Selection tool from the Map tools:

Graphical user interface, diagram Description automatically generated

And create the group of states as per our answer options.

Example - for New York, Massachusetts, Rhode Island, Similarly, do for other 3 options as well.

Map Description automatically generated

Duplicate this worksheet and remove the Latitude and Longitude from the view and drop this new dimension of groups to the view. California, Idaho, Nevada is the right answer.

Graphical user interface, text, application Description automatically generated

Explanation:

Refer to the quick comparison of data blending and custom geocoding -

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:

While creating the parameter action, it is not mandatory to specify the aggregation.

All others are true.

Refer:

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

Explanation:

Tableau automatically associates discrete fields with categorical palettes

Refer:

Refer:

Go to the section- Phone layouts and the Default dashboard

Go to the menu Dashboard -> Action -> Add Action

Select Filter, here you will find the Target Sheets

For all other options, you will not find the Target Sheets. Try it yourself.

The upper whiskers extends to 1.5 * IQR

The length of the upper whisker is upper hinge + 1.5 * IQR.

Refer:

Drop the Sales to the Rows and disaggregate the values. (Go to Analysis -> uncheck Aggregate

measures)

From Show Me, Select Box and Whisker plots. And drop the Ship mode to the columns.

Hover on each of the boxes:

Median for the First Class and Same Day ship modes are 84.

bkimages_coordinates.htm#:~:text=Right%2Dclick%20anywhere%20on%20the,Annotation

%20dialog%20box%2C%20click%20OK.

Explanation:

Drop the Age to the columns and change the aggregation to AVG.

Drop Gold Medals field to filter and select All values ->

Graphical user interface, text, application, email Description automatically generated

Change 1 from 0.

Graphical user interface, application 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.

Explanation:

Find out how many gold medals each athlete won in the 2008 Olympics

Graphical user interface, text, application, website Description automatically generated

Drop Athlete to Rows and 2008 golds to the Text. Drop gold medals to the view. Your view will look like this:

Graphical user interface, text, application Description automatically generated

Now we need work on "won at least 4 golds in 2012 Olympics"

Drop years to filters and select 2012.

Drop Gold Medals to filter and mention 4 in range of values (as we need to find athletes who won at least 4 gold medals)

Graphical user interface Description automatically generated

Final view:

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

Explanation:

Left join the Orders and Returns table

Diagram Description automatically generated

Number of orders returned will be order ID from the returns table divide by total orders

Graphical user interface, text, application, website Description automatically generated

Drop the customer name and ret order field in the view.

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

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