# Looker Studio: Qwik Start - GSP136

## **Overview**

[Looker Studio](https://lookerstudio.google.com/c/navigation/reporting) is a free, modern business intelligence product that lets you create dynamic, visually compelling reports and dashboards. With Looker Studio, you can:

* Easily connect to a variety of data sources.
    
* Visualize your data through attractive, dynamic, and interactive reports and dashboards.
    
* Share and collaborate with others, just as you can in Google Drive.
    

Looker Studio automatically saves every change you make, so there's no need to click Save when editing a report.

In this lab you will create a report by pulling in a public dataset from BigQuery. You will then add a chart and style to your report, which will make your data elegant and easy to understand.

## **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 are made available to you.

This hands-on lab lets you do the lab activities in a real cloud environment, not in a simulation or demo environment. It does so by giving you new, temporary credentials 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 (recommended) or private browser window to run this lab. This prevents 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:** Use only the student account for this lab. If you use a different Google Cloud account, you may incur charges to that account.

### How to start your lab and sign in to the Google Cloud console

1. Click the **Start Lab** button. If you need to pay for the lab, a dialog opens for you to select your payment method. On the left is the Lab Details pane with the following:
    
    * The Open Google Cloud console button
        
    * Time remaining
        
    * The temporary credentials that you must use for this lab
        
    * Other information, if needed, to step through this lab
        
2. Click **Open Google Cloud console** (or right-click and select **Open Link in Incognito Window** if you are running the Chrome browser).
    
    The lab spins up resources, and then opens another tab that shows the Sign in page.
    
    ***Tip:*** Arrange the tabs in separate windows, side-by-side.
    
    **Note:** If you see the **Choose an account** dialog, click **Use Another Account**.
    
3. If necessary, copy the **Username** below and paste it into the **Sign in** dialog.
    
    ```javascript
    student-04-cde312389451@qwiklabs.net
    ```
    
    Copied!content\_copy
    
    You can also find the Username in the Lab Details pane.
    
4. Click **Next**.
    
5. Copy the **Password** below and paste it into the **Welcome** dialog.
    
    ```javascript
    XHME2foNQk4S
    ```
    
    Copied!content\_copy
    
    You can also find the Password in the Lab Details pane.
    
6. Click **Next**.
    
    **Important:** You must use the credentials the lab provides you. Do not use your Google Cloud account credentials.
    
    **Note:** Using your own Google Cloud account for this lab may incur extra charges.
    
7. Click through the subsequent pages:
    
    * Accept the terms and conditions.
        
    * Do not add recovery options or two-factor authentication (because this is a temporary account).
        
    * Do not sign up for free trials.
        

After a few moments, the Google Cloud console opens in this tab.

**Note:** To access Google Cloud products and services, click the **Navigation menu** or type the service or product name in the **Search** field.

![Navigation menu icon and Search field](https://cdn.qwiklabs.com/9Fk8NYFp3quE9mF%2FilWF6%2FlXY9OUBi3UWtb2Ne4uXNU%3D align="left")

### Looker Studio setup

* Once you've logged in to the Google Cloud console, open [lookerstudio.google.com](http://lookerstudio.google.com/) in a new tab.
    

You should be automatically logged in with your lab's username, but if not, log out and sign in with the lab credentials you were given.

## **Task 1. Create a new blank report**

You are already on the reports home page.

1. Click the **Plus Button** to create a new report.
    
2. In the Account Setup screen, enter **Country** and **Company** name.
    
3. Accept the Looker Studio Terms of Service and click **Continue**.
    
4. Select **No** for receiving **Tips and recommendations**, **Product announcements** and **Market research**.
    
5. Click **Continue**.
    
6. Now click on the **Blank Report plus button** again.
    
7. Click **X** to close the **Add data to report** window.
    

Now you are in the Report Editor, which gives you the controls and tools needed to add charts, data, and style to your report.

7. Click **Untitled Report** in the top left corner of your screen and name your report "Analytics Test".
    

You are now ready to add data to your report.

## **Task 2. Create a new connection and data source**

There is a list of [Google connectors](https://support.google.com/lookerstudio/answer/7530149), which are the "pipes" that allow a Looker Studio data source to access the information stored in your data sets.

1. From the toolbar, select **Add data**.
    
2. From the list of **Google Connectors**, select the **BigQuery** tile.
    
3. Then click on the **Authorize** button to let Looker Studio view your data in BigQuery.
    
4. From the left menu, click **Public Datasets > Your Project ID > san\_francisco > bikeshare\_trips**.
    
5. Then click **Add** in the bottom right corner.
    
6. You will then be prompted with "You are about to add a data source to this report", click **Add to report**.
    

You have successfully connected Looker Studio to a public dataset hosted in BigQuery. Now you are ready to build a chart from the San Francisco bikeshare trip dataset.

### Test Completed Task

Click **Check my progress** to verify your performed task. If you have successfully created a new connection and data source with BigQuery, you will see an assessment score.

Create a new connection and data source

Check my progress

## **Task 3. Add a times series chart**

Build a time series graph from your dataset.

1. From the toolbar, select **Add a chart**.
    
2. Then click **Time series chart** from the dropdown menu.
    
3. Adjust the positioning of the chart by selecting and dragging it; or by selecting the chart and using your keyboard arrow keys to move it. Drag the corner of the chart to expand it.
    

Your chart should resemble the following:

![Time seris chart of the number of bikeshares used in San Francisco over time](https://cdn.qwiklabs.com/fabtSfVO25TBv7cbN0hbfPVUHDbUaaW55PmH8l%2F2LdM%3D align="left")

The time series chart shows the number of bikeshares used in San Francisco over time (it doesn't look like this transportation method is too popular in the winter time.)

## **Task 4. Style the report**

1. In Looker Studio, click anywhere on the graph paper, but not on the chart you just made.
    
2. Click **Theme and layout** from the toolbar and stay on the **Theme** tab.
    
3. Click **Customize**.
    
4. Scroll down to the **Component background and border** section and click on the paint bucket.
    
5. Choose a background color for your chart from the color pallet. Here's one example:
    

![Time seris chart of the number of bikeshares used in San Francisco over time](https://cdn.qwiklabs.com/pksedmRI3DBiS7dPhWnSoiRBjfi%2BWKF%2BN3N19jol8kg%3D align="left")

## **Task 5. Add a banner to your report**

1. Select the **Shape icon > Rectangle** tool from the top toolbar.
    
2. Draw a rectangle across the top of the page.
    
3. Click inside the newly created banner. This will open the Rectangle Properties panel.
    
4. Choose a background color for your banner. Your graph will now resemble the following:
    

![Time series chart of the number of bikeshares used in San Francisco over time with a banner above the chart](https://cdn.qwiklabs.com/AEOnUil98hnzCzWgPNKZapnjLT7LCLmuyKruaoFpR%2BU%3D align="left")

## **Task 6. Add a title to your report**

1. Select the **Text** tool from the top toolbar and draw a textbox inside the banner.
    

![datastudio text option highlighted](https://cdn.qwiklabs.com/dUPi7kwS0DGHQytBJNaJU09%2FlZURR%2F2%2BaL3ouX8Tn04%3D align="left")

2. Make sure the background of the text is transparent.
    
3. Type "Google Analytics Demo Dashboard" in the textbox.
    
4. Resize your textbox to fit the rectangle, and change the font color and size to something that looks nice to you.
    

![Time series chart of the number of bikeshares used in San Francisco over time titled Google Analytics Demo Dashboard](https://cdn.qwiklabs.com/uZLeFxCr%2F2FIEzVolpRNvO8Yp8CEUd59%2B3WaeK%2FsWcU%3D align="left")

Nice looking report!

---

## Solution of Lab

%[https://www.youtube.com/watch?v=G9jNga-up70&ab_channel=QuickLab%E2%98%81%EF%B8%8F] 

Open: [http://lookerstudio.google.com/](http://lookerstudio.google.com/)

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1752481230671/468928f8-4454-4ee7-8f9b-6bd21f14398f.png align="center")

From the left menu, click **Public Datasets > Your Project ID > san\_francisco > bikeshare\_trips**.
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1752481345670/8b62abb1-b4b5-4bc9-acf9-a4a385f0717f.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1752481399716/96dab5aa-01ad-439d-89d7-21434bc02752.png align="center")