Introduction to decomposition trees

Trend Analysis in Power BI

Maarten Van den Broeck

Content Developer at DataCamp

What is a decomposition tree?

Definition:

A method for breaking down a target variable by multiple dimensions or variables to determine resulting influence.

Use Cases:

Ad hoc exploration
Root cause analysis
Identifying influential variables

Structure of a decomposition tree

A factory with three orders, one of which is empty, or the products are on backorder.

Structure of a decomposition tree

A decomposition tree visualizations from Power BI. Shows a root node and multiple child nodes with branches, or paths, connecting them.

Structure of a decomposition tree

A decomposition tree visualizations from Power BI. Shows a root node and multiple child nodes with branches, or paths, connecting them. The root node, on the far left, is highlighted.

Structure of a decomposition tree

A decomposition tree visualizations from Power BI. Shows a root node and multiple child nodes with branches, or paths, connecting them. The root node, on the far left, is highlighted.

Structure of a decomposition tree

A decomposition tree visualizations from Power BI. Shows a root node and multiple child nodes with branches, or paths, connecting them. The child nodes, or explain variables, are highlighted.

Structure of a decomposition tree

A decomposition tree visualizations from Power BI. Shows a root node and multiple child nodes with branches, or paths, connecting them. A couple of child nodes are highlighted.

Structure of a decomposition tree

A decomposition tree visualizations from Power BI. Shows a root node and multiple child nodes with branches, or paths, connecting them. The child nodes on the far right, or leaf nodes, are highlighted.

Structure of a decomposition tree

A decomposition tree visualizations from Power BI. The image zooms in on a level of child nodes to show the blue bars and how much each is filled.

Structure of a decomposition tree

A decomposition tree visualizations from Power BI. Shows a root node and multiple child nodes with branches, or paths, connecting them. One path is highlighted.

Reading a decomposition tree

The root node from the previous highlight path, indicating a 5.07% percentage of orders on backorder.

An image of squares in a larger square representing the entire dataset. Two smaller squares are filled in with blue to represent the percentage of orders on backorder.

Reading a decomposition tree

A child node from the first level, Forecast Bias variable, and the associated percentage of orders on backorder.

An image of a subset of the previous larger set of squares representing part of the dataset. Two smaller squares are filled in with blue to represent the percentage of orders on backorder for this subset.

Reading a decomposition tree

A child node from the second level, Demand Type variable, and the associated percentage of orders on backorder.

An image of a subset of the previous subset of squares representing a smaller part of the dataset. Two smaller squares are filled in with blue to represent the percentage of orders on backorder for this subset.

Reading a decomposition tree

A child node from the final level, Plant variable, and the associated percentage of orders on backorder.

An image of a subset of the previous two subsets of squares representing an even smaller part of the dataset. Three smaller squares are filled in with blue to represent the percentage of orders on backorder for this subset.

Let's practice!

Trend Analysis in Power BI