Pass Salesforce Analytics-DA-201 Exam With Practice Test Questions Dumps Bundle
2026 Valid Analytics-DA-201 test answers & Salesforce Exam PDF
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
NEW QUESTION # 59
Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To add a distribution band on Profit to show the standard deviation from -1 to 1, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the SalesVSProfit worksheet.
* Click on the SalesVSProfit tab at the bottom of the workbook to open the worksheet. You will see a scatter plot that shows the relationship between Sales and Profit for each Sub-Category.
* Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet.
* Drag Distribution Band from the Analytics pane to Profit on the Rows shelf. This will add a distribution band on Profit that shows the average and confidence interval for each Sub-Category.
* Click on the Edit button on the distribution band to open the Edit Distribution Band dialog box. You will see options to customize your distribution band.
* Change the Band From value to -1 and the Band To value to 1. This will change the distribution band to show the standard deviation from -1 to 1, which means one standard deviation below and above the average.
* Click OK to apply the changes. You will see that the distribution band now shows a narrower range of values for Profit.
References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_distributionband.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_distributionband_edit.htm
NEW QUESTION # 60
A Data Analyst at a coffee company has the following visualization already built.
The analyst wants to make this more visually appealing by coloring the bars based on whether they are above or below the Average Sales within each Product Type.
Which calculation should the analyst use to calculate the Average Sales for each Product Type?
- A. : FIXED ([Product Type]) : AVG( [ FIXED [Product] : SUM( [Sales] ) ] )
- B. { FIXED [Product Type] : AVG( [Sales] ) }
- C. { EXCLUDE [Product] : SUM( [Sales] ) }
- D. ( FIXED [Product] : AVG( (FIXED [Product Type] : AVG( [Sales] ) ) )
Answer: A
NEW QUESTION # 61
You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.
The following is a sample of the sales data for me division in Germany.
You have population data in a file named Populatio.csv. the following is a sample of the data.
You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.
You need to prepare the data to support the planned visualization. The data source must support being published .
Which four actions should you perform in order?
(Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.
Use Answer Area arrows to re-order the options)
Answer:
Explanation:
Explanation:
1) Open Tableau prep
2) Create a new column ...
3) Union the sales ...
4) Join the sales ...
References: https://help.tableau.com/current/prep/en-us/prep_get_started.htm https://help.tableau.com/current
/prep/en-us/prep_union.htm https://help.tableau.com/current/prep/en-us/prep_clean.htm https://help.tableau.
com/current/prep/en-us/prep_join.htm
NEW QUESTION # 62
You want to add a comment to March 2020 as shown in the following visualization.
You have the following sets in a Tableau workbook
* Top N Customers
* Customers of 2020
* Top N Products
* Sellers of 2020
Which two sets can you combine? Choose two
- A. Sellers of 2020
- B. Customers of 2020
- C. Top N Customers
- D. Top N Products
Answer: B,C
Explanation:
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.
NEW QUESTION # 63
You have the following dashboard that contains two sheets.
You want to minimize the whitespace between the sheets.
What should you configure?
- A. The border
- B. The padding
- C. The size
- D. The background
- E. The position
Answer: B
Explanation:
To minimize the whitespace between the sheets, you should configure the padding of the sheets and the dashboard. Padding is the amount of space between the edge of a sheet or dashboard and its content. You can adjust the padding by using the Layout tab in the Format pane. You can reduce the padding for each sheet by selecting the sheet and changing the values for the inner and outer padding. You can also reduce the padding for the dashboard by selecting the dashboard and changing the values for the outer padding. Reducing the padding will make the sheets and the dashboard more compact and eliminate unnecessary whitespace. References:
* Format Dashboards - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 64
You have the following dataset:
Which grouping option should you use in Tableau Prep to group all five names automatically?
- A. Manual Selection
- B. Pronunciation
- C. Spelling
- D. Common Characters
Answer: D
Explanation:
Common Characters: Find and group values that have letters or numbers in common. This option uses the ngram fingerprint algorithm that indexes words by their unique characters after removing punctuation, duplicates, and whitespace. This algorithm works for any supported language. This option isn't available for data roles. For example, this algorithm would match names that are represented as "John Smith" and "Smith, John" because they both generate the key "hijmnost". Since this algorithm doesn't consider pronunciation, the value "Tom Jhinois" would have the same key "hijmnost" and would also be included in the group.
NEW QUESTION # 65
A Data Analyst has the following chart that shows the cumulative volume of sales from various dates.
The analyst wants the months to appear as shown in the following chart.
What should the analyst do?
- A. Change the Sort Order
- B. Convert the date to Continuous
- C. Convert the date to Exact Date
- D. Convert the date to Attribute
Answer: B
NEW QUESTION # 66
You have the following visualization.
You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
Explanation:
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
NEW QUESTION # 67
A Data Analyst has the following chart.
The analyst needs to enable the drilldown from Category to Subcategory as shown in the following chart.
What should the analyst create?
- A. A combined set for Category and Subcategory
- B. A hierarchy of Category and Subcategory
- C. A group of Category and Subcategory
- D. A bin for Category and a bin for Subcategory
Answer: B
NEW QUESTION # 68
You have the following chart that sorts states by the number of products each state has purchased.
Which formula should you use to include a number with the position of each state within each region?
- A. INDEX ()
- B. FIRST ()
- C. LOOKUP (SUM ([Quantity]))
- D. WINDOW_SUM(SUM ([Quantity]))
Answer: C
Explanation:
The LOOKUP function is used to return the value of a specified field in a different row, which can be defined relative to the current row. In this context, it can be used to include a number with the position of each state within each region by looking up the SUM([Quantity]) in each respective position. References: The information is inferred from general Tableau knowledge as well as the following sources:
* Tableau Functions (Alphabetical)
* LOOKUP
* Tableau Certified Data Analyst Exam Guide
NEW QUESTION # 69
A Data Analyst needs to calculate the first Tuesday of each month in the data.
Which set of functions should the analyst use to perform this calculation?
- A. DATETRUNC, DATEADD
- B. DATETRUNC, DATEPART
- C. DATEDIFF, DATEPART
- D. DATEADD, DATENAME
Answer: B
NEW QUESTION # 70
You have the following two datasets:
* A Microsoft Excel worksheet that has two columns named Employee Name and Department
* A Microsoft SQL Server table that has three columns named Employee Name. Pay Grade and Team Size.
You want to use Tableau Prep to join the two datasets.
Which three actions should you perform in order? (Place the three correct options in order.)
Answer:
Explanation:
Explanation:
The correct order of the three actions is:
* From the connections pane, connect to both data sources
* Join both datasets and select the join type
* Specify Employee Name as the join key
The first action is to connect to both data sources from the connections pane in Tableau Prep. The connections pane is where you can access and add data sources to your flow. You can connect to various types of data sources, such as Excel, SQL Server, or Tableau Server. In this case, you want to connect to an Excel worksheet and a SQL Server table.
The second action is to join both datasets and select the join type. A join is a way of combining data from two or more tables based on a common field. You can join datasets by dragging one table to the canvas and dropping it on top of another table. This will create a join step in your flow. You can select the join type from the drop-down list on the join step. The join type determines which rows are returned from the tables.
The third action is to specify Employee Name as the join key. A join key is a field that is used to match rows from different tables. You can specify the join key by clicking on the field name in each table and dragging it to the center of the join step. This will create a join clause that shows the field name and the operator. In this case, you want to use Employee Name as the join key, because it is a common field between the two datasets.
The other options are not relevant for this scenario. Specifying Department and Team Size as a join condition will not work, because they are not common fields between the two datasets. Opening both data sources in Tableau Desktop will not help you join them in Tableau Prep. Adding a step to aggregate the data in the SQL Server table will not affect the join, but it may change the level of detail of your data. References: https://help.
tableau.com/current/prep/en-us/prep_connect.htm https://help.tableau.com/current/prep/en-us/prep_join.htm
https://help.tableau.com/current/prep/en-us/prep_join_types.htm
NEW QUESTION # 71
You have the following dashboard that contains two visualizations.
You want to show only one visualization at time. Users must be able to switch between visualizations.
What should you me?
- A. Dashboard actions
- B. Show/hide buttons
- C. Worksheet actions
- D. A parameter and a calculated filed
Answer: B
Explanation:
In Tableau, you can manage the visibility of different visualizations on a dashboard using various techniques.
Among the options provided, the most straightforward method to allow users to switch between two visualizations is to use show/hide buttons.
Here's why each option is or isn't suitable for the requirement:
A). A parameter and a calculated field: While it's possible to use a parameter and a calculated field to control which visualization is displayed, it requires creating a calculated field that responds to a parameter and then using that field to filter the view. This method can become complex and is not as user-friendly for simply showing and hiding visualizations.
B). Worksheet actions: Worksheet actions in Tableau typically allow users to interact with the data within a visualization, such as filtering data or highlighting related data points when clicking or hovering. They are not designed to control the visibility of entire visualizations on a dashboard.
C). Show/hide buttons: Show/hide buttons are a feature specifically designed to manage the visibility of dashboard elements. When you create a show/hide button, it can be configured to display or hide a particular visualization, container, or any other dashboard element when clicked. This provides a very intuitive interface for users to switch between visualizations.
D). Dashboard actions: Dashboard actions, like worksheet actions, are used to create interactions between sheets, such as filtering data or navigating to other sheets or URLs based on user interactions. They are not intended for toggling the visibility of visualizations.
Therefore, the correct answer is C. Show/hide buttons as they provide a user-friendly way to switch between visualizations on a dashboard without the need for complex calculations or actions that aren't meant for this purpose. The show/hide button feature is specifically designed for toggling visibility and offers a simple and effective solution for the requirement.
NEW QUESTION # 72
A Data Analyst has a data source that contains the following columns:
he analyst has the following FIXED Level of Detail (LOD) expression called Region Sales:
{ FIXED [Region] : SUM([Sales]) }
The analyst has a view that has a dimension filter on the State column to exclude five states.
What should the analyst do to ensure the five states are also excluded from the LOD expression?
- A. Right-click the State dimension filter, and then click Attribute.
- B. Right-click the State dimension filter, and then click Add to Context.
- C. Drag the LOD expression to the Filters shelf.
- D. Change the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.
Answer: B
NEW QUESTION # 73 
How are the colors configured for the map?
- A. A diverging color palette that has five stepped colors
- B. A diverging color palette that has six stepped colors
- C. A sequential color gradient
- D. A single color gradient
Answer: A
NEW QUESTION # 74
You create a parameter named Choose Region fiat contains values from a field named Region.
You want users to be able to use the Choose Region parameter to interact with a chart by logging between different regions What should you do next?
- A. Add the Choose Region parameter to the Pages card
- B. Add Region to the Fitters card
- C. Add the [Region] = [choose Region) formula to the Filters card
- D. Set the Choose Region parameter to Single Value (list)
Answer: C
Explanation:
https://kb.tableau.com/articles/howto/filtering-data-with-a-parameter?lang=fr-fr After creating a parameter named Choose Region, you want to use it to filter the chart based on the user's selection. To do this, you would create a calculated field with the formula [Region] = [Choose Region] and add this calculated field to the Filters card. This will dynamically filter the chart to display data only for the region that matches the user's selection in the Choose Region parameter.
NEW QUESTION # 75
You have a Tableau workbook.
You want to make the workbook available in Tableau Online.
What should you do?
- A. From the File menu, select Export Packaged Workbook.
- B. From the Server menu, select Publish Workbook.
- C. From the Server menu, select Publish Data Source.
- D. From the Server menu, select Tableau Public, and then select Save to Tableau Public.
Answer: B
Explanation:
To make a workbook available in Tableau Online, you need to publish it from Tableau Desktop to Tableau Online. You can do this by selecting Publish Workbook from the Server menu, signing in to your Tableau Online account, choosing a project and a name for your workbook, and clicking Publish. This will upload your workbook and its data sources to Tableau Online, where you can view, edit, and share it with others. References:
* Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes"
* Tableau Help: Publish a Workbook
NEW QUESTION # 76
You have the following chart that sorts states by the number of products each state has purchased.
Which formula should you use to include a number with the position of each state within each region?
- A. FIRST ()
- B. INDEX ()
- C. WINDOW_SUM(SUM ([Quantity]))
- D. LOOKUP (SUM ([Quantity]))
Answer: B
Explanation:
The LOOKUP function is used to return the value of a specified field in a different row, which can be defined relative to the current row. In this context, it can be used to include a number with the position of each state within each region by looking up the SUM([Quantity]) in each respective position. References: The information is inferred from general Tableau knowledge as well as the following sources:
* Tableau Functions (Alphabetical)
* LOOKUP
* Tableau Certified Data Analyst Exam Guide
NEW QUESTION # 77
You have the following calculated fields in a worksheet.
[Calc1] = DATEADD ('year', -1, TODAY ())
[Calc2] = DATETRUNC ( 'month' , DATEADD ('year', -1, TODAY ())
You want to calculate the month to date value of the prior year.
How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
Answer:
Explanation:
To calculate the month to date value of the prior year, you need to filter the order date to be between the first day of the same month of the previous year and the same day of the previous year. You can use the calculated fields [Calc1] and [Calc2] to get these dates. [Calc1] returns the date that is one year before today, and
[Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result.
References:
Finding the Month-to-Date Values for the Prior Year
[DATEADD Function]
[DATETRUNC Function]
NEW QUESTION # 78
......
Top Salesforce Analytics-DA-201 Courses Online: https://exams4sure.pdftorrent.com/Analytics-DA-201-latest-dumps.html