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

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 Institution 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: *

When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?

• A.Monitor, Default, Phone, Tablet
• B.Phone, Tablet, Laptop, Desktop
• C.Default, Phone, Tablet, Desktop
• D.Phone, Monitor, Laptop, Default

Correct Answer: D

Explanation
The following options are available in the Device preview section when creating a Dashboard:

Comment: *

Name: *

Email: *

Verification: *

What do the colours Blue and Green represent in Tableau?

• A.Discrete and Continuous
• B.Measures and Dimensions
• C.Continuous and Discrete
• D.Dimensions and Measures

Correct Answer: A

Important question! If you selected Dimension and Measure, don't worry! It is a very common mistake. But we're here to learn aren't we?
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: *

Is it possible to make a Measure discrete?

• A.No
• B.Yes

Correct Answer: B

Of course! Follow along:
Right click on any measure, and choose Discrete as shown:

Once you do this, the green pill becomes blue in colour, indicating that it is now Discrete!

Comment: *

Name: *

Email: *

Verification: *

Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

• A.68,620
• B.74,683
• C.37,455
• D.46,493

Correct Answer: C

If you answered this question quickly and correctly, you're well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back!
To create a dual axis chart for the problem mentioned:
1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:

2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:


3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:

4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.

Now the chart looks like this:

Now we change the Profit chart type to line:


5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'

And, our final view and answer is:

Comment: *

Name: *

Email: *

Verification: *