How do you identify a continuous field in Tableau?

• A.It is identified by a blue pill in the visualization
• B.It is identified by a green pill in a visualization
• C.It is preceded by a '=#' symbol in the data window
• D.It is preceded by a 'Abc' symbol in the data window

Correct Answer: B

When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.

Comment: *

Name: *

Email: *

Verification: *

Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

• A.111,060
• B.1,461
• C.112,256
• D.1,222

Correct Answer: C

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

Comment: *

Name: *

Email: *

Verification: *

Which of the following are compelling reasons to use a Stacked Bar Chart?

• A.To visualize parts of a whole
• B.To easily visualize trends over time
• C.To be able to visualize complex information with fewer bars /
  marks
• D.To visualize each discrete category using a separate bar.

Correct Answer: A,C

Stacked bar charts will usually have lesser number of bars compared to a normal bar chart:
Normal bar chart - 9 bars

Stacked Bar Chart - 3 bars

We can easily see a 'part-of-a-whole' methodology being used here as well - we are seeing the breakdown of Segments within each Category.
To easily visualize trends over time - This is the definition of a line chart.
To visualize each discrete category using a separate bar - This can be accomplished using a simple bar chart, why use a stacked one?

Comment: *

Name: *

Email: *

Verification: *

True or False: All rows from both tables are returned in an INNER JOIN

• A.True
• B.False

Correct Answer: B

The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. Consider 2 tables "Orders" and "Customers".
If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!

Comment: *

Name: *

Email: *

Verification: *

Which of the following are valid ways to export a dashboard with multiple visualisations as an image?

• A.Click on Worksheet in the Menu bar followed by Export, then choose Image
• B.using the floating export worksheet option on the Dashboard
• C.Right click on the dashboard, and choose Copy, then image.
• D.Click on Dashboard in the Menu bar followed by Copy Image

Correct Answer: D

Only 1 option is correct -
Click on Dashboard in the Menu bar followed by Copy Image

Right click on the dashboard, and choose Copy, then image - Try doing this, you will end up copying just one of the worksheets not the entire dashboard Click on Worksheet in the Menu bar followed by Export, then choose Image - Again, try doing this. You will end up copying just one of the worksheets not the entire dashboard Using the floating export worksheet option on the Dashboard - No such option exists

Comment: *

Name: *

Email: *

Verification: *