This assignment has multiple steps. Please complete them in this order.
Read Sno
This assignment has multiple steps. Please complete them in this order.
Read Snowflake Review: A data warehouse made better in the cloud by Martin Heller.
Setup your Snowflake free trial. Watch this YouTube video for directions.
Watch this Connect to Snowflake through Microsoft Excel tutorial.
Pull in a data set from Excel into Snowflake following the above videos.
For accessing your data after it’s loaded into Snowflake, I will provide a free key for Tableau that can be used to download the Tableau data visualization product which can be connected to snowflake.
Other tools such as PowerBI can be used if you have access to those already. See below for instructions on downloading Tableau.
Download the latest version of Tableau Desktop and Tableau Prep Builder here
Click on the link above and select “Download Tableau Desktop” and “Download Tableau Prep Builder.”
On the form, enter your Ottawa email address for business e-mail and enter Ottawa University for organization.
Activate with your product key: TCLI-69E5-F8E0-2994-E805
New to Tableau? Engage with their Data Analytics for University Students guide to help get started.
You can continue using Tableau after the class is over by individually requesting your own one-year license through the Tableau for Students program.
Already have a copy of Tableau Desktop installed?
Update your license in the application: Help menu → Manage Product Keys
Need help with Tableau? Find answers to frequently asked questions here.
In a PowerPoint of 5-7 slides, screen shot the steps in creating your connection in Snowflake and the data in Excel.
This can be any data set.
Remember to cite any content you did not create yourself using APA formatting.
References
Heller, M. (2019). Snowflake review: A data warehouse made better in the cloud. InfoWorld.
Kahan Data Solutions. (2020, December 1). Connect to Snowflake through Microsoft Excel [Video]. YouTube.
Snowflakian. (2020, May 16). Snowflake free account creation [Video]. YouTube.