Snowflake User Group – Chicago

Date: March 04, 2020

Time: 4:00 PM

The Snowflake User Group – Chicago is getting together to share best practices, collaborate on data management tips and tricks, and network with other Snowflake users and data enthusiasts in the local area. Whether you are just starting out with Snowflake, or are a veteran user, come on out.

Register now and join us at TechNexus on March 4th at 4:00 pm.

In this session you’ll learn how Echo, a global manufacturer of outdoor power equipment, is using Snowflake to power their executive dashboards and finding rich insights in their data. Following that presentation, Aptitive will lead an ETL Lab on Snowflake stored procedures, ADF, and Azure Functions.

Bring your laptops and have access to your snowflake accounts, and we will walk through the exercise together.

AGENDA:

4:00 PM – Arrival and Networking

4:30 PM – Using Snowflake to Build an Enterprise DW and Power Executive Dashboards

Learn how Echo Incorporated, a global manufacturer of outdoor power equipment, is using Snowflake ingest data from disparate source systems into a modeled enterprise-wide data warehouse. In this session, Aarthi Ramesh, Business Intelligence Manager at Echo, will go over how Snowflake:

  • Simplified the pains of a traditional on-prem data warehouse
  • Reduced time spent manually creating reports
  • Power POS and Account Manager Incentives dashboards

5:15 PM – Snowflake Lab – ETL using Snowflake stored procedures, ADF, and Azure Functions

Learn how Aptitive builds custom ETL processing in Snowflake and Azure. In this lab, Melanie Ruiz, Managing Consultant at Aptitive, will walkthrough:
Azure Data Factory pipeline
Azure Functions written in C#
Snowflake stored procedures to extract data from a raw layer, load into a stage table, and merge into target.

6:00 PM– Networking and Snowflake Office Hours

When:

Wednesday, March 4, 2020
4:00pm  – 7:00pm

Where:

TechNexus
20 N Upper Wacker Dr
Suite 1200
Chicago, IL 60606