Download Tableau.TDS-C01.VCEplus.2023-08-21.55q.vcex

If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind. To reach the correct answer, follow the steps below:1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well! Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!      The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October   

Not too tough. Follow along the steps:Drag Color to Filter and choose Red:     3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:   And your final view will look like :  

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:

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.

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

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 dragAssortmentto Filters, and select only Phones :   ii) Next, drag Color to Filters and Choose only White:   iii) Next, dragStateIDto Filters, and choose New York (NY):     And Voila! We have our answer as follows:   iv) Last, drag Sales to Label:

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:    

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 )   

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 BINOMIALtrend 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

It is possible in Tableau to use a sheet within a story directly. Moreover, in Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case. At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.