The decomposition tree is an interactive visualization for hierarchical data. The concept is to take a single metric and drill it down into various dimensions. In Figure 22-1, you can see the sales drivers by country. The leader is the USA, and then we expand it by product categories and subcategories.
Figure 22-1. Sales decomposition from USA to Accessories
We can continue the analysis in a different direction: let’s expand Great Britain, and then the Clothing category, and see the ranking of products within it (Figure 22-2). In the same way, we can explore the data in different directions.
Figure 22-2. Decomposition from Great Britain to Clothing
The decomposition tree is part of the standard set of Power BI visuals, so there is no need to download it from the gallery. It is built from a single measure and multiple categories that expand and “branch out” as you move from one to another.
How a Decomposition Tree Works
When building, in the Analyze field, you place the parameter you want to analyze and break down into subgroups. In the Explain by field, you place the categories by which you will analyze the original parameter—in our example, this is Country, Product category, Product subcategory, and Manager. The number of such parameters is not ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
