Pass the Tableau Desktop Specialist Desktop-Specialist Questions and answers with ExamsMirror

You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names.

When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.

To access bolding options for the text in a tooltip in Tableau, you can:

Select Tooltip on the Marks card, which allows you to edit the tooltip for the specific marks.

Select Worksheet on the menu, and then Tooltip, to open the tooltip editor for the worksheet.

Right-click on the Field and select Format, which lets you format the text including bolding options in the tooltip.

Explanation

Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.

Explanation

Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.

You can add reference lines, bands, distributions, or (in Tableau Desktop but not on the web) box plots to any continuous axis in the view.

Reference Lines - You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line.

The Tableau workspace consists of menus, a toolbar, the Data pane, cards and shelves, and one or more sheets. Sheets can be worksheets, dashboards, or stories. For details on dashboard or story workspaces, see Create a Dashboard or The Story Workspace.

Graphical user interface, application Description automatically generated

The main thing you do in the workspace is to create visualisations to analyze your data.

Renaming data fields, cleaning the data, previewing the data can all be done in the Data source window.

Explanation

We can drag fields from the Data pane to create the structure for your visualizations.

The Columns shelf creates the columns of a table, while the Rows shelf creates the rows of a table. You can place any number of fields on these shelves.

These FIELDS are also referred to as PILLS. See below:

From the official documentation:

When you have a view with a large amount of data you might want to explore your data interactively and highlight a specific mark or group of marks while still maintaining the context of where those marks show in your view.

To do this you can turn on the Highlighter for one or more discrete fields that are included in your view and that affect the level of detail

Example - Here we just want to focus on Public Affairs college dimension, but don't want to filter out or remove the rest of the data:

Chart, scatter chart Description automatically generated

Note that filtering is not the correct option since that would REMOVE the data that doesn't match the filtering criteria.

Reference : https://help.tableau.com/current/pro/desktop/en-us/actions_highlight_highlighter.htm

Explanation

The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. Consider 2 tables "Orders" and "Customers".

If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!

Explanation

TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn’t contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.

Create a .twbx with file-based data sources

1) Select File > Save As.

2) Specify a file name for the packaged workbook in the Save As dialog box.

3)Select Tableau Packaged Workbooks on the Save as type drop-down list.

4) Click Save.

5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose.

The following files are included in packaged workbooks:

--> Background images

--> Custom geocoding

--> Custom shapes

--> Local cube files

--> Microsoft Access files

--> Microsoft Excel files

--> Tableau extract files (.hyper or .tde)

--> Text files (.csv, .txt, etc.)