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

Explanation:

Even if you don't select the target filters, your filter action will work. Rest all you need to provide so that it will work.

Graphical user interface Description automatically generated

Explanation:

Select New York State, you are getting only 3 products, and not 5.

Timeline Description automatically generated

You need to add State as a Context filter in the Top 5 profitable products View. For that, go to the Top 5 profitable products sheet. (click on small arrow)

Chart, bar chart Description automatically generated

Select Add to Context on the State filter

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

A picture containing graphical user interface Description automatically generated

Explanation:

Refer to Nested Sort section:

Explanation:

It is recommended to create multiple table extracts when row-level security needs to be enforced.

Refer:

Right Click on the Customer Name -> Create -> Set

Graphical user interface, text, application Description automatically generated

Create a calculated field:

Graphical user interface Description automatically generated

Drop the Top 20 by Sales set, Customer Name to Rows.

Drop Sales and Profit Ratio to the view. Format the profit ratio so it will show the percentage.

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

Sort the Profit.

Table Description automatically generated

Explanation:

Drop Order Date to the Columns and change it to continuous month. Drop sales to the rows.

Go to Analytics and drop the trend line. Check for all trend lines, Linear is having the lowest R Square.

Chart, line chart Description automatically generated

Explanation:

Drop Sector to columns and Funded Amount to Rows.

From Analytics, drop the Median with Quartiles to your view or drop the reference line, select the Median.

Your view will look like this:

Chart, bar chart Description automatically generated

Here, the Clothing funded amount is exactly similar to the Median.

Explanation:

{ FIXED [Category] : SUM([Profit])} - It calculates the profit of each category. In our view, all the profits values are the same, so it is not the right answer.

{ FIXED [Region] : SUM([Profit])} - It calculates the profit of each region.

{SUM([Profit])} is equivalent to {FIXED : SUM([Profit])}. It is the table level scope, which means this is the profit of the entire dataset.

Explanation:

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

Graphical user interface, application Description automatically generated

Explanation:

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

Skewness is .42

Graphical user interface, chart Description automatically generated

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:

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

Refer:

Create the calculated field:

Drop the carrier name to the view and % of delayed flights to text.

We only have 2013 data, so filter won’t make a difference:

The upper whiskers extends to 1.5 * IQR

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