2Data analysis and presentation

• 2.1Analysis with BigQuery and notebooks

  Understand running SQL queries in BigQuery to produce reports and key insights, analyzing and visualizing data with Jupyter notebooks (Colab Enterprise), and conducting data analysis to answer business questions.

• 2.2Dashboards with Looker

  Understand creating, modifying, and sharing dashboards to answer business questions, choosing between Looker and Looker Studio, and manipulating basic LookML parameters that define the data model.

• 2.3Using machine learning models

  Understand creating ML models with BigQuery ML and AutoML, using pretrained large language models (LLMs) via remote connections in BigQuery, the steps of a standard ML project (data collection, training, evaluation, prediction), and organizing models in the Model Registry.