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

Explanation :

Graphical user interface, application Description automatically generated

Drop Region at the filter and Select Canada

Drop Profit to columns and Sub-Category to Rows

Then drop the target profit to profit axis, it will create the combined axis chart.

Chart, bar chart Description automatically generated with medium confidence

Now drop the Measure Names field from the Rows to the Color Marks Card.

Chart, bar chart Description automatically generated

Go to the Analysis menu - > Stack Marks - > Off (so that your both profit and target profit bars will start from 0)

Graphical user interface Description automatically generated with medium confidence

Tables, Labels and Copiers sub-categories has met or exceed the target profit.

Chart Description automatically generated

Explanation :

Refer to Nested Sort section: https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sorting_computed_howto.htm

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.

Explanation :

IF MIN ([dimension]) = MAX ([dimension] ) THEN MIN ([dimension]) ELSE "*" END

Refer: https://kb.tableau.com/articles/howto/when-to-use-the-attribute-attr-function

Explanation :

Select California State from the Map

Explanation :

Add the Latitude to Rows and Longitude to columns. Or double click on these fields.

Don't use Latitude (generated)/Longitude (generated) fields.

Drop Location to filter and select 'Alaska Peninsula'

Drop Name to the Label Marks card.

Your view will look like this:

Map Description automatically generated

Use the radial selection tool to find the number of volcano eruptions that took place within 30 miles of the Black Peak volcano. You need to zoom-in first, only then you would be able to find the distance using a radial selection tool.

A picture containing chart Description automatically generated

There were no eruptions that took place with 30 miles of Black Peak.

Explanation :

Graphical user interface Description automatically generated

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 :

Drop the Latitude and Longitude fields to Rows and Columns shelf respectively. Or double click on these fields.

Drop the Location field to Filter shelf, select the Location as Colombia.

Drop the Name field to the Label.

To show the cities go to the Map - > Map layer and Check the Cities.

Graphical user interface, text, application Description automatically generated

Drop the Deaths and Year fields to the Tooltip. Now your view looks like this:

Map Description automatically generated

Zoom-in the map, you will find Purace is the nearest one in the Popayán city and Dona Juana was having 55 deaths.

Map Description automatically generated

Explanation :

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

Graphical user interface, application Description automatically generated

Explanation :

Measure Names is Tableau generated field, so you cannot rename it.

Explanation :

Enable the Summary Card from Show/Hide menu as shown:

Skewness is .42

Graphical user interface, chart Description automatically generated

Explanation :

Create a Calculation to get the first alphabet of the customer name.

Graphical user interface, text, application Description automatically generated

Now drop the First Alphabet field to Rows and Quantity field to the Text on the Marks card. Change the aggregation from SUM to AVG. Your view will look like this:

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

Explanation :

Refer to the quick comparison of data blending and custom geocoding -

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

Explanation :

Graphical user interface, application, table Description automatically generated

Explanation :

Connect to the "Life Expectancy at birth" excel file, drag Data_20th Century sheet to the canvas. If you find data columns are not correct.

Graphical user interface, application Description automatically generated

Use the data Interpreter, it will correct the data.

Graphical user interface, text, application Description automatically generated

Select the column 1960 to 2000. And Click on the Pivot option

Graphical user interface, text, application Description automatically generated

Rename the two new columns as 'Years' and 'Life Expectancy'

Graphical user interface, application Description automatically generated

Create a Union by dragging the sheet Data_21st Century to Data_20th Century, once you see the orange block for union.

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

Now, select column 2001 to 2013 and Select Add data to Pivot.

A picture containing graphical user interface Description automatically generated

Select Country and Country Name field, Merge these fields.

Graphical user interface, application Description automatically generated

Rename the merged field as Country.

Let's create the view.

Drop the country to the Filters and Select New Zealand. Drop the years to the columns and 'Life Expectancy' to the Text marks card. Change the aggregation to Avg (it won't make a difference here).

Right-Click on Life Expectancy - > Quick Table Calc - > Moving Average

Again, right-click on it and edit the table calculation.

Graphical user interface, application Description automatically generated

Update the values as:

Graphical user interface, application, Word Description automatically generated

Result is:

Graphical user interface, application, Word Description automatically generated

Explanation :

While creating Bar in bar chart, we turn off the stacked marks so that both the bars will start from 0.

Explanation :

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

Custom geocoding means that you assign latitude and longitude coordinates to your locations

so Tableau can plot them accurately.

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

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.

{ Exclude [City] : SUM([Sales] )} = > using this calculation we can exclude the City dimension

from all the dimensions present in the view. So here SUM(sales) would be the aggregation of

sales in the state level only, even though city field is available in the view.

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

Drop the Product Name to the filters and Select Top 10 based on Sum of Profit.

Drop the Product Name to the Rows and Profit to the Text.

Drop the Market to the filter and select the Europe.

Your view will look like this:

Here, you are getting only 9 products.

Add Market filter to the context so that the Product Name dimension filter will be executed

after the Market filter.

View:

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.

As per the Tableau order of operation, dimension filter is applied before table calculation is

computed. However, fixed LOD is executed before the dimension filter. That’s why total sales

are showing different results.

Reference - https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm

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 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.