TDS-C01 Exam Dumps - Tableau Desktop Specialist

When creating a date filter in Tableau, anchor refers to the date in a relative-date filter to which you anchor a unit of time. A relative-date filter is a type of filter that allows you to dynamically filter data based on a range of time relative to the current date or a specific date. For example, you can use a relative-date filter to show data for the last 7 days, the next 3 months, or the current quarter1 To create a relative-date filter, you need to specify the following options: The date field that you want to filter. The unit of time that you want to use for the filter, such as days, weeks, months, quarters, or years. The range of time that you want to show relative to the anchor date, such as last, next, this, or to date. The anchor date that you want to use as the reference point for the filter. You can use the current date or a custom date as the anchor date1 For example, if you want to create a relative-date filter that shows data for the last 3 months from January 1st, 2022, you would select the following options: Date field: Order Date Unit of time: Months Range of time: Last 3 Anchor date: Custom (01/01/2022) 1 The other options are not valid definitions of anchor when creating a date filter in Tableau. The mid-point in the range of displayed dates is not related to the anchor date, but rather to the center of the axis that represents the date field. The date in a range-of-dates filter to which you anchor units of time is not correct, because a range-of-dates filter does not use an anchor date, but rather a start and end date that can be fixed or dynamic. The latest date in the data source that can be found is not related to the anchor date, but rather to the maximum value of the date field in the data source2

In Tableau, you can rename a field directly in the Data pane by clicking and holding on the field name until it becomes editable, allowing you to type a new name. Alternatively, you can use the drop-down menu associated with the field in the Data pane and select the "Rename" option. Both methods provide a quick and easy way to change the name of a field without affecting the underlying data structure. The "Format menu" and "Replace References" option do not apply to renaming fields.

Explanation

After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.

Graphical user interface, chart, line chart Description automatically generated

To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.

In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis.

If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.

In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.

To create a stacked bar chart in Tableau, you can drag a second dimension to the Color shelf on the Marks card. This action will segment the bars already present in the chart by the new dimension, stacking the segments on top of each other within each bar. This is a common method to add additional layers of detail to a bar chart and effectively compare parts to a whole across categories.

Explanation

It is possible in Tableau to use a sheet within a story directly.

Moreover, 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.

At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.

When creating a group by selecting headers in a Tableau view, the newly created grouped dimension replaces the original dimension field on either the Rows or Columns shelf. This grouping action aggregates the selected headers into a single group, and this new group dimension is automatically placed in the view, replacing the original dimension. This functionality allows for more simplified and customized categorization within the data visualization, enhancing the ability to analyze and interpret data according to specific groupings.

If you’ve created a data connection that you might want to use with other workbooks or share with colleagues, you can export (save) the data source to a file. You might want to do this also if you’ve added joined tables, default properties, or custom fields—such as groups, sets, calculated fields, and binned fields—to the Data pane.

Visualisations and Data extracts are NOT saved in a .tds file!

Explanation

When you connect to a data source, Tableau automatically separates date fields into hierarchies so you can easily break down the viz. You can also create your own custom hierarchies. For example, if you have a set of fields named Region, State, and County, you can create a hierarchy from these fields so that you can quickly drill down between levels in the viz.