Free Practice Questions for Tableau Desktop-Specialist Exam

When creating a group by selecting headers in a Tableau view, the newly created grouped dimension replaces the original dimension field on either the Rows or Columns shelf. This grouping action aggregates the selected headers into a single group, and this new group dimension is automatically placed in the view, replacing the original dimension. This functionality allows for more simplified and customized categorization within the data visualization, enhancing the ability to analyze and interpret data according to specific groupings.

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.

Of course! As an example, see below:

1) Using the Sample Superstore data, let's plot a bar chart showing the Sales for each Category:

Observe that we have 3 marks - Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark , and so on for all charts.

1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark - a single continous axis, but 3 different marks (Technology, Furniture and Office supplies ) on the x-axis.

2) Now let's add subcategory to the view as well (another dimension):

Observe that the number of marks has increased - i.e the number of Bars.

Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)

Explanation

Chart Description automatically generated

You can add reference lines, bands, distributions, or (in Tableau Desktop but not on the web) box plots to any continuous axis in the view.

Reference Lines - You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line.

From the official Tableau documentation:

You can union your data to combine two or more tables by appending values (ROWS) from one table to another. To union your data in Tableau data source, the tables must come from the same connection.

Graphical user interface, text Description automatically generated

By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter (Option stating - To create a dependent filter eliminated here). Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.

You may create a context filter to:

1) Improve performance – If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.

2) Create a dependent numerical or top N filter – You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.

For example, suppose you’re in charge of breakfast products for a large grocery chain. Your task is to find the top 10 breakfast products by profitability for all stores. If the data source is very large, you can set a context filter to include only breakfast products. Then you can create a top 10 filter by profit as a dependent filter, which would process only the data that passes through the context filter.

Graphical user interface, application Description automatically generated

It contains all the measures in your data, collected into a single field with continuous values - This is the definition for 'Measure Values'.

All others are True w.r.t. Measure Names!

The Measure Names field contains the names of all measures in your data, collected into a single field with discrete values.

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

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

Explanation

After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.

Graphical user interface, chart, line chart Description automatically generated

To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.

In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis.

If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.

In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.

Graphical user interface, application Description automatically generated

The only incorrect option is - Click on Dashboard in the Menu bar, select Tooltip, and then use the italics option.

This option doesn't exist. See below:

The rest of the options do exist, and therefore are correct:

Graphical user interface, text, application Description automatically generated