Tableau Desktop Certified Associate Practice Test - Questions Answers, Page 10

Create a left outer join, so that we can calculate the percentage of the returned orders

Create a calculated field "% of returned orders":

Drop the Order Date to the filters shelf and select the year 2013

Drop the Region to the rows and % of returned orders to the Text:

We can rename the field from the metadata grid, but not the remote fields.

Remote field cannot be renamed by any means from Tableau

Create the Calculated field 'Math Performers':

Drop the Math Performer field to the Rows and drop gender to filter, select 'Men'

Drop the Number of Records (if tableau version prior to 2020.2) to the Text

Or

Drop the Education.csv(Count) (tableau version 2020.2 and after) to the Text

Apply 'Percent of Total' Quick table calculation to the field on the Text marks card:

Select the Extract connection and click on Edit as shown:

If you have single table on the canvas, then Multiple tables option remain disabled:

If you create a join, only then Multiple tables option will be enabled:

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:

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.

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

In WorldCupMatches table, we have the information of Away goals, and in the WorldCups table, we have the information of the Winner team and goal scored.

In WorldCups, there is only row for each year. But in WorldCupMatches, there is a separate row for each match. This is the perfect example to use blend as here we need to first aggregate the data from WorldCupMatches table.

Let's establish the blend relationship between these two data sources, on the basis of Country and Year.

Let's use WorldCups as the primary data source, so add the field from this data source to the view. Drop Year to Rows and change it discrete. Drop Country and Winner field as well to the rows.

In WorldCupMatches data source, create a calculated field :

Drop this field to the Text, and format it so that it will be shown in percentage.

Out of the given options, only in 1934 host country won the world cup2010 is the correct answer.

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: