Power BI is a powerful tool for creating and sharing interactive data visualizations, however, many users are unaware that they can also use Power BI to leverage the power of artificial intelligence (AI) and to gain deeper insights from your data?
In this blog post, I will show you how to use some of the AI visuals in Power BI, such as the key influencers, decomposition tree, Q&A visuals and smart narrative visual. These visuals can help you discover hidden patterns, identify key factors, and ask natural language questions to your data.
Power BI Key Influencers Visual
The key influencers visual lets you analyse how different factors influence a metric or outcome that you care about. For example, if you want to understand what affects customer satisfaction, you can use the key influencers visual to see which factors have the most positive or negative impact on it.
To use the key influencers visual, you need to select a measure (such as customer satisfaction) as the analyse field, and one or more fields (such as product category, region, or age group) as the explain by fields. The visual will then show you a list of influencers ranked by their influence score, and a chart that shows how the measure changes with different values of the influencer.
You can also use the key influencers visual to perform additional analysis such as finding outliers or performing what-if analysis. To do this, you need to enable the advanced analytics option in the visual settings and select a scenario (such as find outliers or analyse what if) from the drop-down menu. The visual will then show you additional insights based on the selected scenario.
Power BI Decomposition Tree Visual
The decomposition tree visual lets you break down a measure by different dimensions or categories to understand its components. For example, if you want to understand how your sales are distributed by different product categories, regions, or channels, you can use the decomposition tree visual to drill down into these dimensions and see their contribution to the total sales.
To use the decomposition tree visual, you need to select a measure (such as sales) as the analyse field, and one or more fields (such as product category, region, or channel) as the fields to expand by. The visual will then show you a tree-like structure that starts with the total value of the measure and expands into different branches based on the selected fields.
You can also use the decomposition tree visual to leverage AI-based analysis, such as finding high or low values or performing root cause analysis. To do this, you need to enable the AI split option in the visual settings and select a criterion (such as high value or low value) from the drop-down menu. The visual will then automatically split the measure by the most relevant field based on the selected criterion.
Power BI Q&A Visual
Sometimes, the easiest way to get answers from your data is to use natural language questions. The Q&A visual lets you ask natural language questions to your data and get instant answers in the form of charts or tables. For example, if you want to know how your sales compare to last year by month, you can simply type “sales vs last year by month” in the Q&A visual and get a line chart that shows the comparison.
To get most value from the Q&A visual, you need to have a data model that is well-structured and has meaningful names for tables and columns. You can also improve the Q&A experience by adding synonyms, phrasings, or featured questions to your data model using the Q&A setup tool in Power BI Desktop or Service.
The Q&A visual supports a variety of natural language expressions, such as filters, aggregations, calculations, comparisons, or time intelligence. You can also refine your questions or explore different perspectives using the suggestions or follow-up questions that appear below the Q&A visual.
The Power BI Smart Narrative visual
Power BI is a powerful tool for creating interactive and insightful dashboards and reports. However, sometimes it can be challenging to communicate the key insights and messages from the data to the audience. That’s where the Smart narrative visual comes in handy.
The Smart narrative visual is visual in Power BI that allows you to add dynamic text summaries to your reports. The Smart narrative visual automatically generates natural language narratives based on the data in your report, and lets you customise them to suit your needs. You can also add parameters, conditional formatting, and expressions to make your narratives more interactive and responsive.
The Smart narrative visual can help you add value to your Power BI reports in several ways. For example, you can use it to:
– Highlight the main trends, patterns, and outliers in your data
– Compare and contrast different scenarios or segments in your data
– Tell a compelling story with your data and guide the audience through your analysis
The Smart narrative visual is a great way to enhance your Power BI reports with dynamic and engaging text summaries. By using the Smart narrative visual, you can make your reports more informative, persuasive, and user-friendly.
AI visuals in Power BI are a terrific way to enhance your data analysis and visualization capabilities. They can help you uncover hidden insights, identify key drivers, and ask natural language questions to your data. You can also customise and fine-tune these visuals using various options and settings to suit your needs and preferences.
If you want to learn more about AI visuals in Power BI, you can check out these resources:
Johann is the founder of Data Bear and specializes in Power BI Training and Consulting. Empowering organisations to move from time-consuming and limited reporting processes to easily answering specific business questions is what he takes pleasure in.
We have been working with Johann and Dmitri for almost a year now. From concept to design and implementation, they have been nothing but professional and timely. They leveraged Azure and Power BI to sort and report our point of sales data. We have no reservation when it comes to recommending Data Bear and look forward to our continued partnership.
The DataBear team has been great to work with! They take the time to understand the problem and then put together a real-time solution. It's also great when they responds so quickly! We will continue to work with them!
Fantastic training delivered clearly and effectively. Training was delivered at a pace that reflected our individual abilities and Johan ensured everything was clearly understood before moving on. Would happily recommend!
We had the pleasure of attending the 2 day BI Course. Not was not only very informative, it was made extremely enjoyable by the very knowledgeable Johann who presented in a way we all understood. Highly Recommend anyone looking for some BI training to contact Data Bear
Great Power Bi training in London. A very comprehensive overview of this platform with a thorough agenda, good training materials and a friendly group; Johann is an excellent trainer with a great depth of knowledge and experience in Power Bi. Highly recommended.
DataBear were a pleasure to deal with. We had a 2-day training workshop at our own location, Johann was very knowledgeable, not only delivering a well structured and organised piece of training, but also able to answer questions quickly. Thank you for a superb experience.
Super clear instruction and tutoring by Johann. Great size of group (6) - meant that no-one in the class was left behind, and it seemed those ahead - were not too held back. It is a lot of info to take in for the 2 day course. Would highly recommend the 3 day course where possible! Jon Brown
I recently attended the 2-day Power BI Course run by Johann. This was an intensive and extremely valuable course. Johann is a great instructor, he knows the subject well, and his pace is spot-on. There were many clear and easy-to-follow examples, and the emphasis on practical learning makes this a very worthwhile two days. I would recommend doing the three day course however, as there is so much content and I left wanting just a little more exposure to the final module. Many thanks Johann!
Being new to Power BI I was keen to organise some training for our UK data team. After some Googling I decided on Databear and gave them a call. Johann promptly called me back and we discussed the various training options and we arranged some onsite training to be held at our own offices. Johann provided two excellent days of training, full of knowledge, insight and explanations. With Johann you get right in to using the tool and apply what you are learning as you go. I would highly recommend Johann to anyone interested in learning how to use Power BI correctly and effectively.
I attended the three day PowerBI training course with Johann and found it extremely valuable and insightful. Johann has an excellent knowledge of the subject and the lessons are well structured. I would recommend people take the opportunity to learn and grow their skills through Data Bear .
Data Bear came in to run a two day course on Power BI, the attendees were from various levels of excel experience, but Johann kept the training relevant to all levels and made sure to carry everyone along.
a very good way to start your Power BI journey.
Excellent intensive, small group two-day course - best practise on data modelling was the most valuable section for me as this underpins the success of everything you could possibly want to achieve in Power BI! Highly recommend for those who have go their teeth into Power BI already and want to produce more effective and efficient work but also great for complete beginners as Johann will adapt to suit your needs, even in a mixed group.
I have just attended a 2-day PowerBI course ran by Johann. The course is very comprehensive and intense. I would suggest anyone who plans to attend the course to have some basic idea of PowerBI first. This will make the 2-day less daunting. Having said that, Johann was super helpful and patient both during and after the course. A classroom course beats any online course hands down.
Had a fantastic three days with Johann, and would thoroughly recommend to anyone looking to improve their PowerBI skills. His (and Data Bear's) approach to training is very intuitive and helps with real-life examples. The training was adapted to the areas I required further guidance on which provided a very, very quality experience. Happy to say I will be undertaking further training with Data Bear in the coming months.
Excellent course. Had the pleasure of being tutored by Johann in the 2-day Power BI introduction. By the end of it I was able to go back to work and start producing reports I had hoped to - almost straight away. Highly recommended.
The course was taught by the founder of Data Bear, and I was thoroughly impressed by it. It was taught a fast but engaging pace with several well thought out exercises throughout the 3 days that really helped embed the core subjects Johann was teaching us. I would highly recommend this course to anyone starting off in Power BI who wants to quickly attain a good level of knowledge.
Great course! My colleagues and I had a private 2 day training with Johann. The course was exactly what we were looking for in order to get a solid understanding of PowerBI. He took us from zero to a level where we feel confident enough to start creating our own reports. He was happy to deviate from schedule, answer all our questions and tailor the content based on our needs. Highly recommended!
3 day Power BI Training - Johann is a great instructor and assisted in every aspect to understand the core concepts. It's a great course and would definitely recommend to anyone who wants to learn Power BI.
A very worthwhile investment of time and money. I've been using Power BI for 6 months learning by trial and error. This course really provided the context I needed. Its a very well structured and hands-on course. My only regret is that I didn't sign up for the full 3 days as there was stuff in the 3rd day which would have been beneficial too.
Very well structured course that provided all the building blocks to be able to master PBI. Would highly recommend. The instructors were also very willing to help me outside of the lessons with any questions relating to projects i was working on. If you want to save a lot of time when starting out with PBI, this course will teach you all the fundamental best practice techniques you should be using.
My firm recently contracted Data Bear to improve our implementation of Power BI embedded. Their engineers have a very high level of technical acumen, and had experience in several different technologies. I would highly recommend their services.
Outstanding private training from Data Bear, can highly recommend for anyone that needs some comprehensive tuition on Power BI - great company who were adaptive to my needs and very limited experience in this area.