Skip to Main Content
Microsoft Excel 365 Bible
book

Microsoft Excel 365 Bible

by Michael Alexander, Dick Kusleika
March 2022
Beginner to intermediate content levelBeginner to intermediate
1072 pages
28h 16m
English
Wiley
Content preview from Microsoft Excel 365 Bible

CHAPTER 37Making 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 PivotTable using the results of a Power Query output, you are layering your analysis. When you build a query based on a table created by a 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.

  1. Sales By Employee.xlsx
  2. Appending_Data.xlsx
  3. Merging_Data.xlsx
  4. FuzzyMatch.xlsx

Reusing Query Steps

It's common to rely on the same main data table for all kinds of analysis. Even the simple table shown in Figure 37.1 can be used to create different views: sales by employee, sales by business segment, sales by region, and so forth.

Of course, you can build separate queries, each performing different grouping and aggregation steps, but that ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel 2019 Bible

Excel 2019 Bible

Michael Alexander, Richard Kusleika, John Walkenbach

Publisher Resources

ISBN: 9781119835103Purchase Link