Tableau Updated Desktop-Specialist Exam Questions and Answers by saint

Explanation

The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining data on based on those common fields. The result of combining data using a join is a virtual table that is typically extended horizontally by adding columns of data.

For example, consider the following two tables originating from a single data source:

We can combine these 2 tables, simply by joining the tables on ID to answer questions like, "How much was paid in royalties for authors from a given publisher?". By combining tables using a join, you can view and use related data from different tables in your analysis.

It is very much possible to specify the formatting at a WORKBOOK level (all sheets) instead of a single worksheet level.

You can quickly change how fonts, titles, and lines look in every view in a workbook by specifying format settings at the workbook level, instead of the worksheet level.

For example, you might want to use a specific font, size, and color so that all views adhere to your company's brand. You might also want to remove grid lines from your views—or make them more noticeable by increasing their pixel size or color.

You can also change the theme used by your workbook. Themes control items like the default font, colors, and line thickness. When you create a new workbook, it automatically uses the Default theme, which uses visual best practices.

Change fonts in your workbook:

You can change all fonts in your workbook or you can change fonts for only certain areas, such as just worksheet titles.

1) On the Format menu, select Workbook.

2) The Format Workbook pane replaces the Data pane on the left and provides a series of drop-down lists where you can change all font settings in a workbook, as well as the font settings for titles of worksheets, stories, and dashboards.

Note: If you have made font changes at the worksheet level, such as on a filter card or a worksheet title, changing the font at the WORKBOOK level will overwrite those changes.

Reset a workbook to its default settings

When you make changes to your workbook's font settings, a gray dot appears next to the setting in the Format Workbook pane. You can quickly switch back to default settings using the Reset to Defaults button.

1) On the Format menu, select Workbook.

2) In the Format Workbook pane, click Reset to Defaults.

Graphical user interface, application Description automatically generated

Explanation

If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.

To reach the correct answer, follow the steps below:

1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!

Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!

• The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October

Explanation

Yes, it is possible to create worksheet-specific filters in Tableau.

When you add a filter to a worksheet, by default it applies to the current worksheet. Sometimes, however, you might want to apply the filter to other worksheets in the workbook.

Then, you can select specific worksheets to apply the filter to or apply it globally to all worksheets that use the same data source or related data sources.