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

By default, both field names are present in the Union, but contain several null values!

When field names in the union do not match, fields in the union contain null values. You can merge the non-matching fields into a single field using the merge option to remove the null values. When you use the merge option, the original fields are replaced by a new field that displays the first non-null value for each row in the non-matching fields.

You can also create your own calculation or, if possible, modify the underlying data to combine the non-matching fields.

For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016," "June2016," and "July2016."

Table Description automatically generated

A union of these tables creates the following single table that contains all rows from all tables.

Now suppose a fourth table, "August2016", is added to the underlying data. Instead of the standard "Customer" field name, it contains an abbreviated version called "Cust."

Explanation

THIS IS A VERY IMPORTANT QUESTION

To answer this question, you need to understand Tableau's Order of Operations. See below and remember this always:

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:

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

By default, all of the above mentioned are stored in Documents -> My Tableau Repository

In Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.

A story is a sheet, so the methods you use to create, name, and manage worksheets and dashboards also apply to stories (for more details, see Workbooks and Sheets). At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet (worksheet or dashboard) in a story is called a story point.

When you share a story —for example, by publishing a workbook to Tableau Public, Tableau Server, or Tableau Online—users can interact with the story to reveal new findings or ask new questions of the data.

Explanation

One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0–5, 6–10, 11–15, and so on. Then you can count the number of people in each age group.

Create a calculated field for variable bin size

Step 1

Select Analysis > Create Calculated Field.

Step 2

In the Calculated Field dialog box, complete the following steps:

To display the complete list of potential data connections when connecting to a server in Tableau, you should select "More" under the "To a Server" option. This action will provide a comprehensive list of server types and data sources that Tableau can connect to.

From the official documentation:

The default view that you first see in the Data Source page canvas is the logical layer of the data source. You combine data in the logical layer using relationships (or noodles).

By default, measures placed in a view are aggregated. Mostly you'll notice that the aggregation is SUM, but not ALWAYS.

The type of aggregation applied varies depending on the context of the view.

Dashboard actions in Tableau are interactive elements that can be used to create a more dynamic experience. These actions can be set to filter data on the dashboard, highlight specific elements, or even direct the user to a URL when interacting with a visualization. They can be triggered by user interaction such as hover, selection, or accessing a context menu. Moreover, dashboard actions can have multiple source sheets (where the action originates) and target sheets (where the action takes effect), allowing for a complex interactivity between different parts of the dashboard.