The Tableau Certified Data Analyst Exam (TDA-C01)

Tableau Prep ' s Grouping feature includes various methods to group similar data. The Spelling option is used when the data has small variations in spelling, such as capitalization differences or common typos. Given that the names in the dataset vary in capitalization and punctuation but are spelled correctly, the Spelling grouping option would be the most appropriate choice to a u tomatically group all five names.

To combine the two tables that contain data about books in a library and ensure that all the data is retained, you should use a full outer join. A full outer join is a type of join that returns all rows from both tables, regardless of whether there is a match or not. If there is no match, null values are filled in for the missing fields.

To perform a full outer join, you need to do the following steps:

Connect to both tables as your data sources in Tableau. You can use either live or extract connections.

Drag one table to the canvas and drop it on top of another table. This will create a join between them based on a common field.

Click on the join icon between the tables and select Full Outer Join from the drop-down list. This will change the join type to full outer join and show all rows from both tables.

Optionally, you can add or remove join clauses by clicking on Add or Remove buttons next to each clause. You can also change or rename fields by clicking on them.

The other types of joins are not correct for this scenario. An inner join returns only the rows that have a match in both tables, which will exclude any books that are missing from either table. A left join returns all rows from the left table and only the matching rows from the right table, which will exclude any books that are only in the right table. A right join returns all rows from the right table and only the matching rows from the left table, which will exclude any books that are only in the left table. References: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm https://help.tableau.com/current/pro/desktop/en-us/join_types.htm

When combining two datasets that are both incomplete and where it ' s important to retain all data from both sources, a full outer join is appropriate. This type of join ensures that all records from both tables are included in the combined dataset, even if there are no matching records in the other table.

Based on the line chart provided, each point on the line chart represents the average sales for a given month, and the percentage values indicate the change in average sales compared to the previous month. The month of November shows a significant increase from the month of October, indicated by a large upward spike on the chart and a high percentage increase.

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 me n tioned in the other choices are not the standard methods for replacing sheets within a das h board.

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 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 refresh an extract on Tableau Server, you need to select the workbook, select Refresh Extracts, and then add a new extract refresh. You can specify the frequency and time of the refresh, as well as any custom options. You can have multiple extract refreshes for the same workbook with different schedules. References: https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm

On Tableau Server, you can manage the scheduling of extract refreshes by selecting the specific workbook and configuring additional refresh schedules as needed. This allows for multiple refresh triggers, such as the regular Monday at 10:00 AM schedule, as well as an additional trigger for the last day of the month at 18:00.

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.

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.