You have the following dashboard.Currently the map is used as a filter that affects the data on the otter sheets of the dashboard You need to configure the dashboard to ensure that selecting a data point on the map only tillers the Detail tableWhat should you do?
Answer(s): A
To configure the dashboard to ensure that selecting a data point on the map only filters the Detail table, you should select Ignore Actions from the context menu of Sales over time. Ignore Actions is a feature that allows you to exclude a sheet from being affected by any actions on the dashboard, such as filters or highlights. You can select Ignore Actions by right-clicking on a sheet on the dashboard and selecting Ignore Actions from the menu.In this case, you want to exclude Sales over time from being filtered by the map, so you should select Ignore Actions from its context menu. This will make Sales over time ignore any selections on the map and show all values. The Detail table will still be filtered by the map as usual. The other options are not correct for this scenario. Removing Dashboard Item will delete Sales over time from the dashboard, which is not what you want. Deselecting Use as Filter will disable the map as a filter for any sheet on the dashboard, which is not what you want. Selecting Deselect will clear any selections on the map, but it will not prevent Sales over time from being filtered by future selections.
https://help.tableau.com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_ignore.htmOn a Tableau dashboard, when a map is used as a filter, it affects all other sheets in the dashboard by default. To restrict the filter action to only affect the Detail table and not the 'Sales over time' chart, you would modify the action settings. By selecting "Ignore Actions" from the context menu of the 'Sales over time' chart, it will no longer respond to the filtering action initiated by selecting data points on the map.
You have a dataset that contains people and the awards they have won.Which formula should you use to get the number of different types of awards that have been won?
Answer(s): B
To get the number of different types of awards that have been won, you should use the formula COUNTD({Award}). This formula will return the count of distinct values in the Award field, which are the different types of awards that have been won.The other options are not correct for this scenario. COVAR({Award}) is not a valid function in Tableau. MAX({Award}) will return the maximum value in the Award field, which may not be a type of award. INDEX() will return the index or rank of each row in a partition, which is not related to the types of awards.
https://help.tableau.com/current/pro/desktop/en- us/functions_functions_aggregate.htm#COUNTD https://help.tableau.com/current/pro/desktop/en- us/functions_functions_tablecalculation.htm#INDEXThe COUNTD function in Tableau calculates the number of distinct (unique) items in a field. When looking to get the number of different types of awards that have been won, the COUNTD([Award]) function will count each unique award name only once, regardless of how many times it appears in the dataset. This will return the total number of unique award types.
DRAG DROP (Drag and Drop is not supported)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.)
The correct order of the three actions is:From the connections pane, connect to both data sources Join both datasets and select the join typeSpecify Employee Name as the join keyThe 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 dat a.
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
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 regionsWhat should you do next?
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.
You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?
Answer(s): D
To use the City dimension to create a dynamic filter that shows the cities that have a population greater than one million, you should use a condition filter. A condition filter is a type of filter that shows only the values that meet a specified condition based on a measure or a calculation. You can create a condition filter by dragging a dimension to the Filters shelf and selecting Condition from the dialog box. Then you can enter a formula or choose an option that defines your condition. In this case, you want to create a condition filter based on Population, which is a measure. You can drag City to the Filters shelf and select Condition from the dialog box. Then you can choose By field from the tab and select Population > Sum > Greater than > 1000000 from the drop-down lists. This will create a condition filter that shows only the cities that have a sum of population greater than one million.The other options are not correct for this scenario. A general filter is not a specific type of filter, but a term that refers to any type of filter in Tableau. A wildcard filter is a type of filter that shows only the values that match a specified pattern or string, such as "New*" or "*ton". A top filter is a type of filter that shows only the top or bottom N values of a measure or dimension based on a ranking or an aggregation.
https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_condition.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_wildcard.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
Post your Comments and Discuss Salesforce Certified Tableau Data Analyst exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the Certified Tableau Data Analyst content, but please register or login to continue.