Delving Deeper: Unveiling Hierarchies with Tableau Treemaps and Sunbursts



 Tableau empowers you to navigate and analyze data that has a layered structure. This article explores treemaps and sunbursts, powerful tools for visualizing and understanding hierarchical relationships within your data. We'll delve into creating treemaps and sunbursts, exploring data at different hierarchical levels, and configuring these visualizations with size, color, and label encodings for effective data storytelling.

1. Demystifying Hierarchy: Nested Relationships in Data

Hierarchical Data:

  • Represents data with nested or layered relationships, resembling an organizational chart.
  • Examples include product categories (subcategories within categories), sales regions (countries within regions), or employee hierarchies (departments within divisions).

Benefits of Analyzing Hierarchies:

  • Identify Patterns: Understand how data is distributed across different levels of the hierarchy.
  • Drill-Down Analysis: Explore details within specific branches of the hierarchy.
  • Data Storytelling: Communicate complex relationships and patterns within your data effectively.

2. Unveiling the Structure: Treemaps and Sunbursts

Treemaps and Sunbursts Explained:

  • Both visualize hierarchical data:
    • Treemaps: Utilize nested rectangles to depict the hierarchy, with rectangle size corresponding to a measure's value for that branch.
    • Sunbursts: Employ circular segments to represent the hierarchy, with segment size again reflecting the measure's value.

Choosing Between Treemaps and Sunbursts:

  • Treemaps: Ideal for displaying large hierarchies with many branches, allowing for a detailed view of the entire structure.
  • Sunbursts: Well-suited for smaller hierarchies or emphasizing radial comparisons between branches.

3. Building a Treemap in Tableau

Creating a Basic Treemap:

  1. Drag the dimension representing the top level of your hierarchy onto the "Columns" shelf.
  2. Drag subsequent dimensions representing lower levels (child nodes) onto the "Columns" shelf while holding the "Ctrl" key (Windows) or "Command" key (Mac).
  3. Drag the measure you want to visualize onto the "Size" shelf.
  4. Change the mark type to "Treemap" using the "Show Me" pane or the Marks Card.

Exploring Hierarchical Levels:

  • Utilize Tableau's drill-down functionality: click on a specific rectangle to zoom in and explore data for that particular branch in greater detail.
  • This allows you to navigate through the hierarchy and analyze data at different levels.

4. Enhancing the Visualization: Size, Color, and Labels

Size Encoding:

  • Utilize the size of each rectangle or segment to represent the measure's value for that branch of the hierarchy.
  • Larger areas signify larger values, providing a visual representation of relative contribution within the hierarchy.

Color Encoding:

  • Assign colors to different levels of the hierarchy or use color to represent another dimension within the data.
  • This can enhance visual differentiation and highlight specific patterns within the hierarchy.

Label Encoding:

  • Display labels within the rectangles or segments to show the names of the corresponding categories or data points.
  • This provides additional context and improves the readability of your treemap or sunburst.

5. Beyond the Basics: Explore Further

  • Utilize nested sets within Tableau to create custom groupings within your hierarchy for a more focused analysis.
  • Leverage calculated fields in conjunction with treemaps or sunbursts to create custom metrics specific to your data structure.
  • Explore parameters in Tableau to allow viewers to interactively change the level of detail displayed within the hierarchy.


By mastering treemaps and sunbursts in Tableau, you gain powerful tools for analyzing and communicating hierarchical data. These visualizations enable you to navigate through nested relationships, identify patterns across different levels, and ultimately gain a deeper understanding of the structure and organization within your data.

No comments:

Post a Comment

Azure Data Engineering: An Overview of Azure Databricks and Its Capabilities for Machine Learning and Data Processing

In the rapidly evolving landscape of data analytics, organizations are increasingly seeking powerful tools to process and analyze vast amoun...