Pass the Salesforce Tableau Data Analyst Analytics-DA-201 Questions and answers with ValidTests

To ensure that users can see other published dashboards from their current dashboard when publishing a workbook to Tableau Server, you need to enable the option that shows sheets as tabs. This allows users to navigate between different sheets (dashboards) within the published workbook.

In the provided Publish Workbook to Tableau Server dialog box, you should check the option labeled:

" Show sheets as tabs "

This setting will display the sheets as tabs on Tableau Server, enabling users to switch between dashboards easily.

To determine the Rank Score value for Student ID 4220, we look at the visualization provided and apply the table calculation of RANK(AVG([Score])) . This function will rank the average scores in ascending order by default, with the lowest score receiving the rank of 1.

Based on the provided visualization, the scores for the students are as follows (from lowest to highest average score):

Student ID 4183: 39 (Rank 1)

Student ID 4220: 71 (Rank 6)

Student ID 4247: 71 (Rank 6, same score as ID 4220 so they share the same rank)

Student ID 4124: 75.5

Student ID 4050: 64

Student ID 4205: 67

Student ID 4056: 66

Since Student ID 4220 has an average score of 71, which is the third-highest score, it shares the rank with Student ID 4247. However, since Tableau ranks without gaps, the actual rank assigned is 6, considering that there are two students with a rank of 4 (due to the same average score being the second lowest), making the next rank number 6.

Note: The actual ranks for the highest scores are not provided, but they are not needed to determine the rank for Student ID 4220.

https://help.tableau.com/current/prep/en-us/prep_calculations.htm

There are different ways to prepare the data in Tableau Prep, but one possible answer is:

Answer area:

Join the tables.

Aggregate the data by Sales Team.

Add the following filter to the Employees table: Sale Team - Team Alpha.

 To analyze sales trends over time for every sales team, you need to combine the data from the Orders and Employees tables. You can do this by joining the tables on the Rep ID column, which is a common identifier for both tables. This will create a single table with all the columns from both tables. Next, you need to aggregate the data by Sales Team, which is the level of analysis you want. You can do this by grouping the data by the Sales Team column and applying an aggregation function (such as sum, average, count, etc.) to the other columns that you want to measure (such as Total Amount, Rep Tenure, etc.). This will create a summary table with one row for each sales team and the aggregated values for the other columns. Finally, you need to filter the data to focus on a specific sales team, such as Team Alpha. You can do this by adding a filter to the Employees table and selecting only the rows where Sales Team equals Team Alpha. This will remove the rows for other sales teams and keep only the data for Team Alpha.

To connect to a tab-delimited data file named sales.tsv, you should select the option To a File > Text file in Tableau Desktop. This option will allow you to browse and select the file from your local or network drive and connect to it as a data source. You can then specify the text file properties, such as the delimiter, the text qualifier, and whether the first row contains column names. You can also join, union, or blend the data with other data sources if needed. References:

Text File - Tableau

Tableau Certified Data Analyst Study Guide

To apply a custom data role to a field, you need to select the data type of the field and then choose the data role from the list of available roles. This will validate the values in the field against the data role and mark any invalid values with a red exclamation mark. To fix the invalid values, you can use the Group Values option and select the Spelling algorithm, which will group values that are close in spelling and replace them with the most frequent value in the group. This will help you standardize the values in the Material field and match them with the Role1 data role. References: The information is based on the following sources:

Use Data Roles to Validate your Data - Tableau

New in Tableau Prep: Automatically identify data quality issues with Data Roles