Abstract: 

In this hands-on session, attendees will learn how to create a GCP project that uses Google's public BigQuery data. In addition to sharpening their SQL skills in BigQuery, attendees will also learn how to use Google Colab notebooks to do additional analysis of data. Finally, attendees will learn how to create a map that displays data creatively. Anyone who wants to try Google Cloud Platform for the first time will find this session useful, as will people who want to practice SQL skills or learn about Jupyter notebooks.

Background Knowledge
For hands-on, you should already have a Google Cloud Platform (GCP) account. If you're using a work GCP account, make sure you've been given the right privileges -- creating a project, adding BigQuery resources to a project, etc. Please ensure you are using a computer and a network that doesn't block Google services like Google Drive. If you don't meet these prerequisites, the slide deck and shared notebooks will continue to be available for the next year so you can practice on your own.

Bio: 

Joy Payton is a cloud engineer, data scientist, and adjunct professor who specializes in helping biomedical professionals conduct reproducible computational research. In addition to moving medicine forward through principles of open science and reproducibility, Joy also enjoys teaching citizen scientists how to use public data repositories to understand their own communities better and advocate for change from a data-centric perspective. Her various roles allow Joy to lead efforts to teach people how to write their first line of code and help anyone who's interested climb the data science learning curve. Currently employed by the Children's Hospital of Philadelphia and Yeshiva University, Joy is always open to hearing about open-source, data-centric volunteer opportunities for herself and her students.