Salesforce Analytics-DA-201 - Salesforce Certified Tableau Data Analyst

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.

1) Open Tableau prep

2) Create a new column ...

3) Union the sales ...

4) Join the sales ...

To change the story point format to show the current story point number out of the total number of story points, you should use the Numbers option in the Layout tab. This option will display the story points as numbers in a horizontal or vertical sequence, such as 1/2, 2/2. You can also choose to show or hide the next and previous arrows for navigation. The Numbers option will help you indicate the progress and order of your story points more clearly than the other options. References:

Creating a Story - Tableau

New in 9.0: Formatting the Story Points Navigator - Tableau

Tableau Certified Data Analyst Study Guide

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.

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.

You can create aliases for the members of a dimension by right-clicking the dimension in the Data pane or in the view and selecting Aliases. This changes how the values are displayed in the view, but not the underlying data. For example, you can create an alias for “Central” as “Midwest”.

In Tableau, aliases can be used to change the way dimension members appear without altering the underlying data. This is useful for display purposes and does not create a new field within the dataset.

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.