I am super excited about all the new features that November 2019 update brought to Power BI Desktop. Complete list is here.
Great new visual for all the data analysts is: decomposition tree.
To enable the decomposition tree, navigate to Options, Preview features and select “Enable Decomposition tree visual”
Import your favorite data set; I am taking:
select * from [dbo].[vTargetMail]
from the AdventureWorksDW database.
In the visualization pane, select the variable from your dataset that you want to analyze and and drag it into the “Analyze”. In the “Explain By” drag and drop all the variables you want to decompose and understand how the variable under Analyze is behaving.
Decomposition tree is a data presentation of slicing and dicing of selected metrics based on the attributes of these metrics or with combination of other metrics. Another great aspect of this visual is to analyze the selected variable with many metrics or attributes (dimensions) as the same time.
With multiple attributes and metrics in the tree, data analysts can play with data, selecting or deselecting different metrics or attributes with clicking on values, of tree branches or on the plus to add another branch or to change the value of the branch.
Worth mentioning are the light bulbs for (both working when AI is enabled)
- High Value – higher value of the split is selected; based on all the features (variables in “Explain by”), the visual suggests which visual is best to split further in order to get higher values.
- Low value – higher value of the split is selected; based on all the features (variables in “Explain by”), the visual suggests which visual is best to split further in order to get higher values.
Both (High and Low) resemble decision tree logic, where Entropy and Information Gain is calculated in order to select best feature and splits, this logic appears very much similar here as well.
“Enable AI splits” must be enabled under the visual settings. And the analysis type is available as relative or absolute.
Another super cool feature with November 2019 update, is refreshed Ribbon. This feature too, can be switched on under Options; new and refreshed Ribbon.
Refreshed Ribbon is more tactile, more adaptive, more responsive and the icons are grouped together now much better.
Five minutes into working with refreshed Ribbon and everyone will love it.
Enjoy your data and stay cool.