• Contents
• 1. Why use Excel to analyze / visualize Snowplow data?
• 2. Setting up Excel to directly fetch Snowplow data from Amazon Redshift
• 2.1 Install the Redshift ODBC driver
• 2.2 White label your local IP address with Amazon Redshift security
• 2.3 Create a data connection in Windows to your Snowplow data in Redshift, via ODBC
• 2.4 Use that connection to fetch Snowplow data from Excel, directly into your Excel workbook
• 3. Setting up Excel to directly fetch Snwoplow data from PostgreSQL
• 4. Fetching data into Excel as a PivotTable or PivotChart Report
• 5. Notes
• Managing the volume of data inserted into Excel
• Excel 2013 vs Excel 2010
• 6. Next steps