• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Using Disparate Data Sources ... > Working with Disparate Data Sources

Working with Disparate Data Sources

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 dataset 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 will encounter will come from disparate data sources—meaning sets of data that are from separate systems, stored in different locations, and saved in a variety of formats. In an Excel environment, disparate data sources generally fall into one of two categories: external data or multiple ranges.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint