Working with Multiple Connections

A workbook can contain multiple connections to multiple data sources. Each connection is listed at the top of the Data window. Each worksheet has a primary connection and can optionally have several secondary connections using data blending. The primary connection and the secondary connections are linked by specified relationships. Adding a secondary connection to a sheet can be useful when you have data in multiple data sources that you want to integrate into a single analysis.

  1.     Understanding Data Blending
  2.     Navigating Connections in the Data Window
  3.     Adding a Secondary Connection
  4.     Defining Relationships
  5.     Example - Data Blending on a Worksheet
  6.     Troubleshooting Data Blending

No comments:

Post a Comment