Analytics-DA-201 Exam Dumps - Salesforce Tableau Data Analyst Questions and Answers

To configure the dashboard to ensure that selecting a data point on the map only filters the Detail table, you should select Ignore Actions from the context menu of Sales over time. Ignore Actions is a feature that allows you to exclude a sheet from being affected by any actions on the dashboard, such as filters or highlights. You can select Ignore Actions by right-clicking on a sheet on the dashboard and selecting Ignore Actions from the menu.

In this case, you want to exclude Sales over time from being filtered by the map, so you should select Ignore Actions from its context menu. This will make Sales over time ignore any selections on the map and show all values. The Detail table will still be filtered by the map as usual.

The other options are not correct for this scenario. Removing Dashboard Item will delete Sales over time from the dashboard, which is not what you want. Deselecting Use as Filter will disable the map as a filter for any sheet on the dashboard, which is not what you want. Selecting Deselect will clear any selections on the map, but it will not prevent Sales over time from being filtered by future selections. References: https://help.tableau.com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_ignore.htm

On a Tableau dashboard, when a map is used as a filter, it affects all other sheets in the dashboard by default. To restrict the filter action to only affect the Detail table and not the ' Sales over time ' chart, you would modify the action settings. By selecting " Ignore Actions " from the context menu of the ' Sales over time ' chart, it will no longer respond to the filtering action initiated by selecting data points on the map.

The matching-pattern capability is configured in an Input step in Tableau Prep Builder. When connecting to file-based data such as text files or Excel files, Tableau Prep can include multiple files and create an input union by using wildcard or matching-pattern criteria. This allows similarly named files to be combined into a single table as they are brought into the flow. A separate Union step combines already-added tables or inputs, but the question specifically asks where a single table can be created from a matching pattern of multiple file names. Join combines tables based on key fields, while New Rows generates missing sequential records. Because wildcard file matching is part of the file-ingestion configuration, Input is the correct step.

In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard area where the current sheet (Sheet3) resides. This action will replace the existing sheet with the new one. Right-clicking and adding to the dashboard adds an additional sheet rather than replacing, and the context menu options mentioned in the other choices are not the standard methods for replacing sheets within a dashboard.

The target visualization shows a subtotal after the members of each Category while retaining the individual Sub-Category rows. In Tableau, Analysis > Totals > Add All Subtotals inserts subtotal rows or columns when multiple dimensions are present on Rows or Columns. Here, Category and Sub-Category are both on Rows, so Tableau can calculate a subtotal for each Category group. Show Column Grand Totals and Show Row Grand Totals create totals for the entire view along the corresponding direction; they do not insert a separate total inside every Category section. Column Totals to Top only changes the placement of existing column totals. Because the requirement is to add a Total row for Furniture, Office Supplies, and Technology individually, Add All Subtotals is the correct command.

Extensions in Tableau are web-based programs that can interact with dashboards. To add a button that allows users to export the dashboard as an image, you would use an Extension object. This could be a custom extension designed to trigger the download of the dashboard view as an image.

Both the ZN and IFNULL functions in Tableau can be used to replace NULL values with zeros. The ZN function converts NULL to zero directly, while the IFNULL function allows you to specify that NULL should be replaced with zero. Both will result in showing zero for any NULL values in the Profits field.

A Gantt chart is specifically designed to represent the duration of events or activities along a time axis. Each Gantt mark normally begins at a date or time position, while the mark’s size represents the duration of the activity. This makes the visualization highly appropriate for project schedules, where analysts need to see when individual tasks start and how long each task lasts. Tableau’s official documentation describes Gantt charts as a method for showing event or activity duration and demonstrates their use for elapsed time between dates. Regional performance comparison would normally use bars, maps, or other comparative visualizations. Correlation analysis is better suited to a scatter plot, while long-term budget trends are normally displayed with line charts. Therefore, C is the appropriate Gantt chart use case.