You have the following primary data source that contains a dimension named Dorm_Code.You receive the following secondary data source that contains updated dorm codes.You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.What should you do?
Answer(s): C
Using relationships: You can use relationships to link the secondary data source with the primary data source based on a common field. This will allow you to use fields from both data sources in your visualization without creating new fields or duplicating data. You can then replace references to update the dimension values. For example, you can use relationships to link the updated dorm codes with the primary data source and then replace Dorm_Code with Dorm_Code_New in your visualization.https://community.tableau.com/s/question/0D54T00000C5ldZSAR/update-data-view-based-on- dimensionTo update existing visualizations with new codes without changing the field name, using relationships to bring in the secondary data source is appropriate. Then using Replace Reference allows you to update the references from the old dorm codes to the new ones while maintaining the existing field name.
You have the following datasetYou need to create the following visualization.Which quick table calculation should you drag to Text on the Marks card?
Answer(s): A
we need to create a quick table calculation that shows the percent of total sales for each category and sub-category. To do this, we can follow these steps:Drag Category to Columns and Sub-Category to Rows.Drag Sales to Text on the Marks card.Right-click Sales on the Marks card and select Quick Table Calculation > Percent of Total. Right-click Sales on the Marks card again and select Compute Using > Category. This will create a quick table calculation that shows the percent of total sales for each sub-category within each category. The visualization will look like this:
You create the following worksheetThe Pick Measure parameter contains the following list of valuesUsers can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.Which formula is used in the Selected Measure calculated field lo switch between measures?
https://help.tableau.com/current/pro/desktop/en-us/parameters_swap.htm This formula uses a parameter (Pick Measure) to switch between the Sales and Profit measures. When the user selects '1', it shows Sales, and when '2' is selected, it shows Profit. This dynamic switching is enabled by the Case function.
HOTSPOT (Drag and Drop is not supported)You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.In which step can you transform rows of monthly data into rows of yearly data''
You need to change the values of a dimension without creating a new field.What should you do?
Answer(s): B
You can create aliases for the members of a dimension by right-clicking the dimension in the Data pane or in the view and selecting Aliases. This changes how the values are displayed in the view, but not the underlying data. For example, you can create an alias for "Central" as "Midwest". In Tableau, aliases can be used to change the way dimension members appear without altering the underlying data. This is useful for display purposes and does not create a new field within the dataset.
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.