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

Explanation:

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

Explanation:

Graphical user interface, application, table Description automatically generated

Explanation:

Find out the distinct orders for each customer

Graphical user interface, text, application Description automatically generated

Move this field from Measure to Dimension.

Drop this field to the Columns Shelf and drop customer ID to Rows, aggregate the Customer ID using CountD, and drop this field to Label as well. Your view will look like this:

Chart Description automatically generated

29 distinct customers have made 6 orders.

Bar-in-Bar Chart and bullet graphs both are used to compare the measures against goals.

When you add a table calculation, you must use all dimensions in the level of detail either for

partitioning (scoping) or for addressing (direction).

Refer:https://help.tableau.com/current/pro/desktop/enus/

calculations_tablecalculations.htm

The upper whiskers extends to 1.5 * IQR

The length of the upper whisker is upper hinge + 1.5 * IQR.

Drop the year to the Columns and change it Discrete. Drop the matches played to the Rows.

Go to the Analytics menu, drop the Distribution band to the view. Select scope as entire table.

Value Computation should be:

Your view will look like this:

Drop the Country field to the view.

Drop the Region to the filters shelf and select Europe & Central Asia.

Drop the GDP per capita to the label and change the aggregation to Avg.

Create a calculated field to compute the contribution of verbal marks in percentage:

Select the Total Score field and using Show me create a histogram.

Edit the Total Score(bin) and provide the Size of bins as 100:

Drop the % Verbal field to the Label, your view will look like this:

Chart, histogram Description automatically generated

Explanation:

Left join the Orders and Returns table

Diagram Description automatically generated

Number of orders returned will be order ID from the returns table divide by total orders

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

Drop the customer name and ret order field in the view.

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

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

Explanation:

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

Here, the Location is in a primary data source, and the population field is in a secondary data source.

So the answer is FALSE.

Explanation:

Using Analytics pane:

Graphical user interface, application Description automatically generated

Right Click on Axis and Add Reference Line:

Graphical user interface, application Description automatically generated

Explanation:

First, find the distinct sports for each country:

Graphical user interface Description automatically generated with medium confidence

It will be created as a Measure, move this to Dimension

Get the distinct countries:

Graphical user interface Description automatically generated with medium confidence

drop these columns to the view, final view will look like this:

The X-axis represents a number of distinct sports. As the data set contains data from 2000 to 2012, so even if you don't include the filter, your answer would remain the same.

Chart Description automatically generated