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

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

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:

The upper whiskers extends to 1.5 * IQR

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

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

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

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

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.

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:

Explanation:

Find the minimum order date for each customer

Graphical user interface, text, website Description automatically generated

Drop the order date, Min Order date, and Sales to the view

A picture containing graphical user interface Description automatically generated

$2,263,137 is the sales value in 2013 of the customers who placed their first order in 2013.

Explanation:

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

Explanation:

All are false here.

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

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:

Create a filter on date field and select only July 2020 and Jan 2021.

Graphical user interface, application Description automatically generated

Drop Date Month Discrete to Columns and New cases to the Text.

Right-Click on New Cases field and Quick Table Calc ->Percent Difference

Graphical user interface, application Description automatically generated

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

Explanation:

Select California State from the Map

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:

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

Explanation:

Create an inner join between Orders and Returns table using Order ID

Graphical user interface, application Description automatically generated

Create a calculated field to find the unique order.

Graphical user interface, text, application Description automatically generated

Drop Region, Ship Mode, and Category to Rows. And drop 'countd order' field to Text. The final view would look like this:

Graphical user interface, text, application Description automatically generated

Explanation:

Tableau automatically associates discrete fields with categorical palettes

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