Tableau TDS-C01 Practice Test - Questions Answers, Page 17

The different aggregations available for a measure determine how the individual values are collected: they can be added (SUM), averaged (AVG), or set to the maximum (MAX) or minimum (MIN) value from the individual row values.

For a complete list of the available aggregations, check out -List of Predefined Aggregations in Tableau.

The level of detail is determined by thedimensionsin your view---for information about the concept of level of detail, seeHow dimensions affect the level of detail in the view.

Disaggregating your data can be useful for analyzing measures that you may want to use both independently and dependently in the view.For example, you may be analyzing the results from a product satisfaction survey with the Age of participants along one axis. You can aggregate the Age field to determine the average age of participants or disaggregate the data to determine at what age participants were most satisfied with the product.

Disaggregating data can be useful when you are viewing data as a scatter plot.SeeExample: Scatter Plots, Aggregation, and Granularity.

According to Tableau's official documentation:

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

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

From the official documentation:

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

A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.

We can create a Bullet graph withjust 2 measures!This method requires theLEASTnumber of fields possible to create this type of chart.

Thebest wayto tackle such questions in the exam is to click the'SHOWME'button on top right, and hover over the chart we want to create.

In our case, it is a Bullet graph.

Therefore, we need 2 measures at least to create this chart, and 0 or more dimensions.

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

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

We know that continuous fields will always create an axis, so options stating 'header' are automatically eliminated. For our question, see below:

Had the question asked us to place this pill on the Rows shelf instead, we would've gotten a different answer:

Names and Categories would be mostly used as dimensions (categorical data).

Profit and measures contain quantitative data and would be more suitable for Measures!

By default, the shape that a Heap map uses is a'Square'.See below: