Combining Data Sources
- 1.7k Downloads
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.
KeywordsData Warehouse Logical Relationship Fact Table Excel Data Transactional Database
Unable to display preview. Download preview PDF.