AI Visuals Power BI has a range of visuals which use AI technology, so AI or artificial intelligence allows a computer to think or act in a more human way. it takes its information from its surroundings and produces responses based on what it learns or senses.

Power BI has four different AI visuals. We have Q&A, key influencers a decomposition tree, and a smart narrative.

We're going to have a look at two of those visuals.

So first of all a Q&A visual.

Q&A visual is on on the visualizations pane and if we double click on the canvas, we can also access it quickly that way.

It allows us to ask a question of our data. Maybe we're not sure how to go about creating a particular visual, we can ask a question using our own natural language and it will produce the visual for us.

We can then pin that visual to the page and use it like any other visual.

The second visual that we're going to look at is a smart narrative.

It will give us a lot of text, a summary and the key stats about what's on our page.

It's really useful way to get an overview and it's great because it will update automatically once the data has been refreshed.

Let's do a workout and see how to create these AI visuals in Power BI.

I'm just going to get some data here from an Excel workbook module 4 lesson 5 And I'll select the L5 Revenue worksheet here and load it in.

So we will look at a Q&A visual first of all, we do have access to the icons to allow us to create any of the AI visuals in Power BI we can also access them from the insert tab they set up here but the Q&A we can easily access by just double clicking on the canvas. So if I double click here, it will immediately put a Q&A visual in for me.

So the little box at the top and I just type in there my own language. It uses what's called natural language processing and ask a question that I'd like to find the answer to, so this particular question I'm going to ask is just based on the companies in my data. So I'm going to ask it here companies.

by revenue As long as I spell it all correctly. You can see here. It's created a visual for me automatically now if I just change that there maybe to top companies by revenue.

There we go, it's ordered it for me as well. It's quite a nice visual I'm happy with that, I have a list of the revenue by company. So what I'll do now is I'll just pin it. It's a little icon here just at the top right click on that and it's pinned now to my page and it's as if I had just created it myself.

Let's try one more, so just double-click here again this time I'm just going to ask for the top three company. I'll do top three companies by revenue.

If I just spell revenue correctly, so that is you can see it's underlining and red there when I don't type a Word, it doesn't recognize there we go, and I've got the top three companies by revenue. Again if I want to keep it, I'll just pin it there to the page and we have our second visual.

The other AI visual that I want to show you is the Smart Narrative. So again, we can access it from the insert tab or we can just go over here to the visualizations pane. If I just click on that, it's a little summary. It's like a text box with some detail in it about my data. So it's given me some key statistics here in a nice little overview, but if my data were to change and I was to refresh the page then the smart narrative would also update so much better than creating a text box and typing it in yourself.