Pass the Tableau Desktop Certified Associate Desktop-Certified-Associate Questions and answers with ExamsMirror

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:

Here we have to use the Obesity View only, so let’s go to that sheet:

Click on go to sheet as per above.

Edit the State filter and select only North Carolina:

Duplicate this sheet as Crosstab

3 counties in North Carolina are having an obesity rate that is 8% below the regional obesity

rate.

Graphical user interface, text, application Description automatically generated

Note: For dashboard questions, I prefer to follow above approach wherever it is applicable. I

find it easy to get the answers.

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.

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 cup

2010 is the correct answer.

Refer section “Quality Metrics” athttps://help.tableau.com/current/pro/desktop/enus/

forecast_describe.htm

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

Go to the section- Phone layouts and the Default dashboard

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.

If customer first order is equal to the order date, then this is the new customer.

Create a calculated field to find the first order date:

Find If the order date is equal to the day of first purchase for that customer, flag that row as a

'New Customer'

Find the unique customers:

Drop the Order date to filter shelf and select the year 2014 to find out the new customer

acquired in 2014.

Drop New Customer field to Rows and Unique customer field to Text marks card.

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

Remote field cannot be renamed by any means from Tableau