QUESTION: 29 Exam Topic: 1, Exam Pool A

Connect to the "Global Superstore" data source and use the Orders table.
Which of the customer names are in the Top 20 by sales, calculate the profit ratio for these customers and find out who all are in the bottom 5 in profit ratio (within these customers)?

Sean Miller
Raymond Buch
Art Ferguson
Bart Watters

Answer(s): A,C

Explanation:

Right Click on the Customer Name -> Create -> Set

Create a calculated field:

Drop the Top 20 by Sales set, Customer Name to Rows.
Drop Sales and Profit Ratio to the view. Format the profit ratio so it will show the percentage.

Sort the Profit.

Reveal Solution Next Question

QUESTION: 30 Exam Topic: 1, Exam Pool A

View Related Case Study

How can we add Visualization in a tooltip?

Go to the Tooltip on the marks card, and click insert -> sheets
Go to the Worksheet menu, click on Tooltip and click Insert -> sheets
Go to the Format menu, click on Tooltip and click Insert -> sheets
Right Click on the view, Tooltip and add insert -> sheets

Answer(s): A,B

Explanation:

Only 1 and 2 options are correct.
For these types of questions, please take the help of the Tableau software during your exam.

Reveal Solution Next Question

QUESTION: 31 Exam Topic: 1, Exam Pool A

View Related Case Study

Connect to the "Significant Volcano Eruption" data source. How many volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year?

Answer(s): C

Explanation:

Add year and location filter as:

Drop Name, year, month to the rows. Change year and month to discrete from continuous.

So, 3 volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year.

You can also use the map view to get the results, here I added the month filter as well and drop the count of records to the text.

Reveal Solution Next Question

QUESTION: 32 Exam Topic: 1, Exam Pool A

View Related Case Study

Blend the Significant Volcano Eruption dataset with the Country population dataset using year and country. Find out which country is having 4 volcano eruptions in the year 1963 and what was the population of this country in the same year?

Indonesia and 95,055,669
Japan and 96,812,000
Indonesia and 9,103,406,453
Japan and 9,103,406,453

Answer(s): A

Explanation:

Add the Country population excel sheet as a New Data Source.
Select column 1960 to 2013, click on Pivot.

Rename the new fields as Year and population.
Go to Data ->Edit Blend Relationship
Click on Custom and Add

Ensure the blend relationship exists in Country & Country Name, and year & year between primary and secondary data sources.
Drop the year to the filters shelf and only enter 1963.

Drop Country and Number of Records / volerup(Count) field to the view. And drop population to the view from the secondary data source. Your view will look like this: