Summary

In this chapter, we have highlighted some of the mistakes and anomalies found in data that make data preparation using traditional formulas a tedious chore. We have learned how Power Query makes this exercise so much easier and removes the emphasis from complex formulas that many shy away from to simple keystrokes.

We have covered just some of the uses of Power Query. There is still a lot more you can do with it, such as extracting data from the web, extracting data from PDF files, and a host of other transform tools that we have not touched.

Finally, Power Query has its own language called M, which can be used to write formulas and further expand its capabilities.

In the next chapter, we will look at actions to take to ensure that you understand your project assignment, as well as how to build your assumptions.