Most Recent Tableau TDS-C01 Exam Questions & Answers

When using a Percent difference, Tableau calculates what the percent change has occured as compared to the last data value.BUT, for the first data value, there is no previous value to compare it to. Hence, it appears as NULL.

If you answered this question quickly and correctly, you're well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back!

To create a dual axis chart for the problem mentioned:

1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:

2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:

3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:

4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.

Now the chart looks like this:

Now we change the Profit chart type to line:

5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'

And, our final view and answer is:

You can combine two sets to compare the members. When you combine sets you create a new set containing either the combination of all members, just the members that exist in both, or members that exist in one set but not the other.

Combining sets allows you to answer complex questions and compare cohorts of your data. For example, to determine the percentage of customers who purchased both last year and this year, you can combine two sets containing the customers from each year and return only the customers that exist in both sets.

To combine two sets, they must be based on the same dimensions. That is, you can combine a set containing the top customers with another set containing the customers that purchased last year. However, you cannot combine the top customers set with a top products set.

Hierarchies in Tableau are used to define a drill-down path through your data. By creating a hierarchy, you can organize related fields together, which makes it easier to navigate complex data models. This also allows users to explore data at different levels of detail, from the highest level of the hierarchy to the most granular details, simply by clicking to expand and collapse levels of the hierarchy in the view.

To invert the color intensity of a quantitative range in Tableau, you should use the 'Reversed' option. This option inverts the color scheme so that the colors representing the higher values are swapped with those representing the lower values. For example, if a color scale initially shows dark colors for high values and light colors for low values, using 'Reversed' will switch this so that dark colors represent low values and light colors represent high values. This option is particularly useful for better visual distinction and interpretation in certain data scenarios.