Master Tableau From Scratch

Learn Tableau fundamentals, data connections, data preparation, filtering, data modeling, calculations, LOD expressions, visualizations, dashboards, and storytelling through structured practical lessons.

COURSE SYLLABUS

Advanced Chart Types in Tableau

Learn how to create advanced visualizations in Tableau using treemaps, packed bubbles, box plots, histograms, waterfall charts, dual-axis charts, and other analytical charts.

1. Introduction to Advanced Chart Types

Tableau provides a wide range of visualization options to help users understand complex datasets. Basic charts such as bar charts, line charts, and pie charts are useful for common reporting requirements. However, some business problems require more specialized visualizations.

Advanced chart types help users explore distributions, relationships, proportions, variations, trends, and comparisons between multiple measures. They can reveal patterns that may not be immediately visible in a traditional chart.

Tableau supports several advanced visualizations, including treemaps, packed bubbles, histograms, box-and-whisker plots, dual-axis charts, and density maps. Some charts can be created through Show Me, while others require calculated fields, table calculations, or additional shelf configuration.

Important: The purpose of an advanced chart is not simply to make a dashboard look attractive. Select a chart based on the analytical question and the type of information you want to communicate.

2. Why Use Advanced Visualizations?

Advanced visualizations help analysts communicate detailed information in a meaningful and understandable format. They are useful when a dataset contains multiple categories, measures, or analytical patterns.

Major Benefits

  • Identify complex patterns in large datasets.
  • Understand the distribution of numerical values.
  • Compare multiple measures in one visualization.
  • Analyze relationships between business variables.
  • Identify outliers and unusual observations.
  • Understand hierarchical data structures.
  • Improve business reporting and decision-making.
  • Communicate analytical results more effectively.

3. Common Advanced Chart Types in Tableau

Chart Type Purpose Example Use
Treemap Displays hierarchical data using nested rectangles. Sales by Category and Subcategory.
Packed Bubble Compares values using differently sized circles. Revenue by Product.
Histogram Shows the frequency distribution of numerical values. Customer purchase distribution.
Box Plot Displays distribution, quartiles, and potential outliers. Salary distribution by department.
Waterfall Chart Shows how positive and negative values affect a running total. Revenue and expense analysis.
Dual-Axis Chart Displays two measures using separate axes. Sales and Profit comparison.
Bullet Graph Compares actual performance against a target. Sales performance against target.
Density Map Displays geographic concentration using color intensity. Customer concentration by location.

4. Treemap Chart in Tableau

A Treemap displays hierarchical data using a collection of nested rectangles. Each rectangle represents a category or subcategory, and its size is determined by a numerical measure.

Treemaps are useful when users want to compare the contribution of different categories to a total value while viewing multiple levels of a hierarchy.

Example: Sales by Product Category

Suppose an organization wants to understand how much each product category contributes to total sales.

Steps to Create a Treemap

  1. Connect to a sales dataset.
  2. Open a new worksheet.
  3. Select Category from the Data pane.
  4. Select Sales as the numerical measure.
  5. Open Show Me.
  6. Select Treemap.
  7. Drag Subcategory to Detail if you need another hierarchy level.
  8. Use Sales on Size and Color.
  9. Add Category or Subcategory to Label.

Important Treemap Properties

  • Size: Controls the area of each rectangle.
  • Color: Represents a measure or category.
  • Label: Displays category names or values.
  • Detail: Adds additional levels of information.
Business Example: A retail manager can use a treemap to identify which product categories contribute the most to total revenue and which categories have comparatively smaller contributions.
Treemaps are effective for hierarchical part-to-whole comparisons, but exact comparisons between similarly sized rectangles can be difficult. Use labels or tooltips when precise values matter.

5. Packed Bubble Chart

A Packed Bubble chart represents data using circles of different sizes. Each circle represents a data member, and the size of the circle is determined by a selected numerical measure.

Packed Bubble charts are useful for comparing relative values across categories. They provide a visual overview of which categories have larger or smaller values.

Example: Revenue by Product

  1. Open a new worksheet.
  2. Drag Product Name to Detail.
  3. Drag Sales to Size.
  4. Drag Category to Color.
  5. Open Show Me.
  6. Select Packed Bubbles.
  7. Add Product Name and Sales to Label if required.

Important Properties

  • Size: Controls bubble size.
  • Color: Separates categories or represents another measure.
  • Label: Displays product names or values.
  • Tooltip: Provides additional information when users hover over a bubble.
Business Example: An e-commerce company can display its products as bubbles, where larger bubbles represent higher sales. Category colors help distinguish different product groups.
Packed Bubble charts do not use a conventional coordinate axis for exact comparisons. For precise value comparison, consider using a bar chart.

6. Treemap and Packed Bubble Visualization

The following diagram illustrates two different approaches to representing category values. Treemaps use rectangle areas, while Packed Bubble charts use circle sizes.

Treemap Electronics Furniture Clothing Accessories Packed Bubbles Electronics Furniture Clothing Rectangle area represents value Circle size represents value

SVG Diagram 1: Comparing Treemap and Packed Bubble charts.

7. Histogram in Tableau

A Histogram displays the frequency distribution of numerical data. It divides a continuous numerical range into intervals called bins. Each bar represents the number of observations that fall within a particular interval.

Example: Customer Purchase Amount Distribution

An online store wants to understand how many customers make purchases within different price ranges.

Steps to Create a Histogram

  1. Open a worksheet.
  2. Locate the numerical field, such as Sales.
  3. Right-click Sales in the Data pane.
  4. Select Create and then Bins.
  5. Configure the bin size.
  6. Drag Sales (bin) to Columns.
  7. Drag Number of Records to Rows, or use an appropriate count measure.
  8. Review the distribution.

Important Histogram Concepts

  • Bin: A numerical interval that groups values.
  • Frequency: Number of observations in a bin.
  • Bin Size: Width of each interval.
  • Distribution: Overall pattern of the values.
Example:

If a purchase amount dataset contains 100 transactions, a histogram can show how many transactions fall into ranges such as ₹0–₹1,000, ₹1,001–₹2,000, and ₹2,001–₹3,000.

The selected bin size affects the appearance of a histogram. Smaller bins show more detail, while larger bins provide a broader overview.

8. Box-and-Whisker Plot

A Box-and-Whisker Plot, commonly called a Box Plot, displays the distribution of numerical data through quartiles, median, and whiskers. It is useful for understanding variability and identifying potential outliers.

Components of a Box Plot

  • Minimum: Lower whisker endpoint under the selected whisker rule.
  • First Quartile (Q1): The 25th percentile.
  • Median (Q2): The 50th percentile.
  • Third Quartile (Q3): The 75th percentile.
  • Maximum: Upper whisker endpoint under the selected whisker rule.
  • Outliers: Observations displayed beyond the whiskers.

Interquartile Range

The Interquartile Range (IQR) measures the spread of the middle 50% of the observations.

IQR = Q3 - Q1

In a commonly used Tukey box plot, the lower and upper fences are calculated as:

Lower Fence = Q1 - (1.5 * IQR)

Upper Fence = Q3 + (1.5 * IQR)

Values beyond these fences may be displayed as potential outliers. They are not necessarily incorrect data points.

Steps to Create a Box Plot

  1. Open a worksheet.
  2. Drag a category such as Department to Columns.
  3. Drag a numerical measure such as Salary to Rows.
  4. Open Show Me.
  5. Select Box-and-Whisker Plot.
  6. Review the median, quartiles, and outliers.
Business Example: An HR analyst can compare salary distributions across departments to understand variation, median salary, and potential outliers.

9. Waterfall Chart

A Waterfall Chart shows how a starting value changes through a series of positive and negative contributions to reach a final value.

It is particularly useful for financial analysis, revenue changes, expense breakdowns, and profit calculations.

Example: Profit Calculation

Business Activity Amount Impact
Starting Revenue ₹1,00,000 Starting Value
Product Cost ₹30,000 Decrease
Operating Expenses ₹20,000 Decrease
Additional Income ₹10,000 Increase
Final Profit ₹60,000 Ending Value

Steps to Create a Waterfall Chart

  1. Prepare a dataset containing categories and signed financial amounts.
  2. Drag the category field to Columns.
  3. Drag the signed amount measure to Rows.
  4. Change the Marks type to Gantt Bar.
  5. Create a running total calculation.
  6. Use the running total as the starting position of the bars.
  7. Use the negative absolute contribution as the Gantt Bar size.
  8. Apply colors to distinguish positive and negative contributions.
  9. Format labels and tooltips.

Running Total Calculation

RUNNING_SUM(SUM([Amount]))

Gantt Bar Size Calculation

-SUM([Amount])
Waterfall charts require careful configuration of the starting position, signed contribution, and table calculation direction. The exact calculation setup depends on the structure of your dataset and the order of the categories.

10. Dual-Axis Chart

A Dual-Axis Chart displays two measures in the same visualization using two axes. It helps users compare different metrics that may have different scales or units.

Example: Sales and Profit

A company wants to compare monthly Sales and Profit in one chart.

Steps to Create a Dual-Axis Chart

  1. Drag Order Date to Columns.
  2. Change the date level to Month.
  3. Drag Sales to Rows.
  4. Drag Profit to Rows beside the Sales axis.
  5. Open the second measure pill menu.
  6. Select Dual Axis.
  7. Configure the Marks cards for both measures.
  8. Select suitable mark types, such as Bar and Line.
  9. Synchronize axes only when their scales and units make comparison meaningful.

Important Considerations

  • Each measure has its own axis unless synchronized.
  • Different mark types can be used for the two measures.
  • Color can distinguish the two measures.
  • Axis titles should clearly identify the units.
  • Dual axes can be misleading if scales are not interpreted correctly.
Synchronizing axes is appropriate only when the measures have compatible units and a common scale makes sense. Do not synchronize unrelated units simply to make lines overlap.

11. Bullet Graph

A Bullet Graph is a compact visualization used to compare actual performance against a target or reference value. It can also display qualitative performance ranges.

Example: Sales Performance

Suppose the monthly sales target is ₹1,00,000 and the actual sales are ₹85,000. A Bullet Graph can display the actual value in relation to the target.

Steps to Create a Bullet Graph

  1. Prepare actual sales and target measures.
  2. Open a worksheet.
  3. Select the category and measure fields required.
  4. Open Show Me.
  5. Select Bullet Graph if the selected fields are suitable.
  6. Review the actual measure and target reference.
  7. Adjust formatting and labels.
Business Example: A sales dashboard can use bullet graphs to compare actual performance against monthly targets across different regions.

12. Density Map

A Density Map represents the concentration of geographic data using color intensity. Areas with a higher concentration of records appear more intense than areas with fewer records.

Example: Customer Distribution

An organization can use a density map to understand where its customers are concentrated and identify areas with a high number of customer records.

Steps to Create a Density Map

  1. Connect to a dataset containing geographic fields.
  2. Verify that Tableau recognizes the geographic roles.
  3. Double-click the geographic field to create a map.
  4. Change the Marks type to Density.
  5. Add a suitable geographic field to Detail if required.
  6. Adjust the intensity and color settings.
  7. Use filters to explore specific regions or periods.
Density Maps show spatial concentration, not necessarily exact totals for administrative regions. Use filled maps or symbol maps when exact geographic boundaries or individual locations are more appropriate.

13. Understanding Distribution and Comparison Charts

Different advanced charts answer different analytical questions. Histograms show frequency, box plots summarize distributions, and dual-axis charts compare two measures.

Histogram Numerical Value Bins Box Plot Potential outlier Upper whisker Median Lower quartile Distribution Summary

SVG Diagram 2: Histogram frequency distribution and Box Plot components.

14. Choosing the Right Advanced Chart

Selecting the right chart is important because different visualizations communicate different types of information. The chart should match the question being asked.

Analytical Requirement Recommended Chart Reason
Compare hierarchical categories Treemap Displays nested category contributions.
Compare relative category sizes Packed Bubble Uses circle sizes to represent values.
Analyze numerical distribution Histogram Shows frequency across numerical bins.
Identify outliers and quartiles Box Plot Summarizes the spread of numerical data.
Explain financial changes Waterfall Chart Shows positive and negative contributions.
Compare two measures Dual-Axis Chart Displays two measures in one view.
Compare actual and target Bullet Graph Shows performance against a reference.
Analyze geographic concentration Density Map Shows spatial concentration patterns.

15. Using Show Me for Advanced Charts

Show Me is a Tableau feature that recommends visualization types based on the selected fields and their data types.

How to Use Show Me

  1. Open a Tableau worksheet.
  2. Select one or more fields in the Data pane.
  3. Click Show Me in the upper-right area.
  4. Review the available chart recommendations.
  5. Select the required visualization.
  6. Adjust the Marks card and shelves.
  7. Format the visualization according to the business requirement.

Important Points

  • Available chart options depend on selected fields.
  • Different charts require different combinations of dimensions and measures.
  • Show Me provides a starting point, not a complete analytical design.
  • Some advanced charts require additional manual configuration.
Best Practice: Use Show Me to quickly create a starting visualization, then refine the chart through the Rows, Columns, Marks, Filters, and Analytics features.

16. Combining Advanced Charts in a Dashboard

Multiple advanced charts can be combined into a single dashboard to provide a broader understanding of business performance.

Example: Retail Business Dashboard

  • Treemap: Sales contribution by category.
  • Packed Bubble: Product-level sales comparison.
  • Histogram: Distribution of order values.
  • Box Plot: Order value distribution by region.
  • Dual-Axis Chart: Monthly Sales and Profit.
  • Density Map: Geographic customer concentration.

