28 Nov’19

Power BIHow to bring “AI” to Power BI

The February 2019 release of Power BI Desktop unveiled a new, out-of-the-box visual to Power BI called Key Influencers. Key Influencers is Power BI’s first Artificial Intelligence (AI) powered visualization. Microsoft has long incorporated AI capabilities in Power BI through features such as Natural Language (Q&A) and Quick Insights. However, with Key Influencers report developers now have explicit control in leveraging AI to discover insights in their data. Even more, Key Influencers is essentially multiple visuals baked into one!

The Key Influencers visual is comprised of two tabs: Key Influencers and Top Segments.

The Key Influencers tab will display a ranked list of the individual contributing factors that drive the selected condition. The Top Segments tab will take this a step further and display groupings of key influencers and their impact on the selected condition.

The Key Influencers tab runs a LOGISTIC REGRESSION to analyze your data and identify the main factors that influence a specific metric or condition.

Scenario:

The customers of a company are using a particular cloud service. The Product Manager of that company wants to conduct a survey and analyze factors (Key Influencers) that drive the customers to provide a negative feedback i.e low rating after using the cloud service.

KEY INFLUENCERS TAB

The Top Influencers are:-

  1. Role in Org is consumer

The people whose role in the organization is consumer have 2.57 times more chances to provide negative feedback than people whose role is adminstrator or publisher.

2. Theme is usability

Second most influencing factor is Theme is usability which means the most negative reviews are provided for Usability.

All the Key Influencers tab gives us two panes of visuals. For example, on the left-hand pane you have an infographic of the key influencers themselves, ranked based on their relative impact on the condition being analyzed

And the right-hand pane will display a chart containing the values of that attribute, along with the average percentage that value matches the condition.

All these factors change continuously depending on the parameters.For example if we add a slicer of company size, the top influencers will change-

TOP SEGMENTS TAB

On the Top Segments tab, you will see how groupings of key influencers affect the selected condition.  The segments are ranked based on the percentage of records where the condition is met. The size of each segment bubble represents how many records (population count) are in the segment.

LIMITATIONS

The key influencers visual has some limitations:

  • Direct Query is not supported
  • Live Connection to Azure Analysis Services and SQL Server Analysis Services is not supported
  • Publish to web is not supported
  • .NET Framework 4.6 or higher is required.

Hope this is helpful!

For more such posts visit- https://www.cloudfronts.com/why-you-should-migrate-from-excel-to-power-bi-for-reporting/

Written by

Shrusti Talati

Software Engineer

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • How to create Dynamics 365 Finance & Operations (formerly Dynamics AX) connection in SSIS

    12 December’ 2019

    Introduction: Creating a Connection is one of the first Steps during the integration of data. While performing Integrati...

    Read more
  • How to create AX (D365 F&0) Connection in SSIS

    12 December’ 2019

    Introduction: Creating a Connection is one of the first Steps during integration of data. While performing Integration w...

    Read more
  • First cut review of new D365 Project Service

    12 December’ 2019

    The new Project Service coming up is a much-advanced version of PSA. Even more, than it will be called as Project Servic...

    Read more
  • Business Central Wave 2 Features – Section 4

    11 December’ 2019

    Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business...

    Read more
  • Business Central Wave 2 Features – Section 5

    11 December’ 2019

    Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business...

    Read more

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close