Tableau Desktop Certified Associate Practice Test - Questions Answers

Find out how many gold medals each athlete won in the 2008 Olympics

Drop Athlete to Rows and 2008 golds to the Text. Drop gold medals to the view. Your view will look like this:

Now we need work on 'won at least 4 golds in 2012 Olympics'

Drop years to filters and select 2012.

Drop Gold Medals to filter and mention 4 in range of values (as we need to find athletes who won at least 4 gold medals)

Final view:

Find the minimum order date for each customer

Drop the order date, Min Order date, and Sales to the view

$2,263,137 is the sales value in 2013 of the customers who placed their first order in 2013.

Create an inner join between Orders and Returns table using Order ID

Create a calculated field to find the unique order.

Drop Region, Ship Mode, and Category to Rows. And drop 'countd order' field to Text. The final view would look like this:

Here we have created the Fixed LOD expression and fixing the order date. If profit is greater than 0 it means profitable day/month/quarter/year depends on what you need to find. If profit < 0 then not profitable.

Drop the Order Date to the rows and drill-down it till months.

Drop the profitable days field to the Text, aggregated as SUM. So it will find a number of days.

Only by using Calculated fields you can create a variable size bin.

Cube data sources can only be used as the primary data source for blending data in Tableau.

All others are true.

Refer: https://help.tableau.com/current/pro/desktop/en-us/cubes.htm

By using the Measure Name field, we get multiple measures on a single axis

Click on the State/Province list, and select the State. So Tableau will recognize the city as part of the states in the Country/Region United States.

Add Product Name filter that contains the word Avery

Drop the Customer ID to the rows, so these are all customers who have purchased the product contains the word Avery.

Select all these Customers and create a group.

Now, right-click on the Customer ID (group) and click on Edit Group

Mark the Include 'Other' Checkbox.

Now, you have two members in your group. First, one of those who purchased any product contains the word Avery, and the other ones are the rest of the customers.

Remove the Product Name from filters.

Drop the Sales to the Text, and right-click on Sales and Select Quick table calculations -> Percent of total.