Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark. (Sheet 2) Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?
(Ignore any nulls / unknowns)

• A.76.25
• B.65.67
• C.68.77
• D.4.87

Correct Answer: A

Pretty common question on the Tableau Desktop Specialist exam.
1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:

2) Now, for sheet 2 - Drag nationality to the view, and gold to the size mark in the Marks shelf.
NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:

3) Now, let's create a dashboard, and use both these sheets in it:

4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:

Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:

Comment: *

Name: *

Email: *

Verification: *

Is SUM a table calculation?

• A.Yes
• B.No

Correct Answer: B

SUM is an aggregate function, not a table calculation!
A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.
The most common Table calculations are:
Running Total
Percent Difference
Difference
Percent of Total
Rank
Percentile


These can be calculated using : Table(across), Cell, or Specific dimensions!

Comment: *

Name: *

Email: *

Verification: *

Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?

• A.584
• B.901
• C.Correct)
• D.205
• E.660

Correct Answer: B

Follow along the steps below:
Drag Assortment and Year ID to the column shelf, and Item Number ID to the row shelf. Next, drag Sales to the Text label to create a cross-tab as below:

Comment: *

Name: *

Email: *

Verification: *

True or False: The Highlighting action can be disabled for the entire workbook.

• A.True
• B.False

Correct Answer: A

Yes, it is possible to disable highlighting for the entire workbook.

For more information : https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm

Comment: *

Name: *

Email: *

Verification: *

How would you calculate GDP per capita in Tableau?

• A.SUM([GDP]/[POPULATION])
• B.SUM([Population]/[GDP]])
• C.SUM([GDP]*[POPULATION])
• D.SUM([GDP]) / SUM([Population])

Correct Answer: D

GDP / Population = GDP Per Capita

Here Sum is a function, / and + are operators. On the bottom there are comments.

Comment: *

Name: *

Email: *

Verification: *