Advantages of Power Query
Although many of the actions taken in it could be done using traditional Excel formulas, Power Query has several advantages that make it irresistible:
- Import data from multiple sources: With Power Query, you can now import data in a wide range of different formats such as
.txt
,.csv
,.xls
, and PDF. You can even extract data from databases and the web. - Simplicity: Especially for users who find formulas a daunting prospect, Power Query provides a simpler and much more pleasant way of getting things done.
With a few clicks of the mouse, you are able to achieve what complex formulas can do and much more.
- Large datasets: Power Query can comfortably work with datasets of tens, and even hundreds, of millions of rows.
- Speed: Working out what formulas to use to clean data, constructing the formulas, and then applying them can be time-consuming. The same result can be achieved in Power Query with just a few clicks of the mouse.
- File...