Technical requirements
You need an internet connection to download the relevant files from GitHub. Also, the code files for the chapter can be found at https://github.com/PacktPublishing/Learn-Power-Query/.
This chapter assumes that you understand the M syntax and structure and know how to code text data types, numeric data types, lists, records, tables, searches, and shares. You should also know how to import a CSV file. If you are unsure on how to do this, please refer to Chapter 9, Working with M.
You will also need to have a SQL server. If you do not have one, I will show you how to download and install a free version of SQL Server legally. You will also need the AdventureWorks
database, which can be found at https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15.
For Code in Action video of this chapter please visit the following link: https://www.youtube.com/watch?v=mzRQLLQCmvg&list=PLeLcvrwLe186O_GJEZs47WaZXwZjwTN83&...