Table, Matrix, Key Influencers, Decomposition Tree Visuals

Table, Matrix, Key Influencers, Decomposition Tree Visuals

  May 29, 2023    asghars

---

 The following dashboard uses the Sample - Superstore  datasets to demonstrate the creation of:

• Table
• The Table visual is a grid where related data is displayed in 2D format i.e. rows and columns.
• Table visual is flat, means duplicate values are displayed and not aggregated.
• Tables are great for quantitative comparisons where you compare multiple values from different categories.
• In Power BI the following fields are shown in details pans:
• Columns defines the columns to be added to table
• Matrix
• The Matrix visual is similar to table but it can display data in multiple dimensions.
• The Matrix aggregates the data itself and lets users drill down.
• In Power BI the following fields are shown in details pans:
• Row field defines the data that need to be shown in rows
• Column field defines the data that will represent columns of matrix
• Values define the numeric data that needs to be aggregated
• Key Influencers
• The Key influencers visual shows the top contributors to the selected metric value.
• Key influencers makes use of Regression analysis.
• In Power BI the following fields are shown in details pans:
• Analyze field identifies the data that needs to be analyzed
• Explain by are factors that influence the analyze field
• Expand by field is used when analyzing a measure or summarized field
• Decomposition Tree
• A decomposition tree visualizes data in its components or building blocks. 
• Decomposition tree visualize data across various categories and dimensions and allows to drill down into the data for in-depth analysis.
• In Power BI the following fields are shown in details pans:
• Analyze field identifies the data that needs to be analyzed
• Explain by fields that are used to analyze or drill-down the data

Download PBIX file