Tableau Desktop-Certified-Associate Tableau Desktop Certified Associate Exam Practice Test

Explanation:

All are false here.

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

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:

Add year and location filter as:

Graphical user interface, application Description automatically generated

Graphical user interface, text, application Description automatically generated

Drop Name, year, month to the rows. Change year and month to discrete from continuous.

A picture containing chart Description automatically generated

So, 3 volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year.

You can also use the map view to get the results, here I added the month filter as well and drop the count of records to the text.

Map 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:

Drop the Date to the columns and select the continuous month. Drop New Deaths to rows.

Click on the Show/Hide card and enable the Summary Card.

Chart, line chart Description automatically generated

You will see the Summary Card on the right, if Excess Kurtosis is not enabled, click on the drop-down and select the Excess Kurtosis.

Graphical user interface, application 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.

Calculate the Profit Ratio:

Create a LOD expression -> for each order date if profit ratio is greater than 25% returns 1.

Drop the Order date to Rows and drill-down it to Quarters.

Drop the profit ratio >.25 field to Text:

Approach 1 – Using Groups

Drop the Customer ID to the Rows.

Add sub-category to the filter and select phone.

Add Order date to the filter and select the year 2014.

Select all the customers and click on paper clip icon to create the group.

So here we got all the customers who have purchased any product in the Phones subcategory

in 2014.

Edit the group and select Include other

Clear the filter shelf, and again add Order date to the filter and select 2015.

Drop Sales to the Text.

Add ‘Percent of Total’ Quick Table Calculation to the Sales field.

Your view will look like this:

Approach 2 – Using LOD

Create a LOD expressions as:

It will return 1 for the customers who have purchased any product in the Phones sub-category

in 2014. For others, it will return 0.

Drop this field to the Rows and add Order date to the filter and select the year 2015.

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

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

bkimages_coordinates.htm#:~:text=Right%2Dclick%20anywhere%20on%20the,Annotation

%20dialog%20box%2C%20click%20OK.

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:

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

Explanation:

Measures are by default aggregated. We can change measures to dimensions if we want disaggregate that field.

Explanation:

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

Explanation:

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

Explanation:

When you use a left join to combine tables, the result is a table that contains all values from the left table and corresponding matches from the right table.

Refer Join Types: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm