Auf dieser Website sind externe Links mit dem Symbol gekennzeichnet.
In meinen downloadbaren Unterlagen (Folien, Skripte etc.) sind alle Links extern und nicht gesondert gekennzeichnet.



What is PowerQuery all about?


PC, not Mac

PowerQuery, in its powerful form, is only available to Microsoft Windows Excel users.
PowerQuery is also available on the Mac, with at most 10% of the capabilities available to its Windows counterpart.


PowerQuery - massively underrated?

PowerQuery can

  • Import data from almost any source
  • Import and merge many similar files at the same time
  • Combine and merge tables
  • Add calculated fields based on arbitrary conditions
  • Unpivot tables (resolve crosstabs)
  • Pivot tables without aggregating
  • Copy down/up and complete column contents
  • Load only data links and make them available for editing. Advantage: Bypass the maximum number of rows possible in Excel.



Examples

PowerQuery is very easy to learn despite its wealth of functions. In a small video series, some application examples are shown with the help of actual data.


Import CSV

Data protection notice: The Video Link below leads to an external Ressource (YouTube)


Append Data Sets

Data protection notice: The Video Link below leads to an external Ressource (YouTube)


Unpivot Table

Data protection notice: The Video Link below leads to an external Ressource (YouTube)


Merge Tables

Data protection notice: The Video Link below leads to an external Ressource (YouTube)