Mastering Visualization of Categorical Data in Tableau

Welcome to the Tableau self-based learning series! This episode delves into advanced data visualization techniques for categorical data. By using the sample superstore dataset, we'll explore how to generate insightful subcategory level sales charts and compare different segments using bar charts and 100% stacked bar charts.

What will you learn

• Understand what categorical variables are and how they function in Tableau.
• Learn how to create subcategory level sales charts.
• Explore the benefits and use cases of basic bar charts and column charts.
• Discover how to add segments to bars for detailed comparisons.
• Master the technique of creating 100% stacked bar charts for proportionate analysis.
• Learn how to use Tableau's table calculation feature for advanced data manipulation.
• Understand how to compute using specific dimensions for accurate data representation.
• Gain practical skills in visualizing and comparing categorical data effectively.

Takeaway notes

• Categorical variables are the dimensions like subcategory, customer name, and city category.
• Bar and column charts are ideal for comparing different subcategories against one another.
• Segments can be added to bars to provide more detailed breakdowns (e.g., consumer, corporate, home office).
• 100% stacked bar charts are useful for comparing the proportion of segments within the total category.
• Table calculations in Tableau can be leveraged to compute percentages of a total.
• Specific dimension settings help in refining the data representation for accurate visualization insights.

Practice questions

1. What are categorical variables and how are they represented in Tableau?
2. Describe the steps to create a subcategory level sales chart in Tableau.
3. How does Tableau initially visualize categorical data when subcategories and sales are added?
4. Explain how adding segments to bars helps in comparing different types of information.
5. What purpose does a 100% stacked bar chart serve?
6. Describe the procedure to convert a stacked bar chart into a 100% stacked bar chart using table calculations.
7. Why is it important to use specific dimensions when adding table calculations to a chart?
8. How can you drag and drop segments into the color field and what does it represent?
9. What steps are involved in adding labels to a stacked bar chart for better visualization?
10. Discuss the benefits of using bar charts versus 100% stacked bar charts in analyzing categorical data.
11. How do you add table calculations in Tableau? Outline the steps.
12. What might be some use cases for using 100% stacked bar charts in business analysis?
13. Give an example of when you would use subcategory level visualization in real-world scenarios.
14. What happens when you leave the segment checked and uncheck the subcategory in table calculations?
15. How does converting to percentage of total enhance the understanding of segment contributions?