Track 2: Analytic Innovations

BigQuery Essentials For Data Practitioners

Google Cloud Platform (GCP) is rapidly gaining attention for enterprise analytics and begins to impact the Swiss cloud landscape. Solid knowledge of BigQuery, as a GCP data warehouse and analytics tool, is sought-after for many company-level transformation projects.

In this hands-on session, we dive into the powerful usage of GCP, utilizing a public data set to showcase BigQuery capabilities: querying, visualizing data and creating ML models. Serving as a jump start in cloud analytics, the workshop equips you with practical experience in BigQuery and more. Join us for an insightful look into a selected use case and the valuable learnings which can be drawn from it. You will then be prepared to harness this in-demand technology in your future projects.

Learning goal

At the end of workshop, participants will:

  • Know the value of BigQuery over traditional data warehouses

  • Be familiar with the BQ console for SQL analytics

  • Have a short experience on data visualization with Looker Studio

  • Have exposure to BigQuery machine learning capabilities

  • Know key cost management and security best practices to apply

Pre-requisites

Basic SQL Knowledge

  • Tristan Stampfler

    GCP Professional Data Engineer Certified

    Tristan focuses on cloud engineering and data science. He holds an MSc in Data Science from ETH Zurich and an MSc in Applied Mathematics from Ecole polytechnique. Since he joined D ONE, he has driven several client projects on Google Cloud Platform, ranging from data analytics to cloud migration.

  • Diana Mitache

    Data Visualisation Expert and GCP Certified

    Diana holds a MSc in Managing Information and Business Technology from Loughborough University in England. Before joining D ONE, she worked as a data visualisation consultant in several industries. Diana has been with the team since 2021.