Tableau Desktop-Specialist - Tableau Desktop Specialist Exam

The beauty of context filters is that according to Tableau's Order of Operations, they are executed before Sets.

Diagram Description automatically generated

This means that based on what Region's you've selected - Tableau will first only preserve the rows for those Regions. THEN, after this it will compute the Set , i.e , Bottom 10 products in each Region.

1) First let's create a set to compute the Bottom 10 Products by Profit.

2) Next, take region on the Rows Shelf followed by the Set we just created. Drag Region and the Set to the Filters Shelf as well.

3) Now, try to only visualize the data for the South Region:

4) The problem right now is that Tableau is computing the Set first (Bottom 10 Products), and then applying the Dimension Filter - South Region and hence these values are incorrect. Note how these aren't even 10 products, but rather just 8. To fix this, simply add Region to Context:

Upon doing this, we get the correct answer as : 

References: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm

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

Explanation

To update the font of an entire workbook in Tableau, you should use the "Format Workbook" pane. This feature allows you to set and modify the default font settings for the entire workbook, ensuring consistency in font style across all sheets and dashboards. It's a global setting that applies to all visual elements in the workbook, including titles, captions, axis labels, and other text elements.

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

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:

According to the [Tableau Desktop Specialist Exam Guide], an incremental refresh only adds rows that are new, based on a specified column and value. A full refresh replaces all the extracted data with the data in the underlying data source. A full refresh is usually very slow, especially for large extracts. An incremental refresh can take less time, depending on how many new rows are added. A full refresh does not need to be configured, it is the default option for extracts in Tableau. An incremental refresh can be run from both Tableau Desktop and Tableau Server.

To display multiple distinct lines on the same axis based on a field, you should place the field on the Color shelf in the Marks card. This will encode each distinct value in the Region field with a different color, resulting in separate lines for each region on the same axis.

The Shape option is available for scatter plots and packed bubbles views. The Shape option allows you to change the shape of marks in the view by selecting from a predefined set of shapes or adding custom shapes. You can access the Shape option by placing any field on Shape on the Marks card4 Scatter plots are views that show the relationship between two numerical variables by plotting them as coordinates on a Cartesian plane. You can create a scatter plot by placing at least one measure on Columns and at least one measure on Rows on the Marks card. You can then use Shape to assign different shapes to different categories or segments in your data5 Packed bubbles are views that show hierarchical data as a set of nested circles. Each circle represents a dimension member and its size is proportional to a measure value. You can create a packed bubble chart by placing one or more dimensions on Detail and one measure on Size on the Marks card. You can then use Shape to change the shape of circles to other shapes such as squares or stars6 The other options are not valid views for using the Shape option. Side-by-side circles are views that show proportions of a whole by using circles with different angles and sizes arranged horizontally or vertically. You can create a side-by-side circle chart by placing one dimension on Columns or Rows and one measure on Angle and Size on the Marks card. You cannot use Shape to change the shape of circles in this view7 Heat maps are views that show the distribution of two or more measures by using a color gradient and size. You can create a heat map by placing one or more dimensions on Columns and Rows and two measures on Color and Size on the Marks card. You cannot use Shape to change the shape of marks in this view8

*Very important question*

If we select the labels in the view and then group, a new consolidated mark is created - in our case bar since we are talking about a bar chart in the question. See below:

Then on grouping, a new bar is created, and the colour of all bars remain the same.

Had we grouped by choosing the marks instead of the labels, the following would be the result:

You can change the scope of a reference line by choosing one of the following options: Per Pane, Entire Table, or Per Cell. The scope determines how many reference lines are added to the view and how they are calculated. Per Pane adds one reference line for each pane in the view. Entire Table adds one reference line for the entire table in the view. Per Cell adds one reference line for each cell in the view