Get help

Help center

Guides and answers

Contact support

Write to our team

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Finance

Turn manual finance work into reports that update themselves.

What Finance teams automate

  • Track payables and receivables
  • Build cash flow statements
  • Compare budget against actuals

Inventory and manufacturing

See stock levels and automate ordering.

What inventory and manufacturing teams automate

  • Track inventory across multiple sites
  • Connect sales, purchasing, and warehouse data
  • Link a barcode scanner to your sheet

HR

Run recruitment, attendance, and OKR tracking from your sheets.

What HR teams automate

  • Track recruitment and onboarding
  • Record team OKRs and results
  • Track check-ins, check-outs, and leave

Project management

Assign tasks and track hours without manual updates.

What project teams automate

  • Assign tasks and track status changes
  • Estimate effort and log hours worked
  • Track milestones across projects

Sales and CRM

Track leads and sales performance with automated reports.

What sales teams automate

  • Track and convert leads
  • Set sales goals and track team metrics
  • Monitor sales KPIs on dashboards

Education

Automate attendance, grades, and school purchasing.

What schools automate

  • Track attendance and notify parents
  • Record and compare class grades
  • Track inventory lent to students and staff

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Get started

Templates

Ready-made workflows to start from

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Help center

Guides and answers

Contact support

Write to our team

Workflows

Build processes with your team

Automations

Connect files and automate tasks

Google Data Studio tutorial for beginners

Google offers a variety of free and user-friendly tools for data collection, transformation, and analysis. Google Data Studio (now called Looker Studio) is a great complement to Google Sheets since its wide range of features will help you create professional reports for your clients, colleagues, or managers.

This tutorial for beginners will explain what Google’s Data Studio is and the main benefits of using it; you’ll then learn how to navigate and add to the dashboard, how to import your own data to create a report, and finally, how to share your report with others. Google renamed Data Studio to Looker Studio in 2022, so the screenshots in this guide show the older Data Studio interface.

What is Google Data Studio?

Google Data Studio is an online service for data visualization and reporting. Although it can be applied to a great variety of business domains, it has gained more traction among marketers and data analysts. Below, we answer some of the most common questions related to this service:

  • Is Google Data Studio free to use? Like most of Google’s online tools, Data Studio is free to use. Google also sells a paid Looker Studio Pro plan with extra team management features, but you don’t need it to follow this tutorial.
  • Is Google Data Studio easy? Like the majority of tools provided by Google, it is user-friendly and can easily be used as an alternative to more complex forms of interactive reporting, such as Tableau and Power BI.
  • What are the benefits of using Google Data Studio? In addition to being completely free and intuitive, it allows you to import data from a wide range of sources, including Google Ads, Google Analytics, Google Sheets, YouTube Analytics, and BigQuery.
  • What can Google Data Studio do? As a data visualization and reporting tool, it allows you to transform data into charts, tables, or diagrams. More importantly, it is great for synchronous collaboration and real-time monitoring.

As mentioned, Google Data Studio is a free service for data visualization, so you will ‌unlock its full potential from the very beginning, from sharing reports to accessing any of the Google Data Studio templates. Let’s see how you can use Google Data Studio in a few simple steps.

How to use Google Data Studio?

Google Data Studio is a cloud-based tool, so you only need to sign in using your Google account. If you don’t already have one, remember that you can easily create one for free. Let’s see how to start using Google Data Studio.

1. Sign in to your Google account.

2. Go to lookerstudio.google.com (the old datastudio.google.com address redirects there)

Before creating your first Google Data Studio dashboard, let’s describe the key features shown below.

Google Data Studio tutorial — Data Studio home with the Create button, left-side menu, Start with a Template row, and an empty report list
  • The left-side menu allows you to create a report, data source, or explorer.
  • The toolbar menu allows direct access to all reports, data sources, or created charts without having to edit the report itself.
  • The top Search Data Studio bar lets you perform a quick search on reports by name.
  • The Template Gallery offers templates from 8 different categories, including Google Sheets or Google Ads data sources.
  • The report area is below the Template Gallery section, showcasing all your reports according to name, owner, or last opened.

How to create a report using Google Data Studio templates?

In this tutorial for beginners, we recommend trying out the main features of Google Data Studio by using their pre-built templates. As mentioned before, these templates are based on 8 different data source categories. Here, you’ll learn how to use a Google Sheet data source template.

1. Go to “Templates”, on the left-side menu.

Google Data Studio tutorial — Template Gallery with the Category drop-down and Google Analytics and BigQuery templates

2. Click on the drop-down “Category” menu to select your preferred data source. Here, I will select “Google Sheets”.

Google Data Studio tutorial — Category drop-down listing Google Analytics, Search Console, Google Ads, YouTube Analytics, Google Sheets, and BigQuery

3. Google Data Studio offers two different templates based on Google Sheets. Simply double-click to access your preferred template. Here, we’ll select the “World Population Data” report, which already contains pre-existing data by Google.

Google Data Studio tutorial — Google Sheets templates World Population Data and Olympics TV Ad Performance

