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