Dashboard Creation Steps

  1. Create individual worksheets for each chart.
  2. Choose a new dashboard.
  3. Set an appropriate dashboard size.
  4. Add the required worksheets.
  5. Arrange the charts using tiled or floating layouts.
  6. Add dashboard filters where required.
  7. Configure useful dashboard actions.
  8. Apply consistent titles, labels, and formatting.
  9. Test the dashboard using different selections.
Avoid placing too many charts on one dashboard. Select only the visualizations that contribute to the intended business analysis.

17. Advanced Visualization Dashboard Layout

The following example illustrates how multiple advanced visualizations can be organized into one business dashboard.

Advanced Business Analytics Dashboard Treemap Packed Bubbles Histogram Sales and Profit Trend Geographic Distribution Illustrative dashboard arrangement

SVG Diagram 3: Example layout combining advanced Tableau charts.

18. Best Practices for Advanced Charts

  • Select a chart based on the business question.
  • Use clear titles and descriptive labels.
  • Choose colors that improve interpretation.
  • Avoid unnecessary visual decoration.
  • Use tooltips to provide additional context.
  • Check aggregation and data granularity.
  • Use appropriate number and date formatting.
  • Do not use packed bubbles when precise comparisons are required.
  • Use suitable bin sizes for histograms.
  • Interpret box plot outliers carefully.
  • Label both axes clearly in dual-axis charts.
  • Test dashboard filters and interactions.
  • Keep dashboards readable on different screen sizes.

19. Common Problems and Troubleshooting

Problem 1: Treemap Displays Incorrect Rectangle Sizes

Reason: The wrong measure or aggregation may be used on the Size shelf.

Solution: Verify the measure, aggregation, and level of detail used in the treemap.

Problem 2: Packed Bubbles Are Not Displayed

Reason: The worksheet may not contain the required dimension and measure combination.

Solution: Add a dimension to Detail and a numerical measure to Size before selecting Packed Bubbles.

Problem 3: Histogram Shows Too Many or Too Few Bars

Reason: The bin size may not be appropriate.

Solution: Adjust the bin size to provide a meaningful distribution view.

Problem 4: Box Plot Does Not Display Expected Outliers

Reason: The data distribution, grouping, or whisker configuration may affect the displayed result.

Solution: Review the underlying records, quartiles, and box plot configuration.

Problem 5: Dual-Axis Chart Is Difficult to Understand

Reason: The measures may use different scales or unclear axis labels.

Solution: Clearly label both axes, use distinct mark styles, and review whether synchronization is appropriate.

Problem 6: Waterfall Chart Shows Incorrect Totals

Reason: The running total, sort order, or signed contribution calculation may be incorrect.

Solution: Check the calculation direction, category order, and positive or negative values.

Problem 7: Dashboard Loads Slowly

Reason: Too many worksheets, complex calculations, or large amounts of data may affect performance.

Solution: Reduce unnecessary visualizations, optimize calculations, and review filters and data-source performance.

20. Practical Exercises

Exercise 1: Create a Treemap

Create a treemap showing Sales by Category and Subcategory. Use Sales for Size and Color.

Exercise 2: Create a Packed Bubble Chart

Create a packed bubble chart showing product-level sales. Use Category for Color and Sales for Size.

Exercise 3: Build a Histogram

Create a histogram using Order Value. Experiment with different bin sizes and compare the frequency distribution.

Exercise 4: Build a Box Plot

Compare the distribution of sales across different regions using a Box-and-Whisker Plot.

Exercise 5: Create a Waterfall Chart

Build a financial waterfall chart showing starting revenue, expenses, additional income, and final profit.

Exercise 6: Create a Dual-Axis Chart

Compare monthly Sales and Profit using two axes and different mark types.

Exercise 7: Build an Advanced Dashboard

Combine a treemap, histogram, box plot, and sales trend chart into one dashboard. Add filters and descriptive titles.

Summary

Advanced Chart Types in Tableau help users analyze complex business data through specialized visualizations such as Treemaps, Packed Bubbles, Histograms, Box-and-Whisker Plots, Waterfall Charts, Dual-Axis Charts, Bullet Graphs, and Density Maps. Each chart serves a different analytical purpose, including hierarchical comparisons, numerical distributions, financial analysis, target evaluation, and geographic concentration. Tableau provides Show Me and worksheet configuration options to create these visualizations. By selecting appropriate chart types, using accurate calculations, applying clear formatting, and combining meaningful charts in dashboards, developers can communicate business insights effectively and support better data-driven decisions.