TDS-C01 Tableau Exam Lab Questions

According to the [Tableau Desktop Specialist Exam Guide], a join is a way to combine table columns in relational databases by using shared values. A join can be inner, left, right, or full, depending on how the matching rows are included or excluded.

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

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:

The following showcase how you can show mark labels. Using the Sample Superstore dataset:

1) Let's create a Bar chart showing the sales for each sub-category:

2) Now you can show labels by:

2.1) Click on Show Mark Labels Icon in the Toolbar ( easiest )

2.2) Drag Sales to the Text icon in the Marks Card:

2.3) Click on Analysis -> Show mark labels from the Tableau menu bar: