Skip to Main Content
Excel Power Pivot & Power Query For Dummies, 2nd Edition
book

Excel Power Pivot & Power Query For Dummies, 2nd Edition

by Michael Alexander
March 2022
Beginner to intermediate content levelBeginner to intermediate
288 pages
7h 21m
English
For Dummies
Content preview from Excel Power Pivot & Power Query For Dummies, 2nd Edition

Chapter 11

Making Queries Work Together

IN THIS CHAPTER

check Reusing query steps

check Consolidating data with the Append feature

check Understanding join types

check Using the Merge feature

check Fuzzy matching when merging queries

Data is frequently analyzed in layers, with each layer of analysis using or building on the previous layer. You may not know it, but you already build layers all the time. For instance, when you build a pivot table using the results of a Power Query output, you’re layering your analysis. When you build a query based on a table created by a SQL Server view, you’re also creating a layered analysis.

Sure, you would probably love to be able to analyze a single data source and call it a day. But that’s not how data analysis works. You often find the need to build queries on top of other queries to get the results you’re looking for. That’s what this chapter is all about. In this chapter, I help you examine a few ways you can advance your data analysis by making your queries work together. ...

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

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Wayne Winston
Microsoft Excel 365 Bible

Microsoft Excel 365 Bible

Michael Alexander, Dick Kusleika
Excel 2019 Bible

Excel 2019 Bible

Michael Alexander, Richard Kusleika, John Walkenbach

Publisher Resources

ISBN: 9781119844488Purchase Link