Desktop-Specialist Exam Dumps - Tableau Desktop Specialist Questions and Answers

Explanation

Bin are a user-defined grouping of numerical data in the data source.

According to the official Tableau documentation: It's sometimes useful to convert a continuous measure (or a numeric dimension) into bins.

Have a look at the following image. When we right click a measure, we get the following options:

However, for a dimension (this is because the DATA TYPE of this dimension is a string:

But what if we have a dimension of type NUMBER (NUMERIC DIMENSION)? See below:

We can clearly create bins from dimensions too - they just have to be numeric :)

For more information, please refer to : https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm

Explanation

This is true, indeed!

The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.

To apply bold text formatting to rows or columns independently in Tableau, you should use the Rows tab or the Columns tab on the Format Font pane. This approach provides control over the formatting of text within individual rows or columns. By selecting the appropriate tab (Rows or Columns), you can apply formatting settings, including bold text, to only the selected rows or columns. This is a crucial feature for enhancing the readability and visual appeal of specific parts of a Tableau worksheet, allowing for emphasis on particular data points or categories.

Lot of students have been seeing this question in the exam lately, and wanted me to include this question so here it is. Follow along -

1) Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option

Graphical user interface Description automatically generatedGraphical user interface, application, Word Description automatically generated

2) Click on Tooltip in the Marks card, and select bold.

Graphical user interface, application Description automatically generated

Graphical user interface, application, Word Description automatically generated

3) Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold.

A picture containing line chart Description automatically generatedGraphical user interface Description automatically generated

There exists no option to Bold the tooltip contents by clicking Analysis. Hence, it is an incorrect choice.

The following options are available in the Device preview section when creating a Dashboard:

Graphical user interface Description automatically generated

Explanation

Tableau recognises a CSV file as a TEXT file, and therefore it is the correct option.

The following are the steps to import a CSV file:

1) From the data connection screen, click on Text:

2) Choose the appropriate file, and click Open:

3) Finally, Tableau imports the data as shown below:

When you click Salt Lake City in the view, the URL action will direct you to https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City. A URL action is a hyperlink that points to a web page or other web-based resource outside of Tableau. You can use URL actions to create an email or link to additional information about your data.  To customize links based on your data, you can automatically enter field values as parameters in URLs3 In this case, the URL action uses https://en.wikipedia.org/wiki/ as the URL target, where is a field value from the view. When you click Salt Lake City in the view, Tableau will replace with Salt Lake City in the URL target. However, since spaces are not allowed in URLs, Tableau will encode them as + signs instead. Therefore, the final URL will be https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City 3 The other options are not correct because they do not reflect how Tableau encodes field values in URL actions.

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

According to the official documentation:

Joins are a more static way to combine data. Joins must be defined between physical tables up front, before analysis, and can’t be changed without impacting all sheets using that data source. Joined tables are always merged into a single table. As a result, sometimes joined data is missing unmatched values, or duplicates aggregated values.

Joins -

1) Are displayed with Venn diagram icons between physical tables

2) Require you to select join types and join clauses

3) Joined physical tables are merged into a single logical table with a fixed combination of data

4) May drop unmatched measure values

5) May duplicate aggregate values when fields are at different levels of detail

6) Support scenarios that require a single table of data, such as extract filters and aggregation

Explanation

Trend lines have become popular questions in recent Tableau examinations. Follow along:

1) First drag Sales to the Rows shelf and Profit to the Columns shelf:

c

You will only see a single mark since the view is aggregated.

2) Now, break down this view by state. Drag State into Detail on the Marks shelf ( or directly to the view):

3) Finally, move to the Analytics pane, and drag Trend line to the view. When you drag it, select the Linear option!:

4) The following is our view. Hover over the trend line to see the R-squared value: