0:00
Hello everyone and welcome to Tutorials Point
0:03
My name is Pavan Ralwani and you're watching a series on Power BI, Microsoft Power BI
0:08
What is Power BI, why you should learn Power BI and what are the advantages of using this Power BI
0:14
Let us see that one by one. Number one, what is exactly PowerBi
0:18
PowerBi is the Business Intelligence tool which is available in the market here, which is one of the best tool in the market today
0:24
Now because of many reasons, these are the reasons. This PowerBi tool can work on reports and dashboards
0:30
You can clean data in Power BI, work on data modeling part and also visualize data
0:35
So these are all the reasons because of which it is Business Intelligence tool. Now why you should learn the Power BI
0:41
What are the reasons? Let us see that. Number one, it is the most popular tool in the market today
0:46
Second, you can see there's a high demand for PowerBi experts in the market
0:50
It is very simple and very easy to learn. Just using button clicks, you can do many of the functions here
0:56
Next whatever daily manual tasks you doing in the company like getting the data cleaning creating charts and then publishing online or sharing with other people this can be completely automated in Power BI just using button clicks And the last one if you a manager or if you a higher hierarchy manager looking for this why you should choose Power BI as compared to other products It is one of the cheapest tool in the market in BI that is just per user per month
1:22
That's the cheapest price which you can get it. Now another reason why you should go for PowerBei, let me give an example
1:29
Like you might have heard about Trivago.com. That's one website which compares all the hotels across the world and gives you the best and the cheapest hotel
1:39
Same way, in India we have Pesabaza.com, PolicyBaza.com, so PolicyBuzzard.com compares all the policies and gives it the best and the cheapest policy
1:48
Same way, for IT experts, we have Gartner Company. Gartner Company prepares this kind of cordents and compares all the products based on features
1:57
functionalities and price. So here if you see, there are different products, PI products in this available in the market
2:03
We have ClickView, Tably and Microsoft. And you can see Microsoft is on the top
2:08
So if you compare with other products, other BI products, it is one of the best tool in the market today
2:12
There might be a conflict that Microsoft is a brand. There are many BI products inside Microsoft
2:17
So still you can see PowerBei is one of the best here. Now the next one we have what is the Power BI architecture How does it work all together So let me explain you PowerBi desktop There are many tools in PowerBiDi but we be mostly focusing on PowerBay desktop
2:33
So PowerBee desktop is used by developers to create reports and charts
2:37
Suppose you create a chart, you create a report, you are a developer. Okay. Now you can create a chart or reports from different data sources, like you can prepare from Excel, CSV, PDF, SQL, Oracle, and website, and also from 99 different data sources
2:52
Bring data from 99 data sources, create charts visual, and then finally, if you want to share with someone, you can use PowerBia service account
3:00
This is an online account which is available on the web, and then you can publish all your reports into PowerBia service
3:07
So this entire work is completely automated. You don't have to do it manually
3:12
Get data from Excel monthly, create some charts, and then publish it online
3:16
So this can be automated using this PowerBia architecture. Now let us see in detail
3:20
this PowerBay desktop is divided into multiple parts. What are those parts
3:24
Number one, there are many tools in PowerBIA. First one is Power Query
3:28
Second one is PowerPivot and third one is PowerBIA service or I can say PowerView
3:34
So here Power Query is used for cleaning data. PowerPivot is used for data modeling and PowerView is used for visualization data You can create charts and reports in this particular PowerView Most of the companies spend lot of time in these two tools that is Power Query and PowerPivot
3:51
Here, 70% of the time goes in cleaning data, massaging data, and then only you can work on creating charts and reports
3:58
Now, the next one, how difficult is Power BI? If you're coming to Power BI for the first time, if you're a new user to any BI tool, how difficult it is
4:07
see that. It is very easy, easier than Excel I can say. In Excel, you have to type a function
4:12
we look up some average minimum. Here you do not have to type, just drag and drop and you'll
4:17
get the answers. So it is very, very easy. Next one, it is, as I said, it is one of the best
4:22
BI tool in the market. Therefore, it is easy to learn again. 100% training would be practical
4:27
Whatever topics I'll be showing in the entire video series, all topics are practical
4:32
Nothing is theoretical here. And the next one, most of the topics which I'm showing
4:37
person of the training or the videos are just done by button clicks. So suppose if you don't
4:42
have a keyboard, no problem. Still you can learn power bi. Trying to say button click means it's just
4:47
very easy. Anybody can learn power via, right? So I hope you have understood why to learn power
4:52
BIA. What are the advantages and how easy it is? That's all for this video
