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?
Answer(s): A
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:
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?
Follow along:1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the ColumnsShelf.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.
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)?
Answer(s): C
Since you need BOTH State and the YEAR, we need to use an Inner Join.Follow the steps below:
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?
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:
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?
Answer(s): 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:
Share your comments for Tableau TDS-C01 exam with other users:
thank you for this tableau dumps . it will helpfull for tableau certification
for question #118, the answer is option c. the screen shot is showing the drop down, but the answer is marked incorrectly please update . thanks for sharing such nice questions.
it is very useful, thank you