Desktop-Certified-Associate Tableau Desktop Certified Associate Exam Questions and Answers

Explanation:

Go to Dashboard->Actions and create the go to sheet action

Graphical user interface, application Description automatically generated

Explanation:

Add Product Name filter that contains the word Avery

Graphical user interface, text, application, email Description automatically generated

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.

Graphical user interface, text Description automatically generated

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

Mark the Include 'Other' Checkbox.

Graphical user interface, text, application Description automatically generated

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.

Graphical user interface, text, application, chat or text message Description automatically generated

Explanation:

Drop the Orders Date to the Columns shelf and change it to the Month Date Value and drop the profit to the rows shelf. Your view will look like this:

Graphical user interface, text, application Description automatically generated

Go to the Analytics tab and drop the Forecast to your view.

Right-Click on the view, Select Forecast -> Forecast Options. Change the Ignore last to 0 months,

Graphical user interface, text, application Description automatically generated

$35,152 is the correct answer.

Graphical user interface, chart, line chart Description automatically generated

Drop the country field to the view and also to the filter and select Australia.

Drop the State to the detail marks card.

Create the Unique Customer field to the Label.

Your view will look like this:

Northern Territory has the minimum unique customers – 19.

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

First, create a set using the Product Name. Select the Top condition as:

Drop this Set to the filters shelf and select IN only.

Drop this Set to the filters shelf and select IN only.

Drop the Category, Top 10 profitable products and Product Name to the view:

Create a bar chart using field college and Math. Change the Math aggregation to AVG.

Drop the Verbal field to Y axis, to create the combined axis chart. And change the aggregation

to Avg.

Follow the same for Writing field.

Now from the Analytics menu, drop the Distribution band to the view, select the scope as

entire table, and select the value as 70 percentiles.

Your view will look like this:

70 percentiles are 547.8

Business and public affairs have all the individual subject values lesser than 547.8.

Blend is the left outer join after aggregation at the level of granularity.

Drop the Sales to the Rows and disaggregate the values. (Go to Analysis -> uncheck Aggregate

measures)

From Show Me, Select Box and Whisker plots. And drop the Ship mode to the columns.

Hover on each of the boxes:

Median for the First Class and Same Day ship modes are 84.

Explanation:

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

Graphical user interface, text, application, website Description automatically generated

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

Graphical user interface, text, application Description automatically generated

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)

Graphical user interface Description automatically generated

Final view:

Graphical user interface, text, application, chat or text message Description automatically generated

Explanation:

Graphical user interface Description automatically generated

Explanation:

Union - The data to combine has the same structure but consists of data of different years.

Blend - The data to combine is at a different level of detail.

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.