How to connect your report to Excel for use in reporting
Overview
Once you have created a datasource in Alli, you can import this data into Excel. This is helpful for customers and team members who want to host their data analysis and visualizations in an Excel spreadsheet format. Formatting will stay consistent as data refreshes.
Instructions
Open Excel on your computer.
Click on the Data tab from the top hand navigation.
Click on New Database Query
Click on SQL Server ODBC (if you do not see this set up on your computer, please reach out to IT Helpdesk on Slack or through the Hub).
Under System DSN, find redshift.data.pmg.com.
Highlight redshift.data.pmg.com and click OK.
Dropdown both the redshift.data.pmg.com folder and the datawarehouse folder.
Navigate to your client and report and click Return Data.
Choose which cell and sheet to drop the data into.
You will see your data populate in the cells chosen.
To refresh data (that has first been updated or refreshed as a datasource in Alli), click on the Data tab then hit Refresh.
These reports are not in alphabetical order. As a workaround, you can highlight the name of any report and change the name to your intended report instead with basic SQL language (example above).