This hands-on workshop guides participants through utilizing the free tier of Google Cloud Platform to analyze large public datasets using BigQuery, Google’s cloud data warehousing solution. The session includes a brief overview of cloud solutions and their significance in medicine, step-by-step instructions on signing up for free services, and practical exercises in SQL queries within BigQuery. Participants will also learn how to integrate R with BigQuery. By the end of the workshop, attendees will have initiated a data analysis project, established a Google Cloud account for ongoing learning, and developed confidence in SQL, cloud computing, and system interoperability.
Main Sections
00:00 Introduction
06:28 GCP and BogQuery Orientation
01:15:45 BigQuery Data, SQL in BigQuery, Gemini
02:28:44 R/RStudio and BigQuery Integration
More resources
R Validation Hub Site: https://www.pharmar.org/
Main Site: https://www.r-consortium.org/
News: https://www.r-consortium.org/news
Blog: https://www.r-consortium.org/news/blog
Join: https://www.r-consortium.org/about/join
Twitter: https://twitter.com/rconsortium?lang=en
LinkedIn: https://www.linkedin.com/company/r-consortium
Mastodon: https://fosstodon.org/@RConsortium