Skip to content

USE A DECOMPOSITION TREE WHEN ANALYZING DATA IN POWER BI

USE A DECOMPOSITION TREE WHEN ANALYZING DATA IN POWER BI

[vc_row][vc_column][mk_fancy_title font_family=”Roboto” font_type=”google”]The decomposition tree visual in Power BI allows us to visualize data in multiple dimensions. It automatically collects data and allows us to go into details. Since it’s also an artificial intelligence (AI) visualization, we can ask it to find the next dimension to go into detail based on certain criteria. This makes it a valuable tool for conducting a temporary investigation and root cause analysis.
Now, let’s go and explore this ability that Power BI developers offer us together.[/mk_fancy_title][/vc_column][/vc_row][vc_row][vc_column][mk_image src=”https://peakup.org/wp-content/uploads/2023/12/0-tree-graph-gif.gif” image_size=”full”][/vc_column][/vc_row][vc_row][vc_column][mk_fancy_title size=”21″ font_weight=”bold” font_family=”none”]ADDING THE DECOMPOSITION TREE TO A POWER BI REPORT[/mk_fancy_title][/vc_column][/vc_row][vc_row][vc_column][mk_fancy_title font_family=”Roboto” font_type=”google”]Let’s open the Power BI Desktop application and add the decomposition tree from the visual elements on the right.[/mk_fancy_title][/vc_column][/vc_row][vc_row][vc_column][mk_image src=”https://peakup.org/wp-content/uploads/2023/12/1-1.png” image_size=”full”][/vc_column][/vc_row][vc_row][vc_column][mk_fancy_title font_family=”Roboto” font_type=”google”]Let’s add the value you want to analyze in the Analysis field. Today, we will perform an analysis about Sales. When you drag and drop the SalesAmount value to the Analysis field, you will see it appear in the Decomposition Tree visual.[/mk_fancy_title][/vc_column][/vc_row][vc_row][vc_column][mk_image src=”https://peakup.org/wp-content/uploads/2023/12/2-1.png” image_size=”full”][/vc_column][/vc_row][vc_row][vc_column][mk_fancy_title font_family=”Roboto” font_type=”google”]Let’s add the fields we want to break down to the Description Criteria section of the Decomposition Tree image. I will break down the color, model and size here.[/mk_fancy_title][/vc_column][/vc_row][vc_row][vc_column][mk_image src=”https://peakup.org/wp-content/uploads/2023/12/3-1.png” image_size=”full”][/vc_column][/vc_row][vc_row][vc_column][mk_fancy_title font_family=”Roboto” font_type=”google”]Let’s click on the (+) icon that appears on the Decomposition Tree image to perform the analysis with breakdowns. After that, we will choose the criterion we want to break down.[/mk_fancy_title][/vc_column][/vc_row][vc_row][vc_column][mk_image src=”https://peakup.org/wp-content/uploads/2023/12/4-1.png” image_size=”full”][/vc_column][/vc_row][vc_row][vc_column][mk_fancy_title font_family=”Roboto” font_type=”google”]With this stage being complete, we have officially realized our first breakdown. Let’s proceed in the same way in the second breakdown and select our color and size criteria.[/mk_fancy_title][/vc_column][/vc_row][vc_row][vc_column][mk_image src=”https://peakup.org/wp-content/uploads/2023/12/5-1.png” image_size=”full”][/vc_column][/vc_row][vc_row][vc_column][mk_fancy_title font_family=”Roboto” font_type=”google”]This way, we got to see the breakdowns with the Decomposition Tree by selecting the area and criteria we wanted to analyze. Here is the result of all our steps:[/mk_fancy_title][/vc_column][/vc_row][vc_row][vc_column][mk_image src=”https://peakup.org/wp-content/uploads/2023/12/6-tree-graph-gif.gif” image_size=”full”][/vc_column][/vc_row][vc_row][vc_column][mk_fancy_title font_family=”Roboto” font_type=”google”]This is how the Composition Trees -which are used in many reports- are used. We believe that it will be very helpful and beneficial for you with your work!

Hope to see you again, have a great day![/mk_fancy_title][/vc_column][/vc_row]