CHAPTER 40
Making Queries Work Together
Data analysis is frequently done in layers, with each layer of analysis using or building on the previous layer. When you build a pivot table using the results of a Power Query output, you are layering your analysis. When you build a query based on a table created by an SQL Server view, you are also creating a layered analysis.
You'll often find the need to build queries on top of other queries to get the results you're seeking. That's what this chapter is all about. Here you'll take a look at a few ways that you can advance your data analysis by making your queries work together.
|
You can follow along with the examples in this chapter by downloading these sample files from
|
