GSP409

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 row 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 do

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 Qwiklabs 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.

What you need

To complete this lab, you need:

• Access to a standard internet browser (Chrome browser recommended).
• Time to complete the lab.

Note: If you already have your own personal Google Cloud account or project, do not use it for this lab.

Note: If you are using a Pixelbook, open an Incognito window to run this lab.

Launch Data Studio and create a blank report

1. Open Google Data Studio in a new browser tab or window.

The Data Studio home page opens.

2. From the homepage, click the Blank Report template:

3. 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.

4. Click the Blank Report template again.

A new, untitled report opens.

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

6. In the Google Connectors section, select BigQuery.

7. For Authorization, click Authorize. This allows Data Studio access to your Google Cloud project.
8. Define your project:

• Click on Shared Projects > your Project ID, which is found in the Connection Details panel (begins with qwiklabs-).
• For Shared project name type "data-to-insights".
• For Dataset select ecommerce.
• For Table select sales_report.

9. Click Add in the bottom right corner and then click Add to Report.
10. A preview of the available fields you can add to the report opens.
11. Under Available Fields, click on ratio, and drag it into the Dimension section.
12. Click in the number icon to edit.

13. 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.

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

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.

• 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:

Create an interactive filter

1. In the reporting tools tray, click the Filter [ ] icon.
2. Above your data table, click and drag to create a filter.
3. In the data panel that opens, specify name as the Dimension and total_ordered as the Metric.
4. In the upper-right, select the View button to preview your report. You should be presented with the following:

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 Qwiklabs Quests BigQuery for Marketing Analysts and Insights from Data with BigQuery. 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 a Quest and get immediate completion credit if you've taken this lab. See other available Qwiklabs 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.

Manual Last Updated: February 26, 2021

Lab Last Tested: February 26, 2021

Copyright 2021 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.