Našimi kurzy prošlo více než 10 000+ účastníků
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
This article describes the basic components of Power BI in Excel and defines what does they do.
We are talking about Power BI in Excel – not Power BI in a separate online or desktop application.
Power Query can be used for getting data to Excel, Power Pivot manages the data stored in Data Model and Power View presents the data in reports.
Power Query (form Excel 2016 named Get and Transform) can not only download data to Excel, but make nice transformations as well. For example filter, calculate, merge multiple sources etc. etc.
Power Query doesn’t really store data, just handle their flow – it is ETL software.
Inputs for Power Query
Outputs
More tutorials related to Power Query
Power Pivot manages data in Data Model, which basically is a data warehouse. Data in Data Model are physically stored in xlsx file, but not in sheets and cells.
Inputs for Data Model
Basically, you can connect Power Query to external or internal source directly with or without Power Query. It only has to be used for more complex connections.
Outputs of Data Model (of Power Pivot)
… are quite limited.
More tutorial s related to Power Pivot
Power view enables you to create nice report, containing images, maps etc.
Inputs for Power View
Outputs of Power Query
More tutorials related to Power View.
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
Pište kdykoliv. Odpovíme do 24h
© exceltown.com / 2006 - 2023 Vyrobilo studio bARTvisions s.r.o.