Wednesday, January 10, 2024

Lesson 41 - Decomposition Tree in Power BI Desktop

Power BI has many features or visuals in analyzing the data, Here the decomposition tree which allows us to breakdown into hierarchies and analyze the data in an interactive way. Decomposition tree also known for Artificial Intelligence Visualization.

In the below blog post will guide through the process of creating Decomposition Tree in Power BI.

How to Proceed?

Step 1 

Launch power BI desktop app and open the new report page and import the data required. 

Step 2 

In “visualizations” pane click on “Decomposition Tree” which is highlighted in the given figure. 
Step 3

Drag the data fields into “Field Section “that we want to and analyze.
Analyze: Metric value we want to analyze – Count of Medal

Explain by: One or more Dimension need to be drill down – Region, Gender
We can show further information about data using Tooltip option

Step 4 Features of Decomposition Tree

In this visual we have chosen “Count of Medal” as the metric and further drilling down by Region and Gender dimensions. Every time when we add a dimension to the metric it asks for a “High value”, “Low Value” and the respective field name. Here I choosed the High Value.

Highest value will be represented as a dotted line. Also u can see the Bulb Icon above which is the feature called “AI Splits”
AI Splits is the feature of decomposition Tree which has the ability to find out the highest and lowest value of our data.
When we hover on the bulb icon it also displays an explanation as a tooltip.

To make use of this AI features we should Enable AI splits on under format section

Step 5

Filters in the chart are like special tools that allow us to focus on specific parts of the data, making it easier to understand. In this visual we Excluded the “No Medal” count.

Step 6

Customizing the appearance of Decomposition Tree
You can customize the appearance of the visual.  
Gave suitable title for the visual and customize the font size, colour and position of the title.

We can customize the space related settings for the tree nodes under Tree settings.

Here in the Tree, the bars representing the categorical data. We can adjust the nodes bar by using this bar settings
Likewise, we can customize the colors of the bar represented in the tree, their background etc.

We have an option “Conditional Formatting” where can customize the data bar color

Click on the 3 dotted line on the header icon of the visual to export the data or to sort the data based on the requirements

Report creator can lock the particular levels where it can’t be removed or changed. Hence users can explore different level of hierarchies but they can’t change or move the levels
Step 7 Save the visual

Finally, Decomposition Tree is ready. Click save button to save the visual.

When to use Decomposition Tree?

Decomposition tree can be used when we need to analyze the metrics which can be broken down into multiple categories also, we can use this when we need to understand the KPI’s.

  • Easy to understand
  • Interactive visual
  • Effective communication of complex data into meaningful insights
  • AI features
  • It is not suitable for all types of visualizations 
  • Become clumsy if add multiple nodes.

The Decomposition Tree in Power BI is a valuable tool for exploring and analyzing complex hierarchical data. It is particularly effective for gaining insights about metrics and its categories. Having AI features is the added advantage to this visual in Power BI.

Tags Power BI
Useful links
MS Learn Modules
Test Your Knowledge Quiz

No comments:

Post a Comment