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

To configure the shapes to be much larger than the line, you need to duplicate Population and drag it to the second Marks card. This will create a dual axis chart with two measures on one axis. You can then select Shape on one Marks card and Line on another Marks card, and adjust the size of each mark independently using the Size slider or menu. References: https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_size.htm

In a dual-axis chart in Tableau, if you want to have two different visual mark types (like a shape and a line) and configure them differently (such as making one larger than the other), you would need to duplicate the measure. You then drag this duplicate to the second Marks card (which represents the second axis). There, you can adjust the size of the marks (shapes, in this case) independently of the line marks on the first Marks card.

To share a dashboard that contains confidential information about patients health and needs to always be up to date for a team of healthcare workers, you should publish it to Tableau Server. This will allow you to control who can access and interact with your dashboard, as well as schedule automatic refreshes of your data source or extract. Publishing to Tableau Public would expose your data to anyone on the internet, printing to PDF would not update your data, and exporting as a .twbx would require sending a large file that might not be compatible with other versions of Tableau. References: https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_share.htm https://help.tableau.com/current/pro/desktop/en-us/publish_workbooks_tableauserver.htm

When sharing sensitive and confidential information that needs to be kept up-to-date, such as patient health data for a team of healthcare workers, the best practice is to publish the dashboard to Tableau Server. Tableau Server is designed for secure, controlled access and can be configured to ensure that data is refreshed as needed. Publishing to Tableau Public is not secure for confidential data, printing to PDF or exporting as a .twbx does not allow for live data updates.

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. References: 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.

To ensure that the data is updated every hour, you need to select Extract Refreshes from the data source menu on Tableau Server. This will allow you to add a new extract refresh schedule or edit an existing one. You can specify the frequency and time of the refresh, as well as any custom options or credentials. New will create a new data source, Connected Workbooks will show you which workbooks use this data source, and Connections will show you which tables or files are connected to this data source. References: https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm

To ensure that the data is updated every hour on Tableau Server, you would need to go to the " Extract Refreshes " option. Here, you can schedule the data extracts to refresh at the desired frequency, which in this case would be every hour.

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. References: 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.

The correct Level of Detail (LOD) expression to calculate the grand total of sales across all regions would be {SUM(Sales)} . The FIXED expression is not needed here because we are not computing the sum at the level of each region, but rather the total sum across all regions. The FIXED keyword is typically used to aggregate at a certain level regardless of the view.

https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL

To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select New Data Source from the Data menu. This will open the Connect pane, where you can choose Microsoft Excel as your data source and browse for your spreadsheet file. You can then drag and drop your sheets or tables to join or union them in the data source page. References: https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm

When connecting to a dataset in Tableau Desktop, you would go to the ' Data ' menu and select ' New Data Source ' . This allows you to connect to various types of data sources, including Microsoft Excel spreadsheets, where you can then select the specific file you wish to connect to.

In Tableau dashboards, floating elements are those that can be freely moved over the dashboard canvas without being snapped into the tiled layout. The floating elements are often indicated by their standalone frames and the ability to overlap with other dashboard items. From the provided image, the state filter and the Rate of Obesity chart can be identified as floating if they can be moved independently of the tiled grid layout that constrains other elements.

A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed and optimized file format that can be used to improve the performance and portability of dashboards and workbooks. A .twb file is a workbook file that contains the visualization and connection information, but not the data itself. A .csv file is a comma-separated values file that contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries, forms, and other objects. References: https://help.tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm https://help.tableau.com/current/pro/desktop/en-us/examples_csv.htm https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-9a3c-4a0b-8e6c-6d1f1f7c2b7e

In Tableau, a .hyper file is an extract file created by the Hyper database engine. It contains a snapshot of the data pulled into Tableau and is used to perform data analysis without the need for a live connection to the data source.