Desktop-Specialist Exam Results

Explanation

The word 'static tool' gives it away.

According to the official website :

Two use cases for creating hierarchies from the Data pane are to add drilldown functionality for fields and to organize related fields together. A hierarchy is a way of organizing data into different levels of detail. For example, a date hierarchy can have year, quarter, month, and day levels. A geographic hierarchy can have country, state, city, and zip code levels. By creating hierarchies from the Data pane, you can quickly drill down or up in a hierarchy to add or subtract more levels of detail in the view. You can also use hierarchies to group related fields together in the Data pane, making it easier to find and use them14 The other options are not valid use cases for creating hierarchies from the Data pane. To concatenate all fields into a single field, you need to use a calculated field or a join, not a hierarchy. To create faster-performing queries, you need to optimize your data source, filters, calculations, or extracts, not create hierarchies

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

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: