This 2-day course is designed for data analysts who want to learn about using BigQuery for their data analysis needs. Through a combination of labs and demos, this course covers various topics that discuss how to ingest, transform, and query your data in BigQuery to derive insights that can help in business decision-making.
Participants should have:
This course is designed for Data analysts who want to learn how to use BigQuery for their data analysis needs. This could include those in-training or currently fulfilling data analyst roles with a working knowledge of Google Cloud but have little prior experience with BigQuery before.
Module 0: Course Introduction
Module 1: BigQuery for Data Analysts
Module 2: Exploring and preparing your data with BigQuery
Module 3: Cleaning and transforming your data
Module 4: Ingesting and storing BigQuery datasets
Module 5: Visualising your insights from BigQuery
Module 6: Developing scalable data transformation pipelines in BigQuery with
Dataform
Module 7: BigQuery Studio
Module 8: Summary
There are no formal examinations within this course. There will be a module review and summary following the practical hands-on lab, quiz and slide-deck deliveries. This will further enforce learning and support additional resource finds, for continued learning and development.
Within this course there are opportunities for learners to engage in hands-on labs to support module learning. In addition, each module will also have a quiz, to support knowledge capture.
Join our public courses in our Switzerland facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
Switzerland is globally recognized as the gold standard for fintech, precision engineering, and data privacy. Zurich and Geneva are not only financial capitals but also critical hubs for blockchain innovation and high-security IT infrastructure. Home to ETH Zurich, one of the world's leading technical universities, the Swiss ecosystem attracts the brightest minds in cryptography and systems engineering. Our IT training services in Switzerland are designed for those who operate in high-stakes environments where accuracy and security are paramount. We offer specialized courses that cover the full spectrum of modern technology, from secure cloud management to advanced data analytics, ensuring that professionals in the Swiss confederation maintain their competitive edge in a digital-first world.