Analytics-DA-201 Exam Dumps : Salesforce Certified Tableau Data Analyst

To filter the table to show the members of the Top10 set and the Bottom10 set, you need to do the following steps:

Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Disciplines worksheet.

Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the disciplines, sales, and profit for each salesperson.

Click on the drop-down arrow next to Salesperson on the Filters shelf. This will open a menu that allows you to filter by different criteria.

Select Set from the menu. This will show you the sets that are available for the Salesperson field. You will see Top10 and Bottom10 as two sets that have been created based on the sales ranking.

Check the boxes next to Top10 and Bottom10. This will filter the table to show only the members of these two sets. You can also click on All to deselect all other values.

Click OK to apply the filter. You will see that the table now shows 20 rows, 10 for each set.

To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either ‘Sciences’ or ‘Humanities’. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign ‘Humanities’ to any subject that contains ‘Science’ in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with ‘Computer Science’ and ignore the other subjects. References:

Logical Functions - Tableau

Tableau Certified Data Analyst Study Guide

To filter the table to show the Top 10 NOC based on the number of medals won, you need to do the following steps:

Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Disciplines worksheet.

Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the NOC, discipline, and medals for each country.

Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.

Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.

Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals.

Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.

Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.