Dashboards
Power Query
Power Pivot
Excel for Decision Making
Power BI
June 2, 2016
I'm learning a lot from your course in power query, but am i wrong in the assumption that creating all these queries is mainly so i can use them with power pivot?
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Hi Bill,
You can build pivot tables from a table produced by a power query (regular pivot tables, not power pivot tables). More, the Group By tool can perform aggregations just like a pivot table, this way you will not even need a pivot table.
The tables produced by power query can be used as is, like in data comparisons for example (with different join kinds: Left Outer, Left Anti, and so on), or as a lookup table.
Many users will just need to clean the data, to use it as a dynamic source for charts and simple pivot table reports.
Power Pivot is mostly used in complex analysis, with multiple queries from relational databases, so it's not for regular users, that's one of the reasons why Power Pivot is available only in PRO versions of Excel (Office).
On the other side, Power Query is available for all users, in almost all versions (except versions lower than 2010).
My opinion is that the assumption is wrong, Power Query is not used mainly for Power Pivot.
Answers Post
1 Guest(s)