Google Data Studio is a powerful data visualization and reporting tool that allows you to create beautiful dashboards with just a few clicks. The best part? It’s very easy to use! But learning it can be challenging if you’re just starting out. That’s why we created this Google Data Studio tutorial for you.
This article will take you through some of the basics of Google Data Studio – how to create a dashboard in no time, how to share your report, and more. Let’s get started, shall we? 😉
What is Google Data Studio?
Data Studio is a relative newcomer in the world of data visualization and reporting tools. It was created by Google in 2016. And it has been gaining a lot of traction ever since, especially among marketers and data analysts.
Data Studio is completely free. There’s no paid version of it. You can use it as an alternative to paid reporting tools such as Tableau and Power BI.
Check out the comparison of Tableau vs. Google Data Studio.
No upfront investment is required. You can learn and access all of its features for free. You can even use it for business purposes as well, without paying a dime!
While you won’t get super-advanced features, that shouldn’t stop you from creating professional dashboards. Plus, it’s very easy to share your dashboards and collaborate with others.
There are many pre-built templates in Data Studio, allowing you to create beautiful dashboards full of charts quickly and easily.
Data Studio is cloud-based. It’s accessible as long as you have a browser and internet connection. The reports you create are saved automatically into Google Drive, so they’re available anytime and anywhere. No worries about losing the files.
With Data Studio, you can connect, analyze, and present data from different sources. You don’t even need to be tech-savvy or know programming languages to get started with Data Studio!
How to use Google Data Studio
To start using Google Data Studio, you’ll need to sign in with your Google account (you can create it for free if you don’t already have one).
After successfully signing in, head on over to https://datastudio.google.com. You’ll see the following home screen, which is your launchpad into the world of Data Studio:
Before creating your first dashboard, let’s get familiar with Data Studio’s interface. The home page has these key parts:
1 – The left menu gives you a quick way to:
- Create a new report, data source, or explorer.
A report is where you put charts and other elements for visualization. You’ll need a data source to display data in your report. Explorer allows you to use Data Studio functionality without creating a full report, but it’s still beta and won’t be discussed further in this article.
- Access reports that were created by others and shared with you.
- Access reports that you created or copied from others.
- View the trash for any reports you have deleted.
2 – The toolbar menu, which lets you:
- Access all of your reports.
- See all the data sources you created.
- Explore or tweak a chart without modifying the report itself.
3 – The search bar at the top is a convenient tool that lets you search reports by name.
4 – The Template Gallery gives you a quick way to get started with a new dashboard. You can either use a blank report or a pre-made template that the Data Studio team created. To see more templates, click “Template Gallery” in the top-right corner of the area.
5 – The report list is just below the Template Gallery area. Here, you can sort your reports based on name, owner, or last opened.
Google Data Studio: Data sources and connectors
Every time you want to create a report, first, you’ll need to create a data source. It’s important to note that data sources are not your original data. To clarify and avoid confusion, see the explanation below:
- The original data, such as data in a Google spreadsheet, MySQL database, LinkedIn, YouTube, or data stored in other platforms and services, is called a dataset.
- To link a report to the dataset, you need a data connector to create a data source.
- The data source maintains the information of the connection credential. And it keeps track of all the fields that are part of that connection.
- You can have multiple data sources connected to a dataset, and this may come in handy when collaborating with different team members. For example, you may want to share data sources with different connection capabilities for different team members.
When Data Studio was first released, there were only six Google-based data sources you could connect to. But a lot has changed since then!
As of this writing, there are 400+ connectors to access your data from 800+ datasets. Besides Google Connectors, there are also Partner Connectors (third-party connectors).
You can see the full list of available connectors here.
Read our guide on how to connect BigQuery to Data Studio.
You’ll be able to get data from non-Google services such as LinkedIn, PayPal, Facebook, Twitter, HubSpot, etc., with third-party connectors. But most of them are not free.
Google Data Studio: Metrics and dimensions
In Google Data Studio, you’ll need metrics and dimensions to create a meaningful dashboard. Your dataset must have at least one metric and dimension for your visualization to be insightful.
So, what are metrics and dimensions in Data Studio?
Metrics are numeric values that measure or count. These values come from implicitly or explicitly applying an aggregation function, such as COUNT(), SUM(), AVG(), etc.
Dimensions are the names, descriptions, or other characteristics of the things you are measuring or counting.
Let’s continue trying to understand what those are with an example. Suppose you want to create a dashboard about the sales of your products. You may choose the following metrics:
- Sales revenue from selling your product online
- Number of customers who purchased your products
- Maximum sales
- Minimum sales
- Average product price
There are many different ways to look at your data. And, with dimensions, you can analyze your data from different angles. See the text in bold in the following list for examples of dimensions:
- Sales revenue from selling your products online, broken down into sales per month or per order type
- Number of customers by country of origin, as well as understanding their age, gender, and type of device they use
- The name of the product with the maximum sales
- The day of the week with the minimum sales
- Average product price per product type
Still confused about what dimensions are?
Try breaking down your metrics to see if there is anything else you need to know by using phrases like “broken down by”, “per”, “for each”, etc.
Before you create a dashboard in Google Data Studio
Planning is essential to everything.
Before you create a dashboard in Google Data Studio, you should prepare your dataset and the dashboard layout. This includes deciding which metrics are important for your report or dashboard so that they can be displayed as columns, rows, or charts.
Step 1: Prepare the dataset (we’ll use Google Sheets)
In Data Studio, you can connect to a large variety of datasets. But in this tutorial, we will be using Google Sheets. Why?
We’re big fans of Google Sheets. Apart from being simple and easy to use even for beginners, here are a few other reasons:
- If you have access to a Google account, you have access to Google Sheets.
- Google Sheets files are stored on your Google Drive. This makes them accessible from your standard account. Also, you get all of the sharing and security options as standard.
- With Google Sheets, you can read various file types, including CSV files and Microsoft Excel spreadsheets.
- Google Sheets can easily be connected to other Google services.
- It’s also possible to import and combine data from multiple external services into Google Sheets. This way, you can prepare and organize your data in one place before using it in Data Studio.
For this tutorial, we have already prepared a spreadsheet file containing online sales data as the dataset. Thus, you don’t need to spend time preparing your own.
To follow along with our example later, please make a copy of the following file by clicking on File > Make a copy and save it to your Google Drive.
File: FLW Online Sales
Step 2: Prepare the dashboard layout
Take some time to design the layout of your report before you start building it. Your design doesn’t need to be detailed. But at least, decide what information you’re going to present and what charts you’re going to use to visualize it. A rough sketch using a pen and paper is better than nothing. That will help you avoid staring at a blank report for too long.
It’s a good idea to ask potential viewers what information they want to see, too. And please keep in mind that the dashboard should provide them with easy-to-digest information about primary metrics so they can tell whether there are issues that require attention. Think about the dashboard in your car. It lets you quickly check things, such as the car speed, fuel level, and engine temperature, as well as reminding you to refuel your car.
Tip: Use Coupler.io to get API data and other sources into Google Sheets before visualizing it in Data Studio
You may need to use data from multiple sources when creating a dashboard, such as accessing JSON-formatted data shared via APIs. You can be use BigQuery and CSV files as well.
Pulling all of these sources of data together into a Google spreadsheet before visualizing it in Data Studio allows you to see your raw data and how it is organized. With the help of Coupler.io, you can ensure your data from different sources are sorted and ready to be analyzed.
Coupler.io connects Google Sheets with other apps through a user-friendly interface and powerful API-driven connectors. It has some great features, including:
- JSON Client Importer, which allows you to connect to other services, such as Typeform, HelpScout to Google Sheets, Salesforce, and more, as long as they have a RESTful API available.
- Seamless integration with many popular sources, such as Shopify, BigQuery, Trello, PipeDrive, and more.
- Automated data refresh on schedule (hourly, daily, or monthly).
Please check out the complete list of the Google Sheets integrations that Coupler.io supports.
Can’t find the one you need? Feel free to let us know by filling out this form. Our team is constantly working on new importers because we are committed to providing our customers with the best service possible.
Building a dashboard in Google Data Studio
Now that we’ve covered some basics in the previous chapters, let’s see how we can use Google Data Studio for visualizing online sales data in a dashboard.
To give you an idea about what the finished product will look like, here’s a simple dashboard we’re going to build:
We’ll build a dashboard that will help viewers understand the total sales and its trend over time. Moreover, the dashboard will show a simple indicator to determine which product categories have low or high sales.
For visualization, we’ll be using a scorecard, a line chart, and a table, with the following purposes:
- Scorecard — to display the total sales.
- Line chart — to show the monthly sales for different order types.
- Table — to show sales, broken down by product categories.
You’ll learn how to format the table using conditional formatting so you can quickly see which values are low in sales, as well as how to add calculated fields.
How to add a Google Sheets data source in Data Studio
Open the Google Data Studio home page and follow the steps below:
- Start by adding a new data source by clicking on the Create button, then select Data source from the menu.
Note: If you already have an existing report, you can also add a data source directly from it by clicking Add data in the report toolbar. We’ll cover more about the report toolbar later in this article.
- If you see a pop-up asking you to complete your Google Data Studio account setup, just follow the instructions to continue using the service.
Note: Once the setup is completed, you will see a data source list.
- On the data source list page, select Google Sheets under the Google Connectors section.
Note: If this is your first time using the Google Sheet connector, you’ll need to authorize Data Studio to connect to your Google Sheets by clicking the AUTHORIZE button.
- Select the FLW Online Sales spreadsheet file you copied before. Then, in the third column, select the Online Sales sheet (the second sheet). Give your data source a name – for example, FLW Online Sales – Google Sheets. We added “Google Sheets” at the end to identify that it uses the Google Sheets data source.
- If everything looks OK, click the CONNECT button in the top-right corner.
After you have successfully set up the connection, the fields in your data source page will look like this:
Notice that, by default:
- Data Studio creates one standard metric: Record Count. Metrics are always in blue and have a default aggregation of Auto, which can’t be changed.
- All fields from your spreadsheet are in green, which indicates that they are dimensions. But you can also treat any dimension as a metric in your charts.
- Some dimensions have default aggregations of Sum. Data Studio will create metrics on the fly based on the default aggregation specified when you use these dimensions as metrics in your charts.
You may also notice that some fields with Currency data type in Google Sheets are detected as Number in Data Studio. If you like, you can change them manually to Currency by clicking the triangle icon (⏷) next to the data type:
How to create your first blank report in Google Data Studio
You can create a report from the home page by using the Create button. But since we’re opening a data source page, let’s continue from this page.
- On the data source page, click CREATE REPORT in the top-right corner.
- Data Studio will ask if you want to add the new data source to the report. Confirm by clicking ADD TO REPORT.
- For now, let’s delete a table generated in the report. You can do that by right-clicking on the table, then selecting Delete from the menu, or by pressing the Delete button on your keyboard.
Note: Data Studio creates a random table based on the fields in your data source. We will add a table later so, for now, let’s just delete it.
- Rename your report title by clicking Untitled Report. Type a new title – for example, Online Sales – Dashboard.
The report editor tools
You may feel that the tools look quite intimidating at first glance. Don’t worry. We will briefly review the main core areas of this interface.
Please keep in mind that, in this Google Data Studio tutorial for beginners, we’ll not be using each of the functionalities mentioned below.
The top section on the right contains high-level functions for your report:
- Clicking the Share dropdown will open a menu that lets you share your report in several different ways.
- The View button is used to switch back and forth between Edit mode and View mode. In View mode, the button changes to Edit and has a pencil icon. You’ll switch back and forth between these two modes often when creating reports.
- With the kebab menu icon (the three vertical dots), you can refresh data for your report or make a copy of it.
Under the menu, you’ll find the editing toolbox. Many of the menu options are also available when you right-click on the report elements. As of this writing, the toolbar has the following functions, from left to right:
- Add a page: You can have multiple pages in your report.
- Undo and Redo: You can also use the keyboard shortcuts Ctrl+Z (undo) and Ctrl+Y (redo).
- Selection Mode: This pointer icon allows you to select a chart or other elements in your canvas. When you select an element, a configuration tab will open on the right side.
- Add data: This tool allows you to set up or add data sources for your report.
- Add a chart: It will show all the charts available to be added to your report.
- Community visualization and components: It lets you bring in third-party visualization tools and other charts.
- Add a control: This dropdown allows you to add a control, such as a dropdown list, slider, checkbox, date range, and more.
- URL Embed: It allows you to embed videos and other documents directly in your report.
- Image: It inserts an image from your computer or by URL.
- Text: It inserts a text box.
- Line: It allows you to draw simple or complex lines with arrows and curves.
- Shape: It allows you to insert basic shapes, such as rectangles and circles.
- Theme and layout: When you click on it, a panel will show up on the right side, allowing you to edit the look and feel of your report.
The theme and layout panel
There are two tabs in this configuration panel: Theme and Layout.
In the Theme tab, Data Studio offers a number of themes for your report. Let’s say you like a dark background. Try selecting the Constellation, Lagoon, or Simple Dark theme. You can save time creating a professional look instead of styling your report from scratch.
In the Layout tab, you can do things such as control how your report looks like in View mode, customize your report size and orientation, and change grid settings. We recommend experimenting with each option to see what works best for you.
After understanding the report editor and its features, you’re ready to start adding some components to your dashboard!
How to add a scorecard in Google Data Studio
A scorecard is a great start as it’s like choosing a headline. To add a scorecard that shows the total sales to your report:
- Click Add a chart icon in the toolbar, then select Scorecard.
- Drag the scorecard where you want it (ideally in the top-left corner of the report).
- It will show the default metric: Record Count. So, click the metric and change it to OrderTotal.
- Hover over the first column of the metric until you see a pencil icon. Click it to open a pop-up to edit the metric. Give your new metric a name: Total Sales. Then, click anywhere outside the pop-up to close it.
Now you will see the scorecard with the Total Sales label:
- Since the number looks too long, customize the scorecard to display a compact number by ticking the Compact number checkbox in the Style tab in the right panel.
Note: In this Style tab, you can also change other appearances of your chart, such as the background color, border color, font, and so on.
How to add a line chart in Google Data Studio
To create a line chart that shows sales over months for different order types, we have two options: a basic line chart or a time series.
Because we want to see how the data changes over time, a time series is best for this case. We can save a few steps using it rather than using a basic line chart.
Now follow the steps below to add a time series:
- Click Add a chart icon in the toolbar, then select “Time series chart“.
- Drag the time series under the scorecard and resize it as needed.
- To break down the metric into different order types, add a breakdown dimension: OrderType.
Note: You can also drag-and-drop a column from the Available Fields list.
- Hover over the OrderDate dimension, then click the pencil icon.
- Change the field’s data type to Month and name it “Month”.
Note: In this case, we’re changing a field’s data type in a chart. This won’t change the original OrderDate field in your data source. It’s a best practice to always have a full Date or Date & Time field in your data source. Then, if necessary, you can adjust its type in a chart.
- When done, close the pop-up by clicking anywhere outside it. See that the x axis of your chart now displays the month names.
How to add a table in Google Data Studio
To add a table that shows the sales per product category:
- Click Add a chart icon in the toolbar, then select Table.
- Drag ProductCategory into Dimension, replacing OrderType.
- To make the table nicer, resize the table as needed. If you like, sort the table based on ProductCategory, ascending.
How to add calculated fields with functions and formula examples in Google Data Studio
Now, what if you want to display the total price before discount? And also display the product categories in uppercase letters? It’s time to create calculated fields.
You can add a calculated field in either the data source or a chart. When you add the field in the data source, it will be available in any report that uses the data source.
How to add a calculated field in the data source
Let’s add a new field Total in the data source that multiplies a price by a quantity by following the steps below:
- Open the FLW Online Sales – Google Sheets data source.
- Click the ADD A FIELD button.
- Set the field name to Total. In the Formula box, type:
Quantity * Price
- Click Save at the bottom.
- Return to the field list by clicking ALL FIELDS.
- Change the type to Currency and change the default aggregation to Sum.
- Drag Total and Discount fields as metrics in your table. Note: If you don’t see the Total field in the Available Fields list, refresh your browser first.
How to add a calculated field in a chart
Let’s see another way to add a new calculated field. We’ll add a field Category in the chart to display product categories in uppercase letters. To do this, we’ll use a text function: UPPER.
Follow the steps below:
- Select your table, then click ProductCategory dimension on the right.
- In the small pop-up that appears, click CREATE FIELD.
- Name the new field Category and use
UPPER(ProductCategory)in the Formula box. Click the blue APPLY button when done.
- Click anywhere outside the pop-up to close it. See that your table’s dimension is now displayed in uppercase:
How to use conditional formatting to format your Google Data Studio dashboard
Now let’s format the OrderTotal cells to red for values under $1,000,000 so that you can quickly see which ones are low in sales.
Follow the steps below:
- Select your table, then click the STYLE tab on the right.
- At the top, in the Conditional formatting section, click Add.
- In the Edit rule pop-up, set the following condition and format:
- Under Color type, select Single color.
- Under Format rules, set: OrderTotal LESS THAN 1000000.
- Under Color and style, set the background color of OrderTotal to red and the font color to white.
- Click Save and close the pop-up.
To share your report, click on the Share dropdown in the header toolbar. This will give you a list of different ways to share it:
Option 1: Invite people
Use this option to invite specific people or Google Groups and add them as viewers or collaborators on your report.
In the Add people tab, enter the email addresses of those you want to share your report with. You can allow them to edit it or just view it.
If you want to share more broadly, turn on link sharing in the Manage access tab. This will let anyone view your report, even if they don’t have a Google account.
Option 2: Schedule email delivery
Use this option to send scheduled reports in PDF format. You can schedule email delivery for yourself and others by setting up an email schedule: every day, weekdays only, etc.
Option 3: Get report link
Use this option to generate a short URL for your report, which you can then share with anyone. If you want to change who is able to access the report, click Change sharing settings and adjust them accordingly.
Option 4: Embed report
Use this option if you want to add the report to an existing web page.
First, tick Enable embedding. A few options will appear, allowing you to choose Embed mode and sizing.
How do you know which Embed mode to use?
The process of embedding can vary based on what web authoring system is being used. Some work with just a URL, while others require a full code for it to be properly embedded. If you are unsure about how your site will need this information, copy both to a text file.
Option 5: Download report
Use this option to download your report as a PDF file. After that, you can distribute it via email or Slack. Additionally, you can protect the document with a password for added security.
We can’t cover everything in one article but, hopefully, you found this Google Data Studio tutorial to be a helpful starting point. There is so much more that Google Data Studio has to offer, and we don’t want you to stop here.
To dive in even deeper, we recommend checking out report gallery templates as well as reading through what people are discussing at the Data Studio Community. Finally, happy dashboarding!Back to Blog