Extract can't be created in which of the scenario?
Answer(s): B
A blend is worksheet-specific, so you cannot create the extract while creating a blend.
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?
Answer(s): A,C,D
Drop Region at the filter and Select CanadaDrop Profit to columns and Sub-Category to RowsThen 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.
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?
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.
Connect to the "Covid data" source. What is the percentage increase in the new cases from July 2020 to Jan 2021?
Answer(s): C
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
To create this view, what all you have to do from the following options? Larger image
Answer(s): B,D
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 prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the Desktop-Certified-Associate content, but please register or login to continue.