Skip to main content

Visualise Data in BigQuery

L
Written by Ludvig Persson
Updated over a year ago

We recommend you to use the Explore Data feature found in BigQuery to visualise your data.

Visualise Data Using Google Sheets

  1. Write your query and click to "Run"

  2. Click "Explore Data" and select the tool you want to use. We suggest the "Explore with Sheets" option.

  3. You will be directed to Google Sheets, there click on "Charts"

  4. Visualize the data using the UI.

  5. Export the graph as a PDF and attach it to your submission.

Visualise Data Using Looker Studio

  1. Write your query and click to "Run".

  2. Click "Explore data" and select "Explore with Looker Studio".

  3. You'll be directed to Looker Studio with the queried data loaded. From here you can add grahps or tables via the UI.

  4. To save your charts you can take screenshots of the charts or export as a PDF and add them to your submission .

Visualise Data Using Colab Notebook

Colab Notebooks allow you to write and execute Python code and build your own graphs and tables, for example using Pandas and Matplotlib.

  1. Write your query and click to "Run".

  2. Click "Explore data" and select "Explore with Colab Notebook".

  3. You'll be directed to a new Colab Notebook. The notebook includes boilerplate code to get you going. Do note that you need to execute the first script titled Setup to authenticate your environment.

  4. Follow the next steps outlined in the notebook and you'll be ready to start building your graphs.

  5. You can share your graphs as screenshots pasted along with your submission.

Did this answer your question?