arrow_back

Exploratory Data Analysis using Bigquery and Workbench Instances

Get access to 700+ labs and courses

Exploratory Data Analysis using Bigquery and Workbench Instances

Lab 2 год universal_currency_alt 1 кредит show_chart Середній
info This lab may incorporate AI tools to support your learning.
Get access to 700+ labs and courses

Overview

In this lab you learn the process of analyzing a dataset stored in BigQuery using a Workbench Instance notebook to perform queries and present the data using various statistical plotting techniques. The analysis will help you discover patterns in the data.

Learning objectives

  • Create a Workbench Instance Notebook
  • Connect to BigQuery datasets
  • Perform statistical analysis on a Pandas Dataframe
  • Create Seaborn plots for Exploratory Data Analysis in Python
  • Write a SQL query to pick up specific fields from a BigQuery dataset

Vertex AI is a unified platform for building, deploying, and managing machine learning (ML) applications.

Vertex AI Workbench notebooks provide a flexible and scalable solution for developing and deploying ML models on Google Cloud. Choose Workbench if you need more customization options and need complete control over your machine learning environment. It offers the security and compliance features needed for enterprise organizations and integrates with other Google Cloud services like Vertex AI and BigQuery for an enhanced data science and machine learning workflow.

BigQuery is a powerful, fully managed, serverless data warehouse that allows you to analyze and manage large datasets with ease. BigQuery uses a familiar standard SQL dialect, making it easy for analysts and data scientists to use without needing to learn a new language.

Vertex AI offers two Notebook Solutions, Workbench and Colab Enterprise.

Workbench

Vertex AI Workbench is a good option for projects that prioritize control and customizability. It’s great for complex projects spanning multiple files, with complex dependencies. It’s also a good choice for a data scientist who is transitioning to the cloud from a workstation or laptop.

Vertex AI Workbench Instances comes with a preinstalled suite of deep learning packages, including support for the TensorFlow and PyTorch frameworks.

Set up your Qwiklabs environments

Qwiklabs setup

For each lab, you get a new Google Cloud project and set of resources for a fixed time at no cost.

  1. Sign in to Qwiklabs using an incognito window.

  2. Note the lab's access time (for example, 1:15:00), and make sure you can finish within that time.
    There is no pause feature. You can restart if needed, but you have to start at the beginning.

  3. When ready, click Start lab.

  4. Note your lab credentials (Username and Password). You will use them to sign in to the Google Cloud Console.

  5. Click Open Google Console.

  6. Click Use another account and copy/paste credentials for this lab into the prompts.
    If you use other credentials, you'll receive errors or incur charges.

  7. Accept the terms and skip the recovery resource page.

Task 1. Create a Workbench Notebook

  1. In the Google Cloud console, from the Navigation menu (), select Vertex AI.

  2. Click Enable All Recommended APIs.

  3. In the Navigation menu, click Workbench.

    At the top of the Workbench page, ensure you are in the Instances view.

  4. Click Create New.

  5. Configure the Instance:

    • Name: lab-workbench
    • Region: Set the region to
    • Zone: Set the zone to
    • Advanced Options (Optional): If needed, click "Advanced Options" for further customization (e.g., machine type, disk size).

  1. Click Create.

This will take a few minutes to create the instance. A green checkmark will appear next to its name when it's ready.

  1. Click Open Jupyterlab next to the instance name to launch the JupyterLab interface. This will open a new tab in your browser.

  1. Click the Python 3 icon to launch a new Python notebook.

  1. Right-click on the Untitled.ipynb file in the menu bar and select Rename Notebook to give it a meaningful name.

Your environment is set up. You are now ready to start working with your Vertex AI Workbench notebook.

Task 2. Clone a repo within your Vertex AI Notebook instance

The GitHub repo contains both the lab file and solutions files for the course.

  1. Copy and run the following code in the first cell of your notebook to clone the training-data-analyst repository.
!git clone https://github.com/GoogleCloudPlatform/training-data-analyst

  1. Confirm that you have cloned the repository. Double-click on the training-data-analyst directory and ensure that you can see its contents.

  1. In the notebook interface, navigate to training-data-analyst > courses > machine_learning > deepdive2 > launching_into_ml > solutions and open workbench_explore_data.ipynb.

  2. In the notebook interface, click on Edit > Clear All Outputs (click on Edit, then in the drop-down menu, select Clear All Outputs).

  3. In the Select Kernel dialog, choose Python 3 from the list of available kernels.

  4. Carefully read through the notebook instructions.

Congratulations!

In this lab you learned how to:

  • Create a Workbench Instance Notebook
  • Clone a GitHub repository
  • Connect to a BigQuery dataset
  • Perform statistical analysis on a Pandas Dataframe
  • Create Seaborn plots for Exploratory Data Analysis in Python
  • Write a SQL query to pick up specific fields from a BigQuery dataset.

End your lab

When you have completed your lab, click End Lab. Qwiklabs removes the resources you’ve used and cleans the account for you.

You will be given an opportunity to rate the lab experience. Select the applicable number of stars, type a comment, and then click Submit.

The number of stars indicates the following:

  • 1 star = Very dissatisfied
  • 2 stars = Dissatisfied
  • 3 stars = Neutral
  • 4 stars = Satisfied
  • 5 stars = Very satisfied

You can close the dialog box if you don't want to provide feedback.

For feedback, suggestions, or corrections, please use the Support tab.

Manual Last Updated November 25, 2024

Lab Last Tested November 25, 2024

Copyright 2022 Google LLC All rights reserved. Google and the Google logo are trademarks of Google LLC. All other company and product names may be trademarks of the respective companies with which they are associated.

Before you begin

  1. Labs create a Google Cloud project and resources for a fixed time
  2. Labs have a time limit and no pause feature. If you end the lab, you'll have to restart from the beginning.
  3. On the top left of your screen, click Start lab to begin

This content is not currently available

We will notify you via email when it becomes available

Great!

We will contact you via email if it becomes available

One lab at a time

Confirm to end all existing labs and start this one

Use private browsing to run the lab

Use an Incognito or private browser window to run this lab. This prevents any conflicts between your personal account and the Student account, which may cause extra charges incurred to your personal account.