Analytics-DA-201 試験問題を無料オンラインアクセス

You have the following dashboard.

When a user selects a only on the map the data on the bar chart must show only the data for the selected city.
The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)

正解：

Explanation:
To configure the dashboard action, you should select Filter as the action type, Select as the run action on option, and All Fields as the target filters option. This will ensure that when a user selects a city on the map, the bar chart will show only the data for the selected city based on all fields in common between the two worksheets. The action will run only when the user selects a different city. References: https://help.tableau.
com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_filter.
htm

You plan to create a Tableau subscription for several users.
Which two formats can you use? Choose two.

• A.Image
• B.Microsoft PowerPoint
• C.PDF
• D.Microsoft Excel

Which syntax should a Data Analyst use to find the first purchase date per customer when Customer is not in the view?

• A.[Customer ID] : { [Purchase Date] }
• B.{ FIXED [Customer ID] : MIN([Purchase Date] ) }
• C.MIN([Purchase Date])
• D.[Customer ID] : MIN([Purchase Date] )

You have a table that contains the following data.

How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

正解：

Explanation:

To complete the formula, you should drag the option MAX from the list of options and drop it into the first blank space, and then drag the option [Sales] and drop it into the second blank space. The formula will look like this: Option (MAX) Option ([Sales] ). This formula will calculate the maximum value of the sales field for each country. You can use this formula to create a calculated field that will show the highest sales amount for each country in your data source. References:
* Create a Simple Calculated Field - Tableau
* MAX Function - Tableau
* Tableau Certified Data Analyst Study Guide

You have the following dataset.

Yon need to calculate the ranking shown in the Rank field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?

正解：

Explanation:
To calculate the ranking shown in the Rank field, you need to use the RANK_UNIQUE function, which returns the unique rank of each value in a partition. You need to specify the expression as SUM([Sales]), which calculates the total sales for each product. You also need to specify the order as descending, which means that the highest sales will have the lowest rank. Finally, you need to specify the restart as every
[Category] , which means that the ranking will reset for each category. References: https://help.tableau.com
/current/pro/desktop/en-us/functions_functions_tablecalculation.htm https://help.tableau.com/current/pro
/desktop/en-us/calculations_calculatedfields_lod_rank.htm