Excel for Decision Making
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?
November 8, 2013
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.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 157
mey tithveasna: 69
Anders Sehlstedt: 31
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas