Download Analytics-DA-201 Dumps (2026) - Free PDF Exam Demo
Enhance your career with Analytics-DA-201 PDF Dumps - True Salesforce Exam Questions
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
NEW QUESTION # 73
Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To create a filled map to show the distribution of total Sales by State across the United States, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
* Click on the Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank worksheet with no marks.
* Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows each state as a mark. You may need to zoom in or out to see the whole map.
* Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that shows the distribution of total Sales by State across the United States. The color legend will show you the range of values and colors for Sales.
* Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your map.
References: https://help.tableau.com/current/pro/desktop/en-us/maps.htm https://help.tableau.com/current/pro
/desktop/en-us/maps_howto_filled.htm https://help.tableau.com/current/pro/desktop/en-us
/marks_markproperties_color.htm
NEW QUESTION # 74
in which three formats can you export a worksheet from the Worksheet menu? Choose three
- A. .png
- B. .pptx
- C. .csv
- D. .html
- E. .xlsx
- F. .txt
Answer: A,B,E
Explanation:
Tableau provides various options to export data from a worksheet. The formats available are typically those that are best suited for visualization or further data analysis. The options include:
* .png for exporting images of the visualizations
* .xlsx for exporting data in a format that can be opened with Microsoft Excel
* .pptx for creating PowerPoint presentations with the visualization embedded These formats are designed to facilitate sharing and presenting the insights derived from Tableau visualizations, or for conducting further analysis in tools like Excel.
NEW QUESTION # 75
The following table displays the row-level data in a Tableau data source:
A Data Analyst creates this calculated field:
SUM(IF [Item] = 'A' THEN [Sales] END) / COUNT([Order ID])
What is the result of this aggregate calculation?
- A. 0
- B. An error
- C. 1
- D. 2
Answer: A
NEW QUESTION # 76
A colleague provides you with access to a folder that contains the following files:
* Sates.csv
* Bookl.twb
* Sates.hyper
* Export.mdb
Which He contains an extract?
- A. Sales.csv
- B. Sales.hyper
- C. Book1.twb
- D. Export mdb
Answer: B
Explanation:
A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed and optimized file format that can be used to improve the performance and portability of dashboards and workbooks. A .twb file is a workbook file that contains the visualization and connection information, but not the data itself. A .csv file is a comma-separated values file that contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries, forms, and other objects. References: https://help.
tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm https://help.tableau.com
/current/pro/desktop/en-us/extracting_data.htm https://help.tableau.com/current/pro/desktop/en-us
/examples_csv.htm https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-
9a3c-4a0b-8e6c-6d1f1f7c2b7e
In Tableau, a .hyper file is an extract file created by the Hyper database engine. It contains a snapshot of the data pulled into Tableau and is used to perform data analysis without the need for a live connection to the data source.
NEW QUESTION # 77
A colleague provides a Data Analyst with access to a folder that has the following files:
* Sales.csv
* Book1.json
* Sales.tds
* Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?
- A. Sales.csv
- B. Book1.json
- C. Sales.tds
- D. Export.mdb
Answer: A
NEW QUESTION # 78
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. Drag the LOD expression to the Filters shelf.
- B. Right-click the State dimension filter, and then click Add to Context.
- C. Right-click the State dimension filter, and then click Attribute.
- D. Change the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.
Answer: B
NEW QUESTION # 79
When using a Show/Hide button in Tableau, what happens if the object is in a Tiled layout container?
- A. The object disappears from the item hierarchy.
- B. The layout automatically adjusts to fill the space.
- C. The hidden object remains in the same position but is grayed out.
- D. The object gets deleted from the dashboard.
Answer: B
NEW QUESTION # 80
You have the following worksheet.
You want to create a table calculation that shows sales growth over each year.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
Explanation:
There are different ways to create a table calculation that shows sales growth over each year, but one possible answer is:
* SUM([Sales])
* LOOKUP(SUM([Sales]), -1)
* PREVIOUS_VALUE(0)
To calculate the sales growth over each year, you need to compare the current year's sales with the previous year's sales and divide the difference by the previous year's sales. You can use the SUM, LOOKUP, and PREVIOUS_VALUE functions to achieve this. The SUM function returns the total sales for each year. The LOOKUP function returns the value of an expression in a target row, specified as a relative offset from the current row. The PREVIOUS_VALUE function returns the value of the expression in the previous row, or a specified value if there is no previous row. The formula for the table calculation is:
(SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / PREVIOUS_VALUE(0)
This formula subtracts the sales of the previous year (LOOKUP(SUM([Sales]), -1)) from the sales of the current year (SUM([Sales])) and divides the result by the sales of the previous year. If there is no previous year, the formula uses 0 as the denominator (PREVIOUS_VALUE(0)) to avoid division by zero errors.
References:
Tableau Certified Data Analyst Exam Prep Guide, page 11, section "Creating Calculated Fields" Tableau Help: SUM Function Tableau Help: LOOKUP Function Tableau Help: PREVIOUS_VALUE Function
NEW QUESTION # 81
Which syntax should a Data Analyst use to find the first purchase date per customer when Customer is not in the view?
- A. { FIXED [Customer ID] : MIN([Purchase Date]) }
- B. MIN([Purchase Date])
- C. [Customer ID] : { [Purchase Date] }
- D. [Customer ID] : MIN([Purchase Date])
Answer: A
NEW QUESTION # 82
A Data Analyst has the following dataset.
The analyst wants to create a parameter to dynamically filter the data to produce the following results based on quantity being above X value.
Which two types of parameters should the analyst use to produce the results? (Choose two)
- A. Date
- B. Float
- C. Integer
- D. Boolean
Answer: B,C
NEW QUESTION # 83
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To split the Customer Name field into two fields named First Name and Last Name, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
* Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the Superstore data source.
* Right-click on Customer Name in the table and select Split from the menu. This will split the field into two fields based on a separator, which is a space by default. You will see two new fields named Customer Name - Split 1 and Customer Name - Split 2 in the table.
* Right-click on Customer Name - Split 1 and select Rename from the menu. Type First Name as the new name and press Enter. This will rename the field as First Name.
* Right-click on Customer Name - Split 2 and select Rename from the menu. Type Last Name as the new name and press Enter. This will rename the field as Last Name.
References: https://help.tableau.com/current/pro/desktop/en-us/datasource_prepare.htm
https://help.tableau.com/current/pro/desktop/en-us/split.htm
https://help.tableau.com/current/pro/desktop/en-us/renamefield.htm
NEW QUESTION # 84
Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?
- A. RUNNING_AVG
- B. EXCLUDE
- C. AVG
- D. INCLUDE
Answer: B
NEW QUESTION # 85
Which attributes are required for the field that is used to hide or show an object with Dynamic Zone Visibility?
- A. String, Fixed Level of Detail (LOD), Dependent on the viz
- B. Boolean, Single Value, Independent of the viz
- C. Boolean, Parameter, Single Value
- D. Single Value, Integer, Independent of the viz
Answer: B
NEW QUESTION # 86
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. A parameter and a calculated filed
- B. Show/hide buttons
- C. Worksheet actions
- D. Dashboard actions
Answer: A
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 # 87
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To filter the table to show the members of the Top10 set and the Bottom10 set, 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 Disciplines worksheet.
* Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the disciplines, sales, and profit for each salesperson.
* Click on the drop-down arrow next to Salesperson on the Filters shelf. This will open a menu that allows you to filter by different criteria.
* Select Set from the menu. This will show you the sets that are available for the Salesperson field. You will see Top10 and Bottom10 as two sets that have been created based on the sales ranking.
* Check the boxes next to Top10 and Bottom10. This will filter the table to show only the members of these two sets. You can also click on All to deselect all other values.
* Click OK to apply the filter. You will see that the table now shows 20 rows, 10 for each set.
References: https://help.tableau.com/current/pro/desktop/en-us/sets.htm https://help.tableau.com/current/pro/desktop/en-us/filtering.htm
NEW QUESTION # 88
A Data Analyst has the following chart that shows the sum of sales made in different cities.
The analyst wants to show the average sale amount for a city when users hover their mouse over any of the bars.
What should the analyst do?
- A. Drag Sales to Tooltip on the Marks card and modify the Tooltip text.
- B. Right-click on SUM(Sales) in the Columns and change Aggregation to Average.
- C. Drag Sales to Tooltip on the Marks card and change Aggregation to Average.
- D. Right-click on SUM(Sales) in the Columns and select Include in Tooltip.
Answer: C
NEW QUESTION # 89
You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.
Answer:
Explanation:
Explanation:
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.
References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.
com/current/pro/desktop/en-us/buildexamples_scatter.htm
NEW QUESTION # 90
Open the link to Book1 found on the desktop. Open the Line worksheet.
Modify the chart to show only main and max values of both measures in each region.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To modify the chart to show only min and max values of both measures in each region, 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 Line worksheet.
* Click on the Line tab at the bottom of the workbook to open the worksheet. You will see a line chart that shows the sales and profit for each month by region.
* Drag Month from the Columns shelf to Filters shelf. This will open a dialog box that allows you to filter by different criteria.
* Select Range of Dates from the dialog box. This will show you options to filter by a range of dates or values.
* Select Minimum and Maximum from the drop-down list next to Month. This will filter by the minimum and maximum values of Month for each region. You can also enter specific values or use the sliders to adjust the range.
* Click OK to apply the filter. You will see that the line chart now shows only min and max values of both measures in each region.
References: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_range.htm
NEW QUESTION # 91
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] : AVG( (FIXED [Product Type] : AVG( [Sales] ) ) )
- B. : FIXED ([Product Type]) : AVG( [ FIXED [Product] : SUM( [Sales] ) ] )
- C. { FIXED [Product Type] : AVG( [Sales] ) }
- D. { EXCLUDE [Product] : SUM( [Sales] ) }
Answer: B
NEW QUESTION # 92
You have the following Map.
You need the map to appear as shown in the following visualization.
What should you do?
- A. Change the opacity to 75%.
- B. Change the mark type to Map.
- C. Change the mark type to Density.
- D. Drag Population to Size on the Marks card.
- E. Drag Location to Size on the Marks card.
Answer: C
Explanation:
To create a map visualization that shows the concentration of data points in different locations, you need to change the mark type to Density. This will create a heatmap that uses color and size to indicate the density of the data points. You can also adjust the intensity and transparency of the density marks to suit your needs. References: The information is based on the following sources:
* Create Heatmaps that Show Trends or Density in Tableau
* Build a Simple Map - Tableau
NEW QUESTION # 93
You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis.
You need to configure be shapes to be much larger than the line.
What should you do?
- A. Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently
- B. For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset
- C. Change Population to a discrete dimension
- D. Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository
Answer: A
Explanation:
To configure the shapes to be much larger than the line, you need to duplicate Population and drag it to the second Marks card. This will create a dual axis chart with two measures on one axis. You can then select Shape on one Marks card and Line on another Marks card, and adjust the size of each mark independently using the Size slider or menu. References: https://help.tableau.com/current/pro/desktop/en-us
/multiplemeasures_dualaxes.htm https://help.tableau.com/current/pro/desktop/en-us
/marks_markproperties_size.htm
In a dual-axis chart in Tableau, if you want to have two different visual mark types (like a shape and a line) and configure them differently (such as making one larger than the other), you would need to duplicate the measure. You then drag this duplicate to the second Marks card (which represents the second axis). There, you can adjust the size of the marks (shapes, in this case) independently of the line marks on the first Marks card.
NEW QUESTION # 94
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To create a histogram on the Quantity field by using bin size of 3, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
* Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.
* Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.
* Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.
* Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a
# sign next to it.
* Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.
* Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.
References: https://help.tableau.com/current/pro/desktop/en-us/histograms.htm https://help.tableau.com
/current/pro/desktop/en-us/calculations_bins.htm https://help.tableau.com/current/pro/desktop/en-us
/buildmanual_histograms.htm
NEW QUESTION # 95
You have the following dataset.
You want to create a new calculated dimension field named Category that meets the following conditions:
. When Subject is Computer Science or Science, Category must be Sciences.
. When Subject is English or Social Studies, Category must be Humanities.
Which two logical functions achieve the goal? Choose two.
- A. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
- B. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- C. IF [Subject]- 'Science' THEN 'Sciences'
ELSEIF [Subject]='English' THEN 'Humanities'
ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END - D. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
End
Answer: C,D
Explanation:
To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either 'Sciences' or 'Humanities'. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign 'Humanities' to any subject that contains 'Science' in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with 'Computer Science' and ignore the other subjects. References:
* Logical Functions - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 96
You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)
Answer:
Explanation:
Explanation:
The correct order of the three actions is:
* Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf.
* Aggregate the date to month and year.
* From the Analytics pane, drag Forecast to the worksheet.
The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default.
The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month.
The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card.
The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast.
References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current
/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/dates.htm
https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm https://help.tableau.com/current/pro
/desktop/en-us/functions_functions_statistical.htm#MODEL_QUANTILE
NEW QUESTION # 97
You have a line chart on a worksheet.
You want to add a comment to March 2020 as shown in the following visualization.
What should you do?
- A. Enable captions
- B. Drag the growth rate to Text on the Marks card
- C. Add a tooltip
- D. Annotate March 2020
Answer: D
Explanation:
To add a comment to March 2020 on a line chart, you need to annotate that mark. You can right-click on the mark and select Annotate > Mark from the menu. This will open a dialog box where you can type your comment and format it as you like. You can also drag and drop the annotation to position it on the worksheet.
Dragging the growth rate to Text on the Marks card will add a label to every mark on the line chart, enabling captions will show a description of the worksheet at the bottom, and adding a tooltip will show a text box when users hover over a mark. References: https://help.tableau.com/current/pro/desktop/en-us
/formatting_annotations.htm https://help.tableau.com/current/pro/desktop/en-us
/formatting_annotations_create.htm
To add a comment to a specific point on a line chart, such as March 2020 in the provided visualization, you would use the 'Annotate' feature. Right-clicking on the data point for March 2020 and selecting 'Annotate' allows you to add a text annotation directly to the chart, which can be used to highlight and comment on that particular data point.
NEW QUESTION # 98
......
100% Free Analytics-DA-201 Files For passing the exam Quickly: https://www.dumpsactual.com/Analytics-DA-201-actualtests-dumps.html
New Download free Analytics-DA-201 PDF for Salesforce Practice Tests: https://drive.google.com/open?id=1dOUAKpsTV1GSxVKYBftVIL1UNodiVtI-
