In this chapter, we explored Power Query, the powerful sub-application that's used to ingest and shape data through the creation of queries. Queries are a series of recorded steps for connecting to and transforming data. We connected to multiple data files and learned how to clean up and transform the data to support further analysis. Next, we learned how to merge, copy, and append queries. Finally, we explored some built-in data analysis tools that summarize and visualize the data we are ingesting.

In the next chapter, we will import the data into tables in order to build a data model by connecting these tables to one another via relationships. We will also build the necessary calculations that will complete our model.