Salesforce Updated Analytics-DA-201 Exam Questions and Answers by lilly-mae

The formula in option B calculates the percent difference in sales relative to the same quarter the previous year. It subtracts the sales of the same quarter from the previous year from the current year’s sales, and then divides this by the previous year’s sales. This gives a percentage change, which aligns with what is shown in the Calculation field of your dataset. The LOOKUP function returns the value of a specified offset from the current row in the partition. In this case, the offset is -4, which means the value of the same measure four rows above the current row. This corresponds to the same quarter of the previous year, assuming the data is sorted by quarter. References:

LOOKUP Function - Tableau

Table Calculations - Tableau

Tableau Certified Data Analyst Study Guide

To combine the lines to appear as shown in the second chart, you should set Discount to Dual Axis. Dual Axis is a feature that allows you to show two measures on two separate axes on one chart. You can create a dual axis by right-clicking on a measure on any shelf and selecting Dual Axis from the menu. This will create two axes on one chart and synchronize their scales.

In this case, you want to show Profit and Discount on two separate axes on one chart. You can right-click on Discount on any shelf and select Dual Axis from the menu. This will create a dual axis chart that shows Profit and Discount as two lines with different colors.

The other options are not correct for this scenario. Dragging Discount to Color on the Marks card will change the color of Profit based on Discount, but it will not show two lines. Converting Discount to Discrete will change Discount from a green pill to a blue pill, but it will not affect how it appears on the chart. Dragging Discount to Columns shelf will create two separate charts for Profit and Discount, but it will not combine them. References: https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures.htm https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm

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.

A reference line is used in Tableau to display a line at a constant value or a computed value such as an average, median, minimum, or maximum in a bar chart. In this case, adding a reference line would allow you to show the median, upper quartile, and lower quartile, which corresponds to the changes shown in the bar chart.