Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

CHAPTER 7. Analyzing disparate data sources with pivot tables

In this chapter, you will:

• Use the Data Model

• Build a pivot table using external data sources

• Leverage Power Query to extract and transform data

Up to this point, you have been working with one local table located in the worksheet within which you are operating. Indeed, it would be wonderful if every data set you came across was neatly packed in one easy-to-use Excel table. Unfortunately, the business of data analysis does not always work out that way.

The reality is that some of the data you encounter will come from disparate data sources—sets of data that are from separate systems, stored in different locations, or saved in a variety of formats. In an Excel environment, disparate ...