Which of the following are valid ways to add Totals to a view?

• A.Using the Data Pane
• B.Using the Analytics Pane
• C.From the Analysis Tab in the Menu bar on top
• D.Using the Marks shelf

Correct Answer: B,C

To add totals to a view using the Analytics pane:

Also, you can add totals from the Analytics tab in the Menu above:

Comment: *

Name: *

Email: *

Verification: *

When viewing quick table calculations, such as Percent Difference From, that use a value in the previous column, what will be the first data value in the visualization?

• A.Null
• B.The current value
• C.Zero(O)
• D.Duplicated from the nearest column

Comment: *

Name: *

Email: *

Verification: *

Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

• A.If we want a static view of the visualisation.
• B.If we want to use filters in the visualisation.
• C.If we want to interact with the visualisation.
• D.If we want to dynamically enter parameters to the visualisation.

Comment: *

Name: *

Email: *

Verification: *

Yes or No: The number of marks will increase when you increase the number of Dimensions in a view

• A.No
• B.Yes

Correct Answer: B

Of course! As an example, see below:
1) Using the Sample Superstore data, let's plot a bar chart showing the Sales for each Category:

Observe that we have 3 marks - Each bar in a bar chart is called a mark. Similarly, each point in a scatter plot is also a mark , and so on for all charts.
1 row by 3 columns means that clearly on the y-axis (Sales), we have only a single mark - a single continous axis, but 3 different marks (Technology, Furniture and Office supplies ) on the x-axis.
2) Now let's add subcategory to the view as well (another dimension):

Observe that the number of marks has increased - i.e the number of Bars.
Also, notice we now have 1 row and 17 columns. Simply because 1 row = Sales (on the y-axis), and on the x-axis, we have 17 different columns (i.e product sub categories!!)

Comment: *

Name: *

Email: *

Verification: *

Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?

• A.9
• B.7
• C.10
• D.8

Correct Answer: C

Follow along to reach the correct answer:
1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:
Click on Date in the Column shelf and convert it to continuous month :

2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:

3) Finally, click on the Show mark Labels icon:

4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:

Comment: *

Name: *

Email: *

Verification: *