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

QUESTION: 31

Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.
How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?

1
2
3
4

Answer(s): C

Explanation:

If you chose 2, then you were very close but probably didn't plot the actual Percent Difference on your view. ( One of the marks is just over the line).

Firstly, Drop the Week ID onto the column shelf, and convert it to continuous since we need both

Year and Quarter as mentioned in the question.

2) Next, Drop assortment to filters shelf so that we can focus on Electronics!

3) This should be your view now. Click on the Show Mark Labels icon as shown:
The final view is as follows, with 3 points below 0 ( i.e negative )

Reveal Solution Next Question

QUESTION: 32

Which of the following is not a Trend Line Model?

Linear Trend Line
Exponential Trend Line
binomial Trend Line
Logarithmic Trend Line

Answer(s): C

Explanation:

According to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau :
1) Linear Trend Line
2) Logarithmic Trend Line
3) Exponential Trend Line
4) Polynomial Trend Line
5) Power Model

Hence, the correct answer is BINOMIAL trend line which is not present in Tableau.
See the following image:

For more information, refer to: https://help.tableau.com/current/pro/desktop/en- us/trendlines_add.htm

Reveal Solution Next Question

Free Desktop-Specialist Exam Braindumps (page: 9)

QUESTION: 29

Explanation:

QUESTION: 30

Explanation:

QUESTION: 31

Explanation:

QUESTION: 32

Explanation:

Exam Discussions & Posts