Cisco®
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
All Vendors
  2. Home
  3. Exams
  4. Salesforce
  5. Analytics-DA-201

Free Salesforce Analytics-DA-201 Exam Questions (page: 6)

Page 4 of 23
PDF with 174 Questions

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?

  1. Drag the growth rate to Text on the Marks card
  2. Enable captions
  3. Annotate March 2020
  4. Add a tooltip

Answer(s): C

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.


Reference:

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.



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

  1. Sellers of 2020
  2. Customers of 2020
  3. Top N Products
  4. Top N Customers

Answer(s): B,D

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.


Reference:

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.



DRAG DROP (Drag and Drop is not supported)
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)

  1. See Explanation for the Answer.

Answer(s): A

Explanation:

1) Open Tableau prep
2) Create a new column ...
3) Union the sales ...
4) Join the sales ...


Reference:

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



DRAG DROP (Drag and Drop is not supported)
You have the following dataset.



You need to create the following worksheet.



The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)

  1. See Explanation for the Answer.

Answer(s): A

Explanation:



SIMULATION
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.

  1. See Explanation for the Answer.

Answer(s): A

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.


Reference:

https://help.tableau.com/current/pro/desktop/en-us/sets.htm https://help.tableau.com/current/pro/desktop/en-us/filtering.htm



SIMULATION
Open the link to Book1 found on the desktop. Open Disciplines worksheet. Filter the table to show the Top 10 NOC based on the number of medals won.

  1. check the steps below in explanation.

Answer(s): A

Explanation:

To filter the table to show the Top 10 NOC based on the number of medals won, 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 NOC, discipline, and medals for each country.

Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.
Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.
Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals. Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.
Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.


Reference:

https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm



SIMULATION
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.

  1. check the steps below in explanation.

Answer(s): A

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.


Reference:

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



SIMULATION
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.

  1. check the steps below in explanation.

Answer(s): A

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.


Reference:

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



Viewing page 6 of 23
Viewing questions 41 - 48 out of 174 questions



Post your Comments and Discuss Salesforce Analytics-DA-201 exam prep with other Community members:

Analytics-DA-201 Exam Discussions & Posts