greeting to All...

Hope so all fine happy in your life.today I,m share one of best market tool education post
Here is discuss about power BI tool
Introduction,why you should learn Power BI ?
Power BI Architecture.
Detail sharing in this post.

Introduction Of Power BI

What is power BI ?
Power BI is business intelligence power tool which is available in market here because many reasons Power BI uses in Reports and Dashboards.

1.Cleaning data

2.Modeling data

3.Visualize data

Why you should be learn Power BI ?

One of most popular BI tool in market today.
High demand Power BI expert in the market.
Easy way to learn and use.
In this market all complete work automatic of manual task.
Getting the data just click one button.
Send and share your data with anyone just one click.
Its is one of the cheapest price tool in market. In 10$ you for each user per month which is you can get.
In market leaders alway prefer Power BI rather then Microsoft. Now Microsoft tops in market but user faces some challenge MicroStrategy.

POWER BI Architecture

Power BI is a tool you can create charts,reports you can access with power BI.
Some other software.
Excel
CVS
SQL
Oracle
Web
99+ data sources

This is online account to you can published you all reports share with Power BI services.
This work is automatically done. You get data form monthly excel and create some charts and published.In Power BI tool not any work manually all work done by practical.

Developer || End User || Work

Power Query use for cleaning data.
Power Pivot use for data modeling.
Power view use for visualize data.

Most of companies spend our time two power query and power pivot tools.
70% time spend time you cleaning data then next steps work on visualize data power view.
Power BH is very easy to learn if you are coming in the new user easier way to learn.In power BI tool not like excel drags drops query types.
It is one of the best power BI tool in market.
100% training would be practical.
In this all topic practical not any theoretical.
80% of power BI training would be using button clicks.
All videos work just done with one click.
Even that if you don't have keyboard not tension any more still learn Power BI tool.

So here discuss some Power Query & Power Pivot

To clean data in power query.
Which language is use in M function. In use 800 M function.
Required more memory for M function.

In Power Pivot to do data modeling is use connecting data relationship,charts & reports.
Is beaten power query function 1st power pivot
Uses DAX ( data analytical expression ) function.
In 300 data function.most of both power BI function same in power query & power pivot.
Whenever you must choose the 3rD function why? the reason is DAX is light weight function does not occupy much space this power pivot function more faster then power query function.

hope so this post help to know Power BI & their Function

Thanks to reading my post

Regard

@sanabl