7. Analyzing Disparate Data Sources with Pivot Tables
Until 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 were 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 comes from disparate data sources—meaning sets of data that are from separate systems, stored in different locations, or saved in a variety of formats. ...
Get Pivot Table Data Crunching: Microsoft now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
