Pass the Salesforce Tableau Data Analyst Analytics-DA-201 Questions and answers with Dumpstech

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.

To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box. References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm

To show additional information such as the corresponding region when hovering over a bar in Tableau, you can drag the ' Region ' field to the ' Tooltip ' shelf on the ' Marks ' card. This will ensure that when a user hovers over a bar representing a city, the tooltip will dynamically display the region associated with that city.

In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard area where the current sheet (Sheet3) resides. This action will replace the existing sheet with the new one. Right-clicking and adding to the dashboard adds an additional sheet rather than replacing, and the context menu options mentioned in the other choices are not the standard methods for replacing sheets within a dashboard.

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

1) Open Tableau prep

2) Create a new column ...

3) Union the sales ...

4) Join the sales ...

The box plot visualization displays the distribution of average profits by region. The distribution of profits is represented by the range of the box (interquartile range) and the whiskers (which often represent the total range excluding outliers). From the image provided, the South region has the smallest visible range within its box and the shortest whiskers, indicating the smallest distribution of average profits among the choices provided.

To combine the tables and meet the requirements, you should use a left join. A left join will keep all the records from the left table (Employeelnfo) and match them with the records from the right table (DepartmentInfo) based on the common field (Department ID). If there is no matching record in the right table, the fields from the right table will be null. This way, you will retain all the records from Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo. Every record will have a full name because it is a field from the left table. A left join will look like this: