Analytics-DA-201 Practice Exam Questions and Answers

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

To calculate the month to date value of the prior year, you need to filter the order date to be between the first day of the same month of the previous year and the same day of the previous year. You can use the calculated fields [Calc1] and [Calc2] to get these dates. [Calc1] returns the date that is one year before today, and [Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result.

In the context of filtering data in Tableau, both string and integer parameters can be used to dynamically filter data. A string parameter can be used to filter text-based values, while an integer parameter is suitable for numerical values. In the provided dataset and result URLs, it appears that a unique identifier or key (which could be a string or integer) is being used to filter specific data entries. References: The information is based on the following sources:

An Introduction to Parameters in Tableau

Create Parameters - Tableau

we need to create a calculated field that displays the count of returns only for the first year in the table. To do this, we can use the following formula:

IF FIRST () = 0 THEN COUNT (Returns) END

This formula uses the FIRST () function, which returns the number of rows from the current row to the first row in the partition. If the current row is the first row, then FIRST () returns 0. The IF statement checks if this condition is true, and if so, it returns the count of returns for that row. Otherwise, it returns NULL.

To complete the formula in the calculated field, you should select the following options from the drop-down menus:

FIRST ()

0

COUNT (Returns)

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