Free Desktop-Certified-Associate Exam Braindumps (page: 6)

Page 5 of 28
View Related Case Study

Connect to the "Global Superstore" data source and use the Orders table. Create a bar in bar chart and compare the profit against the target profit for Canada Region. Consider target profit is 30% of the sales.
Which of the following sub-categories has met or exceed the target profit?

  1. Tables
  2. Paper
  3. Labels
  4. Copiers

Answer(s): A,C,D

Explanation:



Drop Region at the filter and Select Canada
Drop Profit to columns and Sub-Category to Rows
Then drop the target profit to profit axis, it will create the combined axis chart.



Now drop the Measure Names field from the Rows to the Color Marks Card.



Go to the Analysis menu -> Stack Marks -> Off (so that your both profit and target profit bars will start from 0)



Tables, Labels and Copiers sub-categories has met or exceed the target profit.



View Related Case Study

Connect to the "Global Superstore" data source and use the Orders table. Create a view using Profit and Sales. Find out which sub-category is above the profit median but below the sales median value?

  1. Appliances
  2. Binders
  3. Storage
  4. Tables

Answer(s): B

Explanation:

Drop Sales to columns and profit to rows, and Sub-Category to details.
Add two reference lines, one on the sales axis:



Add similarly on profit axis as well.
Out of the following options, only the Binders sub-category is above the profit median but below the sales median value.



View Related Case Study

Connect to the "Covid data" source.
What is the percentage increase in the new cases from July 2020 to Jan 2021?

  1. 118.50%
  2. 125%
  3. 113.50%
  4. 98%

Answer(s): C

Explanation:

Create a filter on date field and select only July 2020 and Jan 2021.

Drop Date Month Discrete to Columns and New cases to the Text. Right-Click on New Cases field and Quick Table Calc ->Percent Difference





View Related Case Study

To create this view, what all you have to do from the following options? Larger image

  1. Add the Columns Totals on Top from Analysis Menu
  2. Go to the border in format menu and then go to the Rows tab and update the Row Divider settings
  3. Go to the border in format menu and then go to the Columns tab and update the Column Divider settings
  4. Drop the measure to the color marks card

Answer(s): B,D

Explanation:

Option 1 - It is not valid, as we are not showing Columns Totals on Top. Option 3 - It is not valid, as we are modifying the row divider settings and not the column divider settings.
Rest are true.






Post your Comments and Discuss Tableau Desktop-Certified-Associate exam with other Community members:

Desktop-Certified-Associate Discussions & Posts