Visualizing Data Returns with Pareto Charts in Tableau

This video is part of a self-paced learning series on Tableau, focused on creating data visualizations using Pareto Charts. The video explains how to connect and merge data sets using joins, and guides viewers through creating a Pareto Chart with sample superstore data. The visualizations highlight the returns data, showing qualitative insights into product performance and areas for improvement.

What will you learn

1. How to connect to the sample superstore data in Tableau.
2. The process of adding and merging returns data using joins.
3. Steps to create a Pareto Chart in Tableau.
4. How to use calculated fields to count returns.
5. Techniques to add a secondary axis for percentage contribution.
6. The use of table calculations for running totals and percentages.
7. Customizing charts with different colors and chart types.

Takeaway notes

• Pareto Charts are used for qualitative data analysis.
• Inner joins are used to merge datasets with a common field.
• Calculated fields can be used to count specific conditions (e.g., number of returns).
• Dual-axis charts combine bar and line charts to offer additional insights.
• Table calculations help in calculating running totals and percentage contributions.
• Pareto Charts help identify major issues and focus areas in data.

Practice questions

1. What is the primary purpose of a Pareto chart?
2. Describe the steps to connect to the sample superstore data in Tableau.
3. How do you add and merge returns data in Tableau?
4. Explain the concept and importance of an inner join.
5. How can you create a calculated field to count the number of returns in Tableau?
6. What does adding a secondary axis in a chart help you achieve?
7. How can you customize the colors in a Tableau chart for better visualization?
8. What are the differences between a bar chart and a line chart in a dual-axis setup?
9. Explain how to introduce a table calculation in Tableau.
10. Describe the steps to calculate a running total in a Pareto chart.
11. How do you add and edit a secondary calculation in a table calculation?
12. What insights can a company gain from analyzing a Pareto Chart?
13. Why is it important to convert raw numbers into percentages in a Pareto chart?
14. How do dual-axis charts enhance data visualization?
15. Explain the process of switching rows and columns in a chart setup in Tableau.