To connect your SyncHub data to Microsoft Excel, simply setup a new Database Connection:
Select Data -> Get Data -> From Sql Server Database from the main ribbon:
Log in to SyncHub to obtain the connection details to your data warehouse:
Enter your server credentials when prompted:
Make sure you select Database as your crentials method, then enter the username/password for your data warehouse:
Select the table you wish to import:
And voila - here is your data!
Excel will keep your data up to date - no more copy/pasting!