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
Step 3
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
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.
Pros
- Easy to understand
- Interactive visual
- Effective communication of complex data into meaningful insights
- AI features
Cons
- It is not suitable for all types of visualizations
- Become clumsy if add multiple nodes.
Conclusion
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