You have the following dataset that contain null values in the Profits field.

You want the data to appear as shown in the following table.

Which two formulas achieve the goal? Choose two.

• A.2N ([Profits])
• B.ISNULL ([Profits])
• C.IFNULL [(profits] ,0)
• D.IF [Profits] != null then [Profits] END
• E.IFNULL([Profits],0) D. IF [Profits] != null then [Profits] END

Comment: *

Name: *

Email: *

Verification: *

You receive a tab-delimited data file name sales.tsv.
You need to connect to the file.
Which option should you select in Tableau Desktop?

Correct Answer:

Explanation:
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

Comment: *

Name: *

Email: *

Verification: *

You have the following dashboard.

When a user selects a only on the map the data on the bar chart must show only the data for the selected city. The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have the following worksheet.

You want to create a table calculation that shows sales growth over each year.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

Correct Answer:

Reference:
Tableau Certified Data Analyst Exam Prep Guide, page 11, section "Creating Calculated Fields" Tableau Help: SUM Function Tableau Help: LOOKUP Function Tableau Help: PREVIOUS_VALUE Function

Comment: *

Name: *

Email: *

Verification: *

You have the following dataset.

Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?

• A.(SUM ([Sales]) - LOOKUP (SUM ( [Sales]), -4))
• B.(SUM ([Sales]) - LOOKUP (SUM ([Sales]), -4) ) / (LOOKUP (SUM ([Sales]), -4) )
• C.(SUM([Sales]) / (LOOKUP (SUM ([Sales]), -4))
• D.(ZN (SUM ([Sales]) ) - LOOKUP (ZN (SUM ([Sales]) ), -4) )

Comment: *

Name: *

Email: *

Verification: *