Pass the Tableau Desktop Specialist Desktop-Specialist Questions and answers with ExamsMirror

Explanation

Measures contain numeric quantitative values hence that option is incorrect.

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

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

With dimension filters in Tableau, you can use several filter modes, including "Multiple Values (drop-down)" which allows users to select one or more values from a drop-down list of all the dimension's members. Another mode is "Wildcard Match," which lets users filter the view by typing in a text box to match dimension members that contain the typed string. These filter types are particularly useful for string or categorical dimensions where users need to search or select specific members to display in the view.

Explanation

Chart Description automatically generated

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).

Explanation

We need to use the concept of Groups for this question. Follow along:

1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:

2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:

3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:

We can see the answer already : 23.386% in the view above (even before grouping!)

4) Finally, we get the following view and our answer:

Treemaps use automatically generated sizes that cannot be resized by using the Marks card. A treemap is a type of visualization that shows hierarchical data as a set of nested rectangles. Each rectangle represents a dimension member and its size is proportional to a measure value. Tableau automatically calculates the size of each rectangle based on an optimal aspect ratio for readability and comparison. You cannot manually adjust the size of each rectangle by using the Marks card or any other option in Tableau10 The other chart types do not use automatically generated sizes that cannot be resized by using the Marks card. Pie charts use angles to show proportions of a whole, not sizes. Histograms use bins and frequencies to show distributions of a measure, not sizes. Area charts use filled areas to show trends over time or categories, not sizes. You can adjust the size of these chart types by using the Marks card or other options in Tableau

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

The following showcase how you can show mark labels. Using the Sample Superstore dataset:

1) Let's create a Bar chart showing the sales for each sub-category:

2) Now you can show labels by:

2.1) Click on Show Mark Labels Icon in the Toolbar ( easiest )

2.2) Drag Sales to the Text icon in the Marks Card:

2.3) Click on Analysis -> Show mark labels from the Tableau menu bar:

Explanation

For relational data sources, dates and times are automatically placed in the Dimensions area of the Data pane and are identified by the date or date-time icon. For example, the Order Date and Ship Date dimensions from an Excel data source are shown below:

When you place a relational date on a shelf, the field name is automatically modified to reflect the default date level. Tableau defines the default date level to be the level at which there are multiple instances. For example, if the date field includes multiple years, the default level is year. However, if the date field contains data for just one year but includes multiple months, then the default level is month.

Explanation

A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures.

Therefore, we need at least 2 measures for creating bullet graphs.