![\"\"](\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2022\/09\/PBI-Phone-Tab.bmp\")
<\/a><\/p>\nAI visuals are extremely useful and all four can provide your report with insight information from your data model. Without these, you have to do DAX measures and create your own visuals.<\/p>\n
Key Influencers visual<\/h5>\n
We used the same HR data model in the entire four-part series \u2018Artificial Intelligence Visuals in Power BI Desktop\u2019. In this blog post, we explain the Key Influencers visual. The HR data model measures the employees\u2019 engagement score, number of sick days, and the employees\u2019 productivity.<\/p>\n
The report needs to visualise the key influencers for high engagement, high productivity, and why someone has many sick days.<\/p>\n
To do this, some decisions have to be made. You will have to define what a high engagement score is, what a high number of sick days is, and what a high productivity score is.<\/p>\n
The Method<\/h5>\n
If you decide that more than 5 days a year is a high number of sick days, you will need a calculated column where you test the number of days an employee has been sick. The calculated column could look like this:\u00a0 High\/Low # of days sick=If([Days of sickness]>5, \u201chigh\u201d,\u201dLow\u201d). We need to use the same logic for engagement and productivity.<\/p>\n
To get the Key Influencers visual, click Key Influencers on the Insert tab in the AI visuals group.<\/p>\n
The Results<\/h5>\n
In the example below, we added the logical column to the Analyse field in the visual. At the top, we selected High, because the key influencers for many days of sickness need to be found.<\/p>\n
Below, we have dragged the information about the employees\u2019 gender to Explain By. As you can see, the employees\u2019 gender is not a key influencer for high level of sickness.<\/p>\n Below we have added four more columns to Explain By: Department, Part\/Full Time, Title, and Hire Date. The Key Influencers visual now explains that the top influencer for a high number of days sick is Title. If you are a general employee in this company, the chances of having a high number of sick days are 6.2 times higher than other titles. The second largest influencer is an interesting one. It is Hire Date. All employees hired from the 22 January 2015 to 6 August 2015 have a 3.1 times greater chance to have more sick days.<\/p>\n Below, High has been changed to Low to show the key influencers for a low number of sick days.<\/p>\n Within the Key Influencers visual, each key influencer can be visualised with a chart inside the visual. Above, you can see the chart for the top influencer. If you want a key influencer visualised in the chart, you just need to click on the circle with the number.<\/p>\n Below, we clicked on the circle with the number 1.32x to see the chart for Part\/Full time<\/p>\n Below, you can see the visual showing the key influencers for Low productivity.<\/p>\n The last image shows the key influencers for a high engagement score.<\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n