Tableau Desktop Certified Associate Practice Test - Questions Answers, Page 9

https://help.tableau.com/current/pro/desktop/enus/bkimages_coordinates.htm#:~:text=Right%2Dclick%20anywhere%20on%20the,Annotation%20dialog%20box%2C%20click%20OK.

Find out the distinct orders for each customer

Move this field from Measure to Dimension.

Drop this field to the Columns Shelf and drop customer ID to Rows, aggregate the Customer ID using CountD, and drop this field to Label as well. Your view will look like this:

29 distinct customers have made 6 orders.

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

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

Topic 3, Exam Pool C

Download the Dataset from here:

https://drive.google.com/file/d/1hGTUYyq6Y7DLt-DwxVaR4tNLS-FYvD22/view?usp=sharing

Use the above data set to answers the questions under Exam Pool C.

As per the Tableau order of operation, dimension filter is applied before table calculation is computed. However, fixed LOD is executed before the dimension filter. That's why total sales are showing different results.

Reference - https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm

Drop the longitude field to Columns and latitude to Rows.

Add Location filter and select Aleutin IS

Drop the Name field to Labels

Your view will look like this:

We need to find in Km so go to Map -> Map options and select Units as Metric

Use the radial selection tool to find out the distance between Okmok and Vsevidof volcanoes

Calculate the Profit Ratio:

Create a LOD expression -> for each order date if profit ratio is greater than 25% returns 1.

Drop the Order date to Rows and drill-down it to Quarters.

Drop the profit ratio >.25 field to Text:

Refer section "Null values appear after blending data sources" at

https://help.tableau.com/current/pro/desktop/enus/

multipleconnections_troubleshooting.htm

You cannot mix the aggregated and non-aggregated calculations.

MAX(SUM(Profit), (Sales)) -> Profit is aggregated but Sales is not.

SUM([Profit]) * [Quantity] -> Profit is aggregated but Quantity is not.

You can multiply the aggregated/non-aggregated fields with constant. That's why SUM([Profit]) * 1000, is correct.

SUM([Profit]) * SUM([Quantity]) - Both are aggregated

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:

Check for the Year 2013.

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

Now use the Lasso Selection tool from the Map tools:

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.

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.