GDG Seattle Cloud Study Jam 2019

GDG Seattle Cloud Study Jam 2019

Transcript

1. Google Cloud Study Jam March 9, 2019 GDG Seattle 1
2. GDG Seattle GDG Seattle is an inclusive community where developers, designers, and entrepreneurs of all skill levels, genders, religions, and backgrounds are welcome to learn, practice, and share Google technologies, services, and platforms. Our motto is “Be excellent to each other” if you see or experience anything different, please contact GDG Seattle organizers. 2
3. #CloudStudyJams | @GDGSeattle Agenda 9:15AM Check in and breakfast 10:00AM GCP essentials for those new to GCP 10:30AM Baseline: Data, ML, AI 12:00PM Lunch 12:30PM Continue labs in Baseline: Data, ML, AI 2PM Start labs in ML APIs 3PM Wrap up 3
4. #CloudStudyJams | @GDGSeattle Information you will need • Join our Google Groups bit.ly/GoogleGroups-CloudStudyJam-GDGSeattle • All attendees should have free access to qwiklabs for 1 month • Must finish the Baseline: Data, ML, AI quest to earn a badge and get another month of free access. 4
5. #CloudStudyJams | @GDGSeattle Upcoming GDG Seattle events • 3/23 - The BigQuery BBQ (link) • 3/26 - TensorFlow Dev Summit Viewing Party (link) • April - Flutter talk • 4/20 - Cloud Next Extended • May - I/O Extended (lightning talks) 5
6. #CloudStudyJams | @GDGSeattle Additional learning resources • Google BigQuery: The Definitive Guide (on O’Reilly Safari) • Qwiklab: Data Science on the Google Cloud Platform • Coursera: ◦ Data Engineering on Google Cloud Platform Specialization ◦ Machine Learning with TensorFlow on Google Cloud Platform Specialization ◦ Advanced Machine Learning with TensorFlow on Google Cloud Platform Specialization • BigQuery book: Google BigQuery: The Definitive Guide • Data science book: Data Science on the Google Cloud Platform • Follow Margaret on Medium | Twitter to learn “ML and TensorFlow” 6
7. #CloudStudyJams | @GDGSeattle SQL Query Here is the query Lak showed us during the Study Jam: Usa names query: SELECT name, SUM(IF(gender = 'M', number, 0)) AS is_male, SUM(IF(gender = 'F', number, 0)) AS is_female, SUM(number) AS tot FROM `bigquery-public-data.usa_names.usa_1910_current` group by name having is_male > 0 AND is_female > 0 AND is_male / (is_male + is_female) BETWEEN 0.3 and 0.7 order by tot desc limit 10 7
8. #CloudStudyJams | @GDGSeattle Thank you! Google Coaches Mylene Biddle Lak Lakshmanan Daniel Torre Volunteers & GDG Seattle organizers Margaret Maynard-Reid Brandon Donnelson Clive Boulton Yenchi Lin 8