Free Tableau Desktop-Specialist Practice Exam with Questions & Answers | Set: 4

To clear all sorting in a Tableau visualization, you would go to the Worksheet menu, select the "Clear" option, and then choose "Sorts." This action removes all sorting that has been applied to the visualization, including any custom sorting or sorting based on multiple fields. This is a quick way to reset the view to its default sorting state and is particularly useful when you have applied various sorting layers and wish to start fresh.

Explanation

If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.

To reach the correct answer, follow the steps below:

1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!

Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!

• The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October

According to the Tableau Desktop Specialist Exam Guide, one of the exam objectives is to “Sort data in a visualization”. The guide also states that “You can sort data in a visualization from three locations: the Worksheet menu, an axis, or a field label” (page 15).

The beauty of context filters is that according to Tableau's Order of Operations, they are executed before Sets.

Diagram Description automatically generated

This means that based on what Region's you've selected - Tableau will first only preserve the rows for those Regions. THEN, after this it will compute the Set , i.e , Bottom 10 products in each Region.

1) First let's create a set to compute the Bottom 10 Products by Profit.

2) Next, take region on the Rows Shelf followed by the Set we just created. Drag Region and the Set to the Filters Shelf as well.

3) Now, try to only visualize the data for the South Region:

4) The problem right now is that Tableau is computing the Set first (Bottom 10 Products), and then applying the Dimension Filter - South Region and hence these values are incorrect. Note how these aren't even 10 products, but rather just 8. To fix this, simply add Region to Context:

Upon doing this, we get the correct answer as : 

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

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

This is true. a Manual Sort lets you select a value and move it to the desired position, either by dragging it in the list or using the arrows to the right.

However, as soon as you choose some other type of sort - be it field, nested, or alphabetic, our custom created manual sort gets deleted/cleared.

You can combine two sets to compare the members. When you combine sets you create a new set containing either the combination of all members, just the members that exist in both, or members that exist in one set but not the other.

Combining sets allows you to answer complex questions and compare cohorts of your data. For example, to determine the percentage of customers who purchased both last year and this year, you can combine two sets containing the customers from each year and return only the customers that exist in both sets.

To combine two sets, they must be based on the same dimensions. That is, you can combine a set containing the top customers with another set containing the customers that purchased last year. However, you cannot combine the top customers set with a top products set.

Text, letter Description automatically generated

Graphical user interface, text, application Description automatically generated

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

Explanation

VERY IMPORTANT QUESTION FOR THE EXAM, PAY ATTENTION

1) To find the number of days between order date and shipping date, we will make use of a calculated field:

In the data pane, click on the dropdown arrow, and choose create calculated field.

Let's name this calculated field "ShippingDelay" (you can name it anything you want :) )

2) Use the DATEDIFF() function, and pass it the arguments as follows:

'day' depicts that we want to calculate the number of DAYS between the two dates. The first argument is 'start_date' which is the ORDER_DATE (day the order was placed), the second argument is 'end_date', which is the SHIP_DATE (date the order was shipped). So by subtracting as follows: SHIP_DATE - ORDER_DATE, we can find the delay in shipping.

Click OK.

3) You should now have a new measure as follows:

4) Phew! The hard part is done! Now let's filter by Market to include only LATAM:

5) Drag Country to the view, and the new calculated field 'ShippingDelay' to SIZE on the Marks Shelf as follows:

*You can also click on Show Text Labels to be sure that you're choosing the Largest value*

Clearly, Mexico has the highest Shipping Delay!

No, by default, animations are not enabled in Tableau.

We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.

Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.

When you author animations, you can choose between two different styles: simultaneous or sequential. Here are examples of each type.

1) Simultaneous animations

The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.

2) Sequential animations

Sequential animations take more time but make complex changes clearer by presenting them step-by-step.

To Animate visualizations in a workbook:

1) Choose Format > Animations.

2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:

For Duration, choose a preset, or specify a custom duration of up to 10 seconds.

For Style, choose Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.

3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.

Exporting the visualisation gives us a static view of the visualisation.

It is NOT possible to interact with it, use filters, or dynamically enter anything in a visualisation exported PDF.

In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer.

When you print an individual sheet to PDF, filters in the view are not included. To show filters, create a dashboard containing the sheet and export the dashboard to PDF. (IMPORTANT)

Explanation

Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.