Decomposition tree in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a Decomposition tree in Power BI?

A Decomposition tree is a visual that helps break down a measure or dimension into its contributing parts, allowing you to explore data by drilling down into categories step-by-step.

beginner

How do you start analyzing data with a Decomposition tree?

You start by selecting a measure or value to analyze, then choose categories to break down the data, drilling down into details interactively.

intermediate

What is the difference between 'Explain by' and 'Analyze' in a Decomposition tree?

'Explain by' lets you choose fields to break down the data manually, while 'Analyze' uses AI to suggest the most important factors automatically.

intermediate

Can you use a Decomposition tree to find the biggest contributors to a sales drop?

Yes, by drilling down into categories like product, region, or time, you can identify which parts caused the sales drop.

beginner

What is a best practice when using a Decomposition tree?

Limit the number of breakdown categories to keep the tree clear and easy to understand. Use meaningful categories that relate to your question.

What does a Decomposition tree primarily help you do?

A Write complex DAX formulas

B Break down data into smaller parts interactively

C Create static charts with fixed categories

D Import data from Excel

A Decomposition tree lets you explore data by breaking it down into parts step-by-step.

Which feature in the Decomposition tree suggests important factors automatically?

A Analyze

B Explain by

C Manual drill down

D Filter pane

'Analyze' uses AI to suggest key factors to explore in the tree.

What type of data can you analyze with a Decomposition tree?

A Only text data

B Images

C Only dates

D Measures or numeric values

Decomposition trees analyze numeric values or measures by breaking them down by categories.

How do you interact with a Decomposition tree in Power BI?

A By typing SQL queries

B By dragging and dropping visuals

C By clicking categories to drill down

D By changing report themes

You click on categories in the tree to drill down and explore data details.

Why should you limit the number of breakdown categories in a Decomposition tree?

A To keep the tree clear and easy to understand

B To avoid slow report loading

C Because Power BI limits categories to three

D To prevent data loss

Too many categories make the tree confusing; limiting them keeps it clear.

Explain how a Decomposition tree helps in analyzing business data.

Think about how you explore a big problem by looking at smaller pieces.

Describe best practices for using a Decomposition tree effectively.

Consider what makes a visual easy to understand and useful.