Agenda

AGENDA

DAY 1 - Thursday, June 25 2020

(All Times US Eastern)

Data Lakes and Big Data Processing

(Schedule modified due to GE meeting from 9-9:45 AM)

TimeModuleSpeakerNotes
8:30-9:00 AMOverview of Data and Analytics Services on AWSJason Hoog, AWS Solution ArchitectTopics include Data Lakes on Amazon S3, Big Data Design Patterns, the Lake House
9:45-10:30 AMAmazon EMRSreekanth Munigati, AWS Big Data SpecialistTopics include Big Data Processing, Workflows, HUDI and jobs
10:30-10:45 AMBREAK
10:45-11:30 AMAWS GlueDeenbandhu Prasad, AWS Data Warehouse SpecialistTopics include the AWS Data Catalog, Glue Jobs, Data Catalog Integrations
11:30 AM-1:00 PMLAB: AWS Glue INSTRUCTIONS:
  1. Check your email for a link to your Immersion Day Lab Account. (NOTE: make sure to sign out of any existing AWS accounts first!)
  2. Navigate to https://lakeformation.aworkshop.io/
  3. Read through the Instructions and Sample Data sections. This lab will begin with AWS Glue and finish up tomorrow with AWS Lake Formation.
  4. Complete Labs - Beginner section. Remember to add your initials to any resource name you create so as to not conflict with other account users.
1:00-1:15 PMOffice Hours Open Q&A with presenters

DAY 2 - Friday, June 26 2020

Data Query and Governance

TimeModuleSpeakerNotes
8:00-8:45 AMAmazon Lake FormationDeenbandhu Prasad, AWS Data Warehouse SpecialistTopics include governance and access control with integration to the AWS platform
8:45-9:30 AMLAB: Lake Formation INSTRUCTIONS:
  1. You will use the same lab account as you used for Day 1. Check your email for a link to your Immersion Day Lab Account. (NOTE: make sure to sign out of any existing AWS accounts first!)
  2. Navigate to https://lakeformation.aworkshop.io/
  3. Complete Labs - Intermediate section. Remember to add your initials to any resource name you create so as to not conflict with other account users.
9:30-9:45 AMBREAK
9:45-10:30 AMAmazon Athena Jeetesh Srivastva, AWS Data Warehouse Specialist
Francis Jayakumar, AWS Analytics Business Development Manager 		We will discuss the Amazon Athena service as it relates to query patterns, cost model and schema optimization. Will also discuss recent features and roadmap.
10:30-11:15 AMAmazon QuickSight Neal Cauley, Amazon QuickSight Business Development Manager
Francis Jayakumar, AWS Analytics Business Development Manager 		Using Amazon QuickSight in an enterprise environment. Will also discuss recent features and roadmap.
11:15-12:00 PMLAB: Amazon Athena + QuickSight INSTRUCTIONS:
  1. You will use the same lab account that you previously used. Check your email for a link to your Immersion Day Lab Account. (NOTE: make sure to sign out of any existing AWS accounts first!)
  2. Complete the lab at Visualizing Flight Data with Amazon QuickSight and Athena
12:00-12:15 PMOffice Hours Open Q&A with presenters

DAY 3 - Monday, June 29 2020

Amazon Redshift

TimeModuleSpeakerNotes
8:30-9:15 AMAmazon Redshift Features Harshida Patel, AWS Data Warehouse Specialist
Francis Jayakumar, AWS Analytics Business Development Manager 		Overview of new Amazon Redshift Features
9:15-10:00 AMDEMO: Operating a Redshift Cluster INSTRUCTIONS:
  1. You will receive a link to a new lab account. Check your email for a link to your Immersion Day Lab Account. (NOTE: make sure to sign out of any existing AWS accounts first!)
  2. Navigate to the AWS Redshift Console to view your cluster and follow along with the demo.
10:00-10:15 AMBREAK
10:15-11:00 AMAmazon Redshift Spectrum Jeetesh Srivastva, AWS Data Warehouse Specialist Spectrum used in a data lake / house strategy. Hot and cold models.
11:00-11:45 AMAmazon Redshift Advanced Features Harshida Patel, AWS Data Warehouse Specialist Using Amazon Redshift Federated Query, Bloom Filters, Elastic Resize, Concurrency Scaling and Operational features.
11:45-12:45 PMLAB: Redshift Schema and Data Ingestion INSTRUCTIONS:
  1. Log back into the lab account from earlier. Check your email for a link to your Immersion Day Lab Account. (NOTE: make sure to sign out of any existing AWS accounts first!)
  2. Navigate to https://lab.d3rxuq8jya0ojw.amplifyapp.com/lab.html
  3. Complete the lab using the cluster that was created in your lab account.
12:45-1:00 PMOffice Hours Open Q&A with presenters