When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?

• A.Data source Filter
• B.Extract Filter
• C.Context Filter
• D.None of the these

Comment: *

Name: *

Email: *

Verification: *

True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

• A.True
• B.False

Correct Answer: A

Explanation
Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.

Inner join

Left Join
Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.

Comment: *

Name: *

Email: *

Verification: *

What term is used to describe the following picture?

• A.Larger image
• B.Parameter
• C.Set
• D.Hierarchy
• E.Group

Correct Answer: C

Explanation
When you connect to a data source, Tableau automatically separates date fields into hierarchies so you can easily break down the viz. You can also create your own custom hierarchies. For example, if you have a set of fields named Region, State, and County, you can create a hierarchy from these fields so that you can quickly drill down between levels in the viz.

Comment: *

Name: *

Email: *

Verification: *

What is the one most important thing you should do after creating a Dual-axis chart?

• A.Synchronise the axis
• B.Change the colours
• C.Edit the labels
• D.Hide the axis

Correct Answer: A

Explanation
After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.

To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.
In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis.
If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.
In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.

Comment: *

Name: *

Email: *

Verification: *

Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?

• A.28.415%
• B.23.497%
• C.25.683%
• D.22.404%

Correct Answer: D

Explanation
Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations (percent of total) for this one.
1) Firstly, let's drag Country and to the Rows shelf, and year (discrete) to the Columns shelf.
Then, drag Publications to the Text Icon in the Marks Shelf. The following is our view:

Comment: *

Name: *

Email: *

Verification: *