Free Desktop-Specialist Exam Questions and Answers (Page: 6)

QUESTION: 26

Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

October
September
July
June

Answer(s): A

Explanation:

Follow along:

1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.
For sales, click on the pill -> choose Quick Table calculation -> Year over Year growth.

The view should now look like:

Reveal Solution Next Question

QUESTION: 27

Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

October
September
July
June

Answer(s): A

Explanation:

Follow along:

1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns

Shelf.
For sales, click on the pill -> choose Quick Table calculation -> Year over Year growth.

The view should now look like:

It is clear that October with -55.3% had the lowest Year on Year growth.

Reveal Solution Next Question

QUESTION: 28

Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map.
What was the Store count in 2017 for Texas (TX)? Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map.
What was the Store count in 2017 for Texas (TX)?

592,593
293,202
416,702
336,908

Answer(s): C

Explanation:

Since you need BOTH State and the YEAR, we need to use an Inner Join.
Follow the steps below:

Reveal Solution Next Question

QUESTION: 29

Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

$16,581
(Correct)
$147,950
$48,115
$33,768

Answer(s): A

Explanation:

Phew! Tricky one! You needed to use filters in this one.
Follow along:

2) Next, as the question mentions, we need to focus on the Assortment PHONE, the color WHITE, and the state of NEW YORK. -> so we use filters for this! i) First drag Assortment to Filters, and select only Phones :

ii) Next, drag Color to Filters and Choose only White:

iii) Next, drag State ID to Filters, and choose New York (NY):

And Voila! We have our answer as follows:

iv) Last, drag Sales to Label:

Reveal Solution Next Question

QUESTION: 30

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?

584
901
Correct)
205
660

Answer(s): B

Explanation:

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:

Reveal Solution Next Question

Tableau Desktop-Specialist Exam (page: 6) Tableau Desktop Specialist Updated on: 28-Jul-2025

QUESTION: 26

Explanation:

QUESTION: 27

Explanation:

QUESTION: 28

Explanation:

QUESTION: 29

Explanation:

QUESTION: 30

Explanation:

Tableau Desktop-Specialist Exam (page: 6)
Tableau Desktop Specialist
Updated on: 28-Jul-2025