Back to List

How to Use Power BI’s New AI Visual: Key Influencers

Marcus Radue Marcus Radue  |  
Mar 28, 2019
 
Microsoft has recently released a new Key Influencers visual in their February 2019 release of Power BI. This visual is part of Microsoft’s roadmap to continue to advance the Artificial Intelligence (AI) integration and features within Power BI. Microsoft has already introduced other AI features within Power BI such as Quick Insights and Natural Language Querying for live Q & A.

The Key Influencers visual is another way for report developers to leverage Microsoft’s machine learning technology and gain great insights into their data.
 

Preview State

Note: The Key Influencers visual is currently in a preview state and with that comes some limitations. Those current limitations include:
 
  • Analyzing metrics that are aggregates/measures
  • Consuming the visual in Power BI Embedded
  • Consuming the visual on Power BI mobile apps
  • RLS support
  • Direct Query support
  • Live Connection support
 

Use Case

As we observe the NCAA college basketball tournaments during this exciting month of March Madness, I deemed it appropriate to use a college basketball dataset for my sample Power BI report. That dataset includes all the men’s division 1 college basketball teams that are eligible to receive an NCAA tournament bid from the years 2003 – 2018, along with their regular season and NCAA tournament records and statistics for those years. With the Key Influencers visual, I was able to gain insights to the criteria that may have factored into the NCAA tournament seeding over those years. Let’s look at the data trends and factors I was able to gain that may have influenced the tournament seeding.

Download the sample Power BI report and dataset.
 

Key Influencers Visual Example

Before demonstrating how the Key Influencers visual works, you will need to make sure you have the latest release of Power BI desktop installed on your device. If you have Power BI desktop installed via the Microsoft app store on a Windows 10 machine, then Power BI will update automatically. If you have an earlier Windows version, then you can get the latest version here.

The second thing you will need to check is that your preview features are checked on in your Power BI desktop settings. You can do that by opening a new Power BI desktop file, going to File > Options and Settings > Options. I have all my preview features checked to make sure I always have the full functionality of Power BI, but you only need to have the Key Influencers visual checked.
 
key influencers visual

Once you have done that, you can load the sample dataset I have provided and select a new Key Influencers visual onto your report page.
 
key influencers report

Here is my finished Key Influencers visual used to describe the factors that may have went into deciding the NCAA Tournament seeding spanning the years between 2003 and 2018. Within the visual you will have two tabs: Key Influencers and Top Segments. Notice you can change the value the visual is analyzing within the drop-down menu at the top of the chart. You can also use other slicers on your report page to interact with your Key Influencers visual.
 
finished key influencers visual
 

Key Influencers Tab

Note the field I chose to analyze and then the corresponding fields I chose to explain. Because of a current preview limitation of not being able to analyze by aggregations, I chose to analyze the NCAA Tournament seeds. Some of the trends you can see from all the number 1 seeds include:
 
  • The team with the most number 1 seeds from 2003 – 2018 is Kansas. The closest 3 teams behind Kansas are North Carolina, Duke, and Kentucky.
  • To gain a number 1 seed you must have a high number of regular season wins. This insight is stated from the “RegWins goes up 8.21”.

If I scroll down in the visual, I can see that the top 3 conferences that have received number 1 seeds from 2003 – 2018 are the Atlantic Coast, Big East, and Big 12 conferences. Notice that clicking a different key influencer in my visual changes my graphical display.
 
key influencers graphic display
 

Top Segments Tab

By clicking the Top Segments tab, you get taken to a new view that shows the different groupings of the Key Influencers and the impact they had on the selected value – in this case, tournament seed.
 
top segments tab

Notice the different groupings created from the Key Influencers. Clicking a segment drills deeper, showing the statistics derived from that segment grouping.
 
segment grouping stats

You can see that segment 1 shows the number 1 seeds that had 5 or fewer regular season losses and 29 or greater regular season wins. This was the largest segment of number 1 seeds at 67.5%. You can infer that a major factor to gaining a number 1 seed was having a high win and low loss total on a team’s regular season record. This seems like a logical explanation – that the best team records receive the best tournament seeds. While it may be a simple example, it proves that the Key Visualizers visual is doing the correct analysis on the dataset.

The “Learn more about this segment” goes even further down, giving deeper insights on the segment grouping.
 

Conclusion

While the new Key Influencers visual may not be appropriate for every business use case, its value is undeniable for Power BI report creation. As a developer, it’s exciting to be able to leverage machine learning within an interactive report environment to gain deeper insights about your data! This visual also demonstrates Microsoft’s continuing investment into Power BI and its machine learning features. I encourage you to STAY TUNED to Microsoft’s monthly Power BI updates and development roadmap.

If you found this blog interesting or want to learn more on how Power BI can help you or your business, let’s talk about your goals.
 
Data AnalyticsPower BI

 

Love our Blogs?

Sign up to get notified of new Skyline posts.

 


Related Content


Blog Article
10 KPIs Manufacturers Should Track for Operational Excellence
Paul FullerPaul Fuller  |  
Apr 18, 2019
How do you know if you’re truly improving quality and efficiency in your manufacturing operations? Do you know if your equipment is as effective as you think it is? Are your operating lines a bottleneck in getting orders delivered to your customers? How would you demonstrate that?  ...
Blog Article
Sorting Results in the Flattened 7-layer Recursive Hierarchy Salad
Bob CharapataBob Charapata  |  
Apr 16, 2019
In my previous article about Flattening a Recursive Hierarchy, I wrote about an approach that transforms existing recursive hierarchies into usable data constructs for analytics. This post builds on that article to show how to display the results in correct hierarchical order.After...
Blog Article
Flattening the 7-layer Recursive Hierarchy Salad
Bob CharapataBob Charapata  |  
Apr 02, 2019
Sometimes organizations must model a hierarchy with data, but they don’t know how deep it will be. Developers often create recursive hierarchy tables for transaction processing systems to solve this problem. Those tables have one column on the table that refers to the table's identity...
Blog Article
Useful Tips for Power BI Desktop
Scott HietpasScott Hietpas  |  
Mar 19, 2019
There are several things within the Power BI desktop resources that I want to point out. One of the best things that happened in a few releases back is the help menu in the Desktop app. Within the help menu is access to Microsoft documentation and videos. Power BI’s blog speaks about this...
Blog Article
How to Retrieve Data from Excel Files and Other Data Sources in Power BI
Scott HietpasScott Hietpas  |  
Mar 05, 2019
Working with OneDrive for business is great for keeping copies of Power BI desktop reports. It can also be a good place for you to store any one-off data or backup versions of data sources in case the files break at some point.   Another reason to save Excel files in OneDrive is so Power...