Full Access Tableau TDS-C01 Tutorials

This is a tricky question often asked in the exam.

If we drag a new measure to the row shelf, the following happens:

We now have 2 rows, and the same 7 columns for both these rows. Therefore, 2x7 = 14 marks!

Graphical user interface, chart, bar chart Description automatically generated with medium confidence

But if we drag the same measure to the column shelf, we have just 1 row and a chart created for each of the columns. So (1x7) = 7 marks!

Graphical user interface, text, application Description automatically generated

Reference and notes: 

For Standard Deviation and Variance, we don't need to use quick table calculations, since they are available by default. See below:

However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.

Explanation

A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures.

Therefore, we need at least 2 measures for creating bullet graphs.

Explanation

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