0:01
In this video I'll show you a very interesting feature in Power BI, that is AI in BI
0:06
Artificial Intelligence in Business Intelligence. This feature is not present in all the BI tools, I can say only few of them
0:14
Power BI is one of them. Okay, what is this AI and BI? For that I have to create one simple chart and then show you the demo
0:20
So I'll just create a stacked column chart for order date and sales
0:24
So order date and profit I'll pick up. Order date goes into access and I'll pick up profit
0:29
profit will go into values. So you can drag and drop or you can select one and the same
0:34
Now I'll try to resize it properly. Yeah, that's the resize I've done. Now I'll just, I don't need this fields. I can just
0:45
minimize those. So if you see, this is year-wise profit and the profit is increasing definitely
0:51
Now, if I click on the fourth button, if I click on the fourth button, I can show you the details by
0:56
cotter-wise and year-wise. So these are all the coders in the... all the years here. Now suppose if you observe let me just resize because the size
1:05
is not visible so I'll just go to view menu bar and I'll just go to customize
1:10
current theme and I try to reduce the size to maybe lesser than that 10 And apply and see Yeah so here you can see
1:21
Now, what I want to show is 2016 quarter 2. I know the screen is small, the size is small
1:27
But if you see, the third quarter, third last quarter, is having the lesser profit as compared to fourth last quarter
1:33
So, 2016 Q2 is having lesser profit than 2016 Q1. Now, what could be the reason
1:39
Okay. Because there are many fields here, if you observe, there are 21 different columns, category, region, sales, profit, quantity, city, country, state, postal code. There can be any different reasons because of which the profit has come down. Suppose if I want to yze, if I want to find out the root cause, why the profit has gone down. So, very simple and very easy in Power BI. Just two button clicks and we'll get different options. Okay. So I can just right click on 2016 Q2
2:09
and there's an option given as yze. Explain the decrease. Once I click on Explain
2:14
the decrease, I'll be getting list of all the visuals one by one. And you can see how
2:19
much is the decrease 34.25 as compared to previous quarter. Okay, so I'll just click on
2:23
Got It button That is for the help I just click on Got It And you can see these are different visuals which are created in just one button click Okay What this visual says this will give you the different parameters and why the profit has come down Let us see the first one
2:39
So first one, if I show you here. So this is profit based on region
2:44
If I read this one, by year, Cotter and region. So 2016 Q1 was this much profit
2:49
2016 Q2, the profit came down. If I ask you which region was the responsible, so you see, West Region was having a profit
2:57
minus 10.4,000. So that was a negative one. Which region was profitable? Only each region was
3:03
profitable and how much is this one. So you can see the red color, green color and the blue color
3:07
will tell you the legend part here. Now, let us see one more example. Like this, you can keep on
3:13
scrolling and easily quickly find out the answers here. One more example. 2016 Q1 was the profit
3:19
2016 Q2, which category was having what was responsible for less profit? Technology, you see, minus 11.3
3:27
thousand. The profit came down gradually or you can see as you know on a large
3:31
contained from technology whereas which one was profitable office supplies. So you
3:36
see if I if you try to find out by using some techniques and tricks it will take
3:40
a lot of time but using this AI in BI within few button clicks we get the answers Now once you finish suppose your managers assigned this task to you and I asked you to give the answers What you can do is after 15 days you can just click on this plus button
3:55
and this visual would be added at the back end. You see? Once I again right click and click on yze, explain the decrease
4:04
Yeah, so I think that is added already. You see? This visual is added. Let me just resize it properly
4:10
Yeah, that's a visual. Now I said after 15 days you have to add this visual
4:15
Why did I say that? If you give them immediately, then what is the use of your company
4:19
So what is the use in the company for you? So make sure that once you yze the data and then you can add it
4:25
So if you observe, the upper text is not added. Upper text which was given written on the top, it is not added
4:30
It is just kept for you so that you can, when you're going for a presentation, you can display that
4:34
So I'll just right click here, select the option yze and explain the decrease. And here if you observe this particular text, which I want to say is not displayed
4:42
okay this one so i can just click on add button do not give them easily otherwise difficult to survive
4:48
in the market and i can just scroll and you can see that's a visual here okay very very simple
4:53
visual which is created now this kind of animation this kind of artificial intelligence is only
4:58
present in power bi right so i hope you have understood how to work on AI in power bi that's all for this
