Advertisement

Combining Data Sources

Chapter
  • 1.7k Downloads

Abstract

The principal reason for utilizing PowerPivot for Excel as an ad hoc reporting and analytics solution is its unique capability to combine large volumes of related data from disparate sources. The goal of this chapter is to give you the skills to connect to different data sources, relate the information from those sources, and reuse the solution over time by refreshing the data.

Keywords

Data Warehouse Logical Relationship Fact Table Excel Data Transactional Database 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Barry Ralston 2011

Authors and Affiliations

There are no affiliations available

Personalised recommendations