Technical requirements
You will need an internet connection to download the relevant files from GitHub. Also, the code files for this chapter can be found at:
https://github.com/PacktPublishing/Learn-Power-Query
This chapter assumes that you already know how to write basic formulae in Excel.
For Code in Action video of this chapter please visit the following link: https://www.youtube.com/watch?v=5TuXxIuMehY&list=PLeLcvrwLe186O_GJEZs47WaZXwZjwTN83&index=3&t=0s.
Businesses have always used data for analysis and then, based on the results, make decisions about the future of their business. Many decisions today are almost instant decisions. People do not want to wait for the information to be analyzed; they want quick responses and turnaround times. For years, businesses used analytics to uncover the basic trends and insights, even before big data was a phrase. Of course, today, businesses need to be able to analyze huge amounts of data, which allows them to be...