TDS-C01: Improve crosstab and compare two groups to all remaining hotel chains?

Question

You create a crosstab that shows a list of 100 hotel chains alongside their average nightly cost. You also create two groups showing, respectively, the top 10 and bottom 10 hotel chains by cost, with subtotals. What should you do to improve the crosstab and compare the two groups to all the remaining hotel chains?

A. Create a new view.
B. Color encode the hotel chain names.
C. Include an Other group.
D. Include the Summary card.

Answer

C. Include an Other group.

Explanation

The correct answer is C. Include an Other group.

Including an Other group will allow you to compare the two groups to all the remaining hotel chains. This will give you a better understanding of how the two groups compare to the overall distribution of hotel chains.

The other options are incorrect for the following reasons:

• Option A creates a new view. This would not allow you to compare the two groups to all the remaining hotel chains.
• Option B color encodes the hotel chain names. This would make the crosstab more visually appealing, but it would not allow you to compare the two groups to all the remaining hotel chains.
• Option D includes the Summary card. The Summary card provides a high-level overview of the data, but it does not allow you to compare the two groups to all the remaining hotel chains.

Therefore, the only option that will allow you to improve the crosstab and compare the two groups to all the remaining hotel chains is C. Include an Other group.

Here are the steps on how to include an Other group in a Tableau crosstab:

1. Right-click on the crosstab and select “Edit”.
2. In the “Dimensions” pane, click on the “Other” button.
3. In the “Other” dialog box, select the dimensions that you want to include in the Other group.
4. Click on the “OK” button.

The Other group will be added to the crosstab. The Other group will contain all the hotels that are not in the top 10 or bottom 10 groups.

Reference

• Question Detail (tableau.com)
• Group Your Data – Tableau
• Building a Text Table with Multiple Measures | Tableau Software
• Crosstab (Automatic Grouping & Sorting) Hints-and-Tricks (tableau.com)
• Building a Text Table with Multiple Measures | Tableau Software

Tableau Desktop Specialist TDS-C01 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Tableau Desktop Specialist TDS-C01 exam and earn Tableau Desktop Specialist TDS-C01 certification.