Published data sources are shown according to the user’s access within the Tableau site, not simply because the sources exist somewhere on the server. Tableau permissions govern whether a user can discover and connect to published data sources, and the Connect capability is specifically required for ordinary users to work with a published source. Site boundaries also matter: Tableau Server can host multiple sites, and content from another site is not automatically exposed to a signed-in user. Therefore, the best choice is that the list contains the data sources the analyst has access to within the current site. Options that describe every source on the whole Tableau Server are too broad, while restricting results to a particular project state is not the general rule.

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

The requirement is based on total sales by store, so the filter must operate on the Store Number dimension while evaluating an aggregated Sales condition. Tableau dimension filters provide a Condition tab that can retain dimension members according to an aggregate measure, for example SUM([Sales]) > = 500. Applying that logic as an extract filter ensures that only qualifying store members are included in the resulting extract. Filtering the Sales measure by an “at least” row-level value would incorrectly evaluate individual records rather than each store’s total. A Top filter ranks members and is intended for top or bottom N selection, not for a fixed minimum total. Therefore, the analyst should filter Store Number by a condition based on Sales, which corresponds to option B.

Publishing the Excel-based goals data as its own managed data source provides the most appropriate architecture for a file that must be updated regularly and reused alongside an existing published revenue source. The analyst can publish the Excel connection as an extract and configure the appropriate refresh mechanism, after which the dashboard workbook connects to both centrally governed published sources. Tableau documents that published extract data sources can be refreshed on a schedule and that every connected workbook then benefits from the refreshed data. Merely embedding an Excel extract in one workbook would couple refresh management to that workbook, while simply uploading a flat file through web authoring does not guarantee updates to the original changing file. Modifying the ERP system is unnecessary. Therefore, option D provides the intended reusable and maintainable Tableau design.