Pass the Salesforce Tableau Data Analyst Analytics-DA-201 Questions and answers with CertsForce

Tableau Prep ' s Grouping feature includes various methods to group similar data. The Spelling option is used when the data has small variations in spelling, such as capitalization differences or common typos. Given that the names in the dataset vary in capitalization and punctuation but are spelled correctly, the Spelling grouping option would be the most appropriate choice to automatically group all five names.

To add two sheets to the dashboard that support the Show/Hide button, you can add them to either a horizontal or a vertical container. A container is an object that can hold one or more sheets or other objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide or show a container and its contents on the dashboard. You can add a Show/Hide button to any container, whether it is tiled or floating, by using the drop-down menu of the container and selecting “Add Show/Hide Button.” You can also customize the appearance and behavior of the button.

To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a vertical container will arrange them vertically. You can then drag the sheets you want to add from the Sheets pane to the container. You can resize and reorder the sheets or objects within the container by using the handles and arrows.

The other objects in the Answer Area, such as text, image, web page, blank, navigation, download, and extension, do not support the Show/Hide button. They are either static elements that cannot hold other objects, or dynamic elements that require user interaction or external sources. You can add them to the dashboard as well, but they will not have the same functionality as a container with a Show/Hide button.

A dynamic Top 10 requirement should be implemented with a dynamic set, not with a manual selection or static group. The analyst can create a set on the Year dimension, configure its Top tab to retain the top 10 members according to the relevant medal-count measure, and then place the resulting IN/OUT set on Color on the Marks card. Tableau recalculates the set as the underlying data or ranking changes, so whichever ten years currently meet the Top 10 condition receive one color and the remaining values receive another. Manually selecting ten bars or manually creating a set from currently selected bars produces a fixed membership. A group is also static unless manually changed. Tableau’s Top N guidance demonstrates dragging a Top N set to Color to distinguish the dynamic subset.

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

1) Open Tableau prep

2) Create a new column ...

3) Union the sales ...

4) Join the sales ...

Sales:  B. Columns

Profit:  D. Rows

Customer Name:  C. Detail on the Marks card

Category:  A. Color on the Marks card

To create the visualization, you need to drag Sales to Columns, Profit to Rows, Customer Name to Detail on the Marks card, and Category to Color on the Marks card. This will create a scatter plot that shows the relationship between Sales and Profit for each Customer Name, with different colors for each Category.

To combine two sets, they must have at least one dimension in common. In this case, Customers of 2020 and Top N Customers both have Customer Name as a dimension, so they can be combined using set operations such as union, intersection, or difference. Sellers of 2020 and Top N Products have different dimensions (Seller Name and Product Name), so they cannot be combined. References: https://help.tableau.com/current/pro/desktop/en-us/sets.htm https://help.tableau.com/current/pro/desktop/en-us/sets_create.htm#combine-sets

In Tableau, sets can be combined if they are created from the same dimension. From the options provided, " Customers of 2020 " and " Top N Customers " are likely created from the same dimension (Customers). Therefore, these two sets can be combined to create a new set that includes or excludes members based on the combined criteria. Combining sets like " Top N Products " with " Customers of 2020 " would not be feasible unless they are from the same dimension, which is typically not the case.

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.

To ensure that the extract also refreshes on the last day of the month at 18:00, you need to add a new extract refresh task to the workbook on Tableau Server. You can do this by selecting the workbook, selecting Refresh Extracts, and then choosing Schedule a Refresh. You can then select an existing schedule that matches your desired frequency and time, or create a new schedule with a custom frequency and time. This will add a new extract refresh task to the workbook, in addition to the existing one that refreshes every Monday at 10:00. You can also modify or delete the extract refresh tasks as needed. References:

Tableau Certified Data Analyst Exam Prep Guide , page 10, section “Publishing and Scheduling Data Refreshes”

Tableau Help: Refresh Data on a Schedule

Tableau Help: Manage Refresh Tasks