arrow_back

Explore and Create Reports with Data Studio

Join Sign in

Explore and Create Reports with Data Studio

40 minutes Free

GSP409

Google Cloud self-paced labs logo

Overview

Google Data Studio turns your data into informative dashboards and reports that are easy to read, easy to share, and fully customizable. Dashboarding allows you to tell great data stories to support better business decisions.

BigQuery is Google's fully managed, NoOps, low cost analytics database. With BigQuery you can query terabytes and terabytes of data without having any infrastructure to manage or needing a database administrator. BigQuery uses SQL and can take advantage of the pay-as-you-go model. BigQuery allows you to focus on analyzing data to find meaningful insights.

The dataset used in this lab is an ecommerce dataset that has millions of Google Analytics records for the Google Merchandise Store loaded into BigQuery. You will explore the available fields and rows of the dataset for insights.

This lab focuses on how to create new reports and explore your ecommerce dataset visually for insights.

What you'll learn

In this lab, you:

  • Launch Data Studio

  • Create and manipulate a report

  • Create an interactive filter for your report

Setup and requirements

Before you click the Start Lab button

Read these instructions. Labs are timed and you cannot pause them. The timer, which starts when you click Start Lab, shows how long Google Cloud resources will be made available to you.

This hands-on lab lets you do the lab activities yourself in a real cloud environment, not in a simulation or demo environment. It does so by giving you new, temporary credentials that you use to sign in and access Google Cloud for the duration of the lab.

To complete this lab, you need:

  • Access to a standard internet browser (Chrome browser recommended).
Note: 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.
  • Time to complete the lab---remember, once you start, you cannot pause a lab.
Note: If you already have your own personal Google Cloud account or project, do not use it for this lab to avoid extra charges to your account.

Task 1. Launch Data Studio and create a blank report

  1. Open Google Data Studio in a new browser tab or window.
Note: Make sure that you are logged in using the username and password provided in the Connection Details panel.

The Data Studio home page opens.

  1. From the homepage, click the Blank report template:

  2. Click through the following prompts:

    • Check the checkbox to acknowledge you have read and agree to the Google Data Studio Additional Terms, then click Continue.
    • On the Sign up for emails to get the most out of Google Data Studio dialog, select "No" to all options, then click Continue.
  3. Click the Blank report template again.

A new, untitled report opens.

  1. You'll be on the Connect to data tab.

  2. In the Google Connectors section, select BigQuery.

BigQuery in the Google Connectors section

  1. For Authorization, click Authorize. This allows Data Studio access to your Google Cloud project.

  2. Define your project:

    • Click on Shared projects > your Project ID, which is found in the Lab details panel (begins with qwiklabs-).
    • For Shared project name type "data-to-insights".
    • For Dataset select ecommerce.
    • For Table select sales_report.
  3. Click Add in the bottom right corner and then click Add to report.

  4. A preview of the available fields you can add to the report opens.

  5. Under Available Fields, click on ratio, and drag it into the Dimension section.

  6. Click in the number icon to edit.

Number icon highlighted

  1. Scroll down to the Type area, and use the dropdown menu to select Numeric > Percent.

You should now see the ratio column added with values as a percentage.

  1. Delete the table that was created for you - you will now create a report with a customized table.

Click Check my progress to verify the objective. Launch Data Studio and create a blank report

Task 2. Create a report

Now add some visuals and interactive filters for your report users.

Add a report title and page title

  1. In the top-left, click "Untitled Report" and rename it "Ecommerce Product Operations Report".

  2. In the reporting tools menu bar, click on the text icon (looks like a boxed in A).

  3. Click onto a blank area in your report. In the text area, type "Product Inventory Watchlist".

  4. Highlight the text in the text area and in the Text Properties panel, increase the font size to 32px. You may need to adjust your text box so it fits correctly.

Create a data table

  1. From the menu bar, select Insert > Table. Click onto the report to drop your table. Feel free to adjust the size of this table and the width of the columns.

  2. In the new Data and Style panel that opens, specify the following in the Data tab:

    • If productSKU is not present in the Dimension section, click productSKU from the Available fields section and drag it to the Add dimension field.
    • In the Metric section, if present, remove Record count as a Metric by clicking x.
    • Add stockLevel to the Metric area.

    Metric section

    • Drag ratio to add it as a new Metric
    • Drag restockingLeadTime to add it as a new Metric
    • In the Sort field, click on productSKU and choose ratio from the dropdown menu for the new Sort field.
    • Specify Descending.
  3. At the top of the panel, click the Style tab.

  4. Under Table header, check Wrap text.

  5. Manually adjust the widths of the table columns by hovering over the vertical border and click and dragging.

  6. Confirm your report looks visually similar to the report below:

Product Inventory Watchlist table with the following column headers: productSKU, stockLevel, ratio, and restockingLeadTime

Create an interactive filter

  1. Click on your data table.
  2. Under Available Fields, click on name, and drag it into the Dimension section above productSKU.
  3. Similarly, drag total_ordered into the metric section below restockingLeadTime.
  4. In the upper-right, select the View button to preview your report. You should be presented with the following:

Product Inventory Watchlist table with the following column headers: name, productSKU, stockLevel, ratio, restockingLeadTime, and total_ordered

Congratulations!

You've successfully created a basic report in Google Data Studio. Continue exploring new chart types and connect to additional data sources for richer, more visual reporting.

Finish your quest

This self-paced lab is part of the BigQuery for Marketing Analysts and Insights from Data with BigQuery quests. A quest is a series of related labs that form a learning path. Completing a quest earns you a badge to recognize your achievement. You can make your badge or badges public and link to them in your online resume or social media account. Enroll in any quest that contains this lab and get immediate completion credit. Refer to the Google Cloud Skills Boost catalog for all available quests.

Looking for a hands-on challenge lab to demonstrate your BigQuery skills and validate your knowledge? On completing this quest, finish this additional challenge lab to receive an exclusive Google Cloud digital badge.

Next steps/ Learn more

Learn more about What you can do with Data Studio.

Google Cloud training and certification

...helps you make the most of Google Cloud technologies. Our classes include technical skills and best practices to help you get up to speed quickly and continue your learning journey. We offer fundamental to advanced level training, with on-demand, live, and virtual options to suit your busy schedule. Certifications help you validate and prove your skill and expertise in Google Cloud technologies.

Manual Last Updated: August 15, 2022

Lab Last Tested: July 16, 2021

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.