Free Practice Questions for Salesforce Analytics-DA-201 Exam

To make Sales appear automatically as shown in the second table, you should change the default number format of the Sales field. The default number format is how Tableau displays a field when you drag it to a worksheet. You can change the default number format by right-clicking on the field and selecting Default Properties > Number Format from the menu. This will open a dialog box where you can choose a category, such as Currency or Percentage, and customize the options, such as decimal places or prefixes.

In this case, you want to change the default number format of Sales to Currency with zero decimal places and a custom prefix of “S”. This will make Sales appear as “S” followed by the rounded value in thousands.

The other options are not correct for this scenario. Changing the data type of Sales to String will not affect how it appears on a worksheet. Creating a calculated field that uses a formula will not change the default number format of Sales, but create a new field that you have to drag to a worksheet. Converting Sales to Attribute will return only one value for each partition of data, which will not show any variation over time. References: https://help.tableau.com/current/pro/desktop/en-us/formatting.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_change_default.htm

To achieve the formatting as shown in the example, where sales figures are displayed with a " K " to represent thousands and rounded to the nearest thousand (e.g., $20K, $44K, etc.), you would need to adjust the default number format of the Sales field in Tableau. By changing the default number format, every instance where the Sales field is used would automatically reflect this new formatting. This is more efficient than creating a calculated field as it preserves the numeric nature of the field, allowing for further numerical operations and aggregations.

https://kb.tableau.com/articles/howto/filtering-data-with-a-parameter?lang=fr-fr

After creating a parameter named Choose Region, you want to use it to filter the chart based on the user ' s selection. To do this, you would create a calculated field with the formula [Region] = [Choose Region] and add this calculated field to the Filters card. This will dynamically filter the chart to display data only for the region that matches the user’s selection in the Choose Region parameter.

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

The two formulas that will return a value of true if a month has sales greater than $50,000, otherwise the formula must return a value of false, are:

B. IIF(SUM([Sales]) > 50000, TRUE, FALSE) D. [Sales] > 50000

The IIF function is a logical function that returns one value if a condition is true, and another value if the condition is false. In this case, the condition is SUM([Sales]) > 50000, which means that the sum of sales for a month is greater than $50,000. The function will return TRUE if the condition is true, and FALSE if the condition is false.

The comparison operator > is a logical operator that returns TRUE if the left operand is greater than the right operand, and FALSE otherwise. In this case, the operands are [Sales] and 50000, which means that the sales for a month are greater than $50,000. The operator will return TRUE if the sales are greater than $50,000, and FALSE otherwise.

The other options are not correct for this scenario. The IN function is a logical function that returns TRUE if a value is in a set of values, and FALSE otherwise. In this case, the value is SUM([Sales]), which is not in the set of values (50000). The function will always return FALSE. The MAX function is an aggregation function that returns the maximum value in a field or expression. In this case, the field or expression is [Sales] , 50000, which is not valid syntax. The function will return an error. References: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IIF https://help.tableau.com/current/pro/desktop/en-us/operators.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#MAX