Tableau TDS-C01 Practice Test - Questions Answers, Page 4

GDP / Population = GDP Per Capita

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

Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.

Follow the steps to get the correct answer : January 2018

We are talking about dates, so use the Time series sheet as follows:

Next, the following should be your view and clearly, January 2018 is the lowest point:

Read more about dates: https://interworks.com/blog/rcurtis/2017/01/30/tableau-deep-dive-dates-introduction-dates/

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: