Free Salesforce Analytics-DA-201 Practice Exam with Questions & Answers | Set: 6

To configure the dashboard action, you should select Filter as the action type, Select as the run action on option, and All Fields as the target filters option. This will ensure that when a user selects a city on the map, the bar chart will show only the data for the selected city based on all fields in common between the two worksheets. The action will run only when the user selects a different city. References: https://help.tableau.com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_filter.htm

To analyze the average revenue per product in different regions over time, you need to use two fields that contain numeric, quantitative values that you can measure and aggregate. Quantity and Revenue are both measures that fit this criterion. You can multiply Quantity and Revenue to get the total sales for each product, and then divide by the number of products to get the average revenue. You can also use these measures to create charts and tables that show the trends and comparisons over time and across regions. References:

Dimensions and Measures, Blue and Green - Tableau

Tableau Certified Data Analyst Study Guide

When you sign in to a Tableau Server site from Tableau Desktop and search for a published data source, you will see all the data sources published to the site within the folders to which you have access. You will not see data sources published to other sites or folders that you do not have permission to view. You can also filter your search by project, owner, or tag. References: https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_tableauserver.htm

When signed in to Tableau Server from Tableau Desktop, you ' ll only be able to see the data sources that have been published to the site and are within the folders that you have been granted access to. Tableau ' s permission and project structure mean that you won ' t see all data sources from the entire server unless you have permissions to do so.

There are different ways to create a table calculation that shows sales growth over each year, but one possible answer is:

SUM([Sales])

LOOKUP(SUM([Sales]), -1)

PREVIOUS_VALUE(0)

 To calculate the sales growth over each year, you need to compare the current year’s sales with the previous year’s sales and divide the difference by the previous year’s sales. You can use the SUM, LOOKUP, and PREVIOUS_VALUE functions to achieve this. The SUM function returns the total sales for each year. The LOOKUP function returns the value of an expression in a target row, specified as a relative offset from the current row. The PREVIOUS_VALUE function returns the value of the expression in the previous row, or a specified value if there is no previous row. The formula for the table calculation is:

(SUM([Sales]) - LOOKUP(SUM([Sales] ), -1)) / PREVIOUS_VALUE(0)

This formula subtracts the sales of the previous year (LOOKUP(SUM([Sales]), -1)) from the sales of the current year (SUM([Sales] )) and divides the result by the sales of the previous year. If there is no previous year, the formula uses 0 as the denominator (PREVIOUS_VALUE(0)) to avoid division by zero errors.

A Tableau Web Data Connector is designed to retrieve data available over HTTP or HTTPS and make that data available to Tableau. A common use case is connecting to a web service or REST API, transforming the returned information into the structure expected by Tableau, and creating an extract for analysis. Tableau documentation lists REST APIs, JSON data, XML data, and internal web services among the sources accessible through Web Data Connectors. A WDC is not a web analytics utility for capturing site traffic, nor is its fundamental purpose generic HTML-table scraping or publishing data to a corporate website. Although newer Tableau releases are moving toward newer connector technologies, the functionality tested by this Tableau Data Analyst question remains connection to web-accessible data such as an API.

A URL action is Tableau’s mechanism for opening an external web page or web-based resource from a worksheet or dashboard. Because the requirement says the page must open when the user clicks the sheet, the action should be configured as Go to URL with Run action on set to Select. Select runs the action when the user clicks a mark, while Menu requires the user to open a context or tooltip menu and choose the action explicitly. A navigation button and a Go to Sheet action move between Tableau sheets or dashboards rather than opening an external webpage. A Web Page object embeds web content within a dashboard and does not satisfy the requirement to open the specific page in the default browser when the sheet is clicked. Therefore, option C is the appropriate configuration.

Tableau Desktop provides a dedicated Swap Sheets capability for replacing one dashboard worksheet with another while retaining much of the original dashboard object’s formatting. The correct workflow is to first select Sheet 3 on the dashboard, hover over Sheet 2 in the Sheets list, and click the Swap Sheets button. Tableau’s current documentation describes this procedure for replacing dashboard sheets. It also notes that padding, border, and background color are retained, although the replacement may require size adjustments if its content differs. Removing Sheet 3 would simply delete the current dashboard item. Adding Sheet 2 separately would not perform the controlled replacement, and Deselect has no role in sheet replacement. Therefore, D is the correct Tableau Desktop workflow.