4. Click on “USE TEMPLATE” in the top-right corner to add to your Google Data Studio dashboard and start working.

Google Data Studio tutorial — World Population, Internet, & Mobile Data report with the USE TEMPLATE button at the top right

5. Click on “Copy Report” if you wish to add your “New Data Source” to the report. This simply means that you have the possibility to use the template as it is or merge your new data into it. Since I do not have any data in Google Sheets yet, I can ‌copy this report template.

Google Data Studio tutorial — Copy this report dialog with the original and new data source and the Copy Report button

You always have the option of editing it later on, following the guided tour available within the template.

Google Data Studio tutorial — copied population report with the More ways to blend your data tour pop-up and Blend Data panel

Now that we’ve seen how easy it is to create a report using one of the Google Data Studio templates, let’s explore the basics of creating a report by connecting to one of your data sources.

How to create a report connecting to a data source?

Before creating a report based on charts and other visual elements, you need to connect to a data source to display data. This is how you can connect to a data source.

1. Click on “Create” to the left-side menu and select “Report”.

Google Data Studio tutorial — Create menu open with Report, Data source, and Explorer options

2. It will prompt you to enter basic information regarding your geographic location and company name. Here, I’ll select “United States” from the drop-down list and type your company name. Once you finish, click “Continue”.

Google Data Studio tutorial — account setup step 1 of 2 with Country set to United States, a Company field, and the terms checkbox

3. Finish your account setup.

Google Data Studio tutorial — account setup step 2 of 2 with email preference questions and Yes or No options

4. You can connect to up to 22 different data sources supported by Data Studio. Here, I’ll select “Google Sheets”.

Google Data Studio tutorial — Add data to report panel listing 22 Google connectors, including Google Sheets and BigQuery

5. To access your Google Sheets data, you will need to click on “Authorize”.

Google Data Studio tutorial — Google Sheets connector asking for authorization with the AUTHORIZE button

6. Your data should appear. Use the various Data Studio tools to edit your data to create a user-friendly, interactive report.

Google Data Studio tutorial — table chart of Google Sheets data with first name, last name, product, and record count, plus the chart Data panel

How to share a report in Google Data Studio?

If you know how to share a Google Doc or Sheet, then you will find that sharing a report in Google Data Studio is very similar. Let’s try sharing the “World Population Data” template.

1. Open the template and click on “Share” to the far-right. As you can see below, you have 5 different sharing options: “Invite people”, “Schedule email delivery”, “Get report link”, “Embed report”, or “Download report”.

Google Data Studio tutorial — Share menu with Invite people, Schedule email delivery, Get report link, Embed report, and Download report

If you choose to “Invite people”, Google Data Studio allows you to control viewing and editing rights on various levels.

2. In the “Add people” tab, you can decide whether the recipient users “Can edit” or “Can view”, in addition to notifying them via email, so they immediately know a report has been shared with them.

Google Data Studio tutorial — Sharing with others dialog on the Add people tab with Can edit and Can view options and Notify people checked

3. For more advanced access rights, click on “Manage access”, next to the “Add people” tab. Then, click on the drop-down menu “Off – only specific people can access” to see the full range of access types.

Google Data Studio tutorial — Manage access tab with the link sharing drop-down set to Off, only specific people can access

4. For more security or privacy, you can tick on both boxes below to “Prevent editors from changing access and adding new people” and “Disable downloading, printing, and copying for viewers”.

Google Data Studio tutorial — Manage access tab with both boxes checked to prevent editors changing access and disable downloading for viewers

Google Data Studio allows you to adjust the security and protection levels for your data, which makes it an all-around collaborative tool for online data analysis and visualization.

Conclusion

As you can see, Google’s Data Studio is a fantastic tool that you can use for free in order to level up your reporting by connecting to all types of data sources and creating in-depth, interactive insights that you can easily share with others.

In this tutorial for beginners, we have given you a basic overview of Google Data Studio by explaining what it is, its main benefits, and how to use it. For a more advanced overview of this tool, take a look at the Looker Studio help center. If your data starts in Excel, read how to connect Excel to Google Looker Studio.

A report is only as current as the spreadsheets behind it. Sheetgo’s AI automations connect your Google Sheets and Excel files in an automated pipeline, so your Looker Studio reports read clean, up-to-date data.

Looking for more spreadsheet-related resources for beginners? Check out some of our other articles:

You may also like…

google sheets features and formulas

Top 5 dynamic array formulas in Google Sheets 

Google Sheets has evolved beyond basic spreadsheets. With the introduction of dynamic array formulas, users can now manipulate and analyze...
google sheets features and formulas

Mastering the FILTER Formula: 4 Use Cases with Examples

The FILTER formula in Google Sheets is a versatile tool for extracting data that meets specific conditions. Unlike the QUERY formula,...
google sheets features and formulas

Unlocking the Power of SUMIF and SUMIFS in Google Sheets: 4 real-life use cases

The SUMIF and SUMIFS formulas in Google Sheets are indispensable tools for performing conditional summations. They simplify complex...