Discover Data Analysis

Introduction to working with AI Visuals


Microsoft Power BI gives us a wide range of methods to analyze our data and get answers to our questions. 

This blog describes the AI capabilities of Power BI. Following are the AI visuals provided by Power BI

  • Q&A visual.  

  • Key influencers visual.

  • Decomposition Tree visual to break down a measure.


1. Q&A visual

The Q&A feature in Power BI lets us explore data in our own words by allowing us to ask natural language questions and then providing with answers to those questions.
We can add visual Q&A to our report canvas by two ways,

a. By selecting the Q&A icon on the Visualizations pane.

b.  By selecting Insert -> Button ->  Q&A, which is a useful option if we want to save space on your report canvas.

 

2. Key Influencer Visual

The Key influencers visual helps us to understand the factors that are affecting a specific metric. It analyzes our data, ranks the factors that matter, and then displays those factors as key influencers. The visual also helps you to contrast the relative importance of these factors, meaning that we can build our visuals while understanding what factors impact those visuals and why the visuals appear the way that they do.

To establish the key influencers, first we need to add the Key influencers visual to our report by selecting the Key influencers icon on the Visualization pane. Then, populate the visual with the metrics that we want to measure. The visual updates according to the fields that we added and then shows the influence that those fields have on our data.


3. Decomposition Tree visual
        
The Decomposition Tree visual automatically aggregates our data and lets us drill down into our dimensions so that we can view our data across multiple dimensions. Because Decomposition Tree is an AI visual, we can use it for improvised exploration and conducting root cause analysis.

We can add the Decomposition Tree visual to our report by selecting the Decomposition Tree icon on the Visualization pane. Then, in the Analyze field well, add the measure or aggregate that we want to analyze. In the Explain by field well, add the dimension(s) that we want to drill down into. 

Conclusion 

In this blog I have given brief introduction to AI visuals in Power BI.

Comments

Post a Comment

Popular posts from this blog

Use DAX iterator functions in Power BI Desktop models

Data Analysis Expressions (DAX) include a set of functions known as  iterator functions . Iterator functions enumerate all rows of a given table and evaluate a given expression for each row. They provide you with flexibility and control over how your model calculations will summarize data. Some DAX Functions are Complex summarization 1. SUMX e.g. : 1.  Revenue = SUMX (Sales, Sales[Sales Amount]) 2. Revenue = SUMX (Sales, Sales[Order Quantity] * Sales[Unit Price] * ( 1 - Sales[Unit Price Discount Pct.])) 3. Discount = SUMX ( Sales, Sales[Order Quantity] *( RELATED ('Product'[List Price]) - Sales[Unit Price] ) ) 2. AVERAGEX e.g :1. Revenue Avg = AVERAGEX ( Sales, Sales[Order Quantity] * Sales[Unit Price] * ( 1 - Sales[Unit Price Discount Pct.]) ) 2. Revenue Avg Order = AVERAGEX ( VALUES ('Sales Order'[Sales Order]), [Revenue] ) 3. RANKX The  RANKX  DAX function is a special iterator function you can use to calculate ranks. Its syntax is as follows: RANKX (<...
Read more

Different charts in Power BI

Image
  An overview of Chart Types in Power BI As everyone might be aware, Power BI is one of the SaaS offerings from Microsoft in the field of BI and Analytics. It provides a very intuitive way for non-technical users to do analyses and create reports on their own without having to rely on a technical team. One of the main purposes of Microsoft behind Power BI is to promote self-service BI and it is one of the BI tools in the market with a comparatively lower learning curve as there are many similarities compared to Microsoft Excel.  In this blog, I am going to give an overview of the most widely used chart types in Power BI.   Let's look at some of the most frequently used chart types in Power BI Bar and column charts Stacked Bar and Stacked Column Chart Clustered Bar and Clustered Column Chart Line Chart Area Chart Stacked Area Chart Line and Stacked Column Chart/ Combo Chart Line and Clustered Column Chart/ Combo Chart Ribbon Chart Waterfall Chart Funnel Chart Scatter Chart...
Read more

Modify DAX filter context in Power BI Desktop models

Summary CALCULATE  DAX function to modify filter context in the formulas. The syntax for the CALCULATE function is as follows: CALCULATE (<expression>, [[<filter1>], <filter2>]…) I learned about filter context. And also learned why and how to work with the CALCULATE function to modify filter context by passing in filters. These filters can add or overwrite the filter context, and they can modify filter context when we are passing in special functions like REMOVEFILTERS or KEEPFILTERS. Additionally, I learned that the CALCULATE function can transition row context to filter context, which can be required when we are using measure expressions in calculated columns or iterator functions.
Read more