Google Data Studio Tutorial

Table of contents

Google Data Studio integrates with various data platforms to create more visually appealing, easy-to-use dashboards that clearly represent your goals. These dashboards are more visually appealing than those created in Analytics, and you may include additional widgets as well.

Data Studio is one of the numerous Google Marketing Platform products that allows marketers to generate complete visual reports and dashboards based on their data.

We use Google platforms for a variety of projects, such as tracking SEO with Analytics and developing paid search ads with Ads.

Google Data Studio's Advantages

Data Studio's main advantage is that it is incredibly user-friendly. While it may not be as powerful as some other products on the market, it is simple to understand, and Google provides numerous tutorials to assist you in creating thorough reports.

As previously said, it supports more metrics than Analytics, which is significant if you have more to say than the few widgets available on the Analytics dashboard.

You can do calculated metrics and dimensions in the same way that you can in a spreadsheet. For instance, if you want to examine the overall conversions across all of your campaigns, you may use Data Studio to develop a formula.

Blended data is the another significant advantage of Google Data Studio. Your charts will only be drawn from a single data source by default. A blended data source, on the other hand, allows you to construct charts from multiple data sources. For example, if you needed conversions from campaigns other than Google Ads, you could construct a blended data source and include Facebook conversions as well.

In addition to these, Google Data Studio dashboards have these advantages as well;

  • Interactive
  • Completely customized
  • Pre-built templates are included.
  • Free of charge (except 3rd part connectors)
  • Cloud-based, easy to share

Editor

When you have nothing selected in the main grid, it lets you edit the theme and layout of the page. When you’ve selected a chart, the right bar is where you’ll play with the data, including adding dimensions and metrics

Theme Tab

Data Studio offers a number of predefined themes for your report. You can create a professional look quickly by selecting an existing theme.

Layout Tab

You can do things such as control how your report looks 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.

When any element/chart is selected, then this sidebar becomes the editor for that specific chart. Again we will have 2 tabs.

Google Data Studio vs. Tableau: What’s Better for You?
Business intelligence tools became a necessity for most businesses, from small to mid size and bigger corporations. There are certain players in the field, Google Data Studio and Tableau are the most popular ones. Almost all people who start thinking to order a new dashboard or investing in a busin…
Pros and Cons of Google Data Studio 2021
What is Google Data Studio?Google Data Studio is Google’s dashboard platform which offers data visualization and informative reporting tools. It has been in our lives since 2015 and it is completely free. Many data sources can be connected to the Google Data Studio and through the platform’s
Google Data Studio Introduction
What is data visualization?Data visualization, is interpretation of raw data with visual elements such as charts, scorecards, pie charts and many more. As the raw data which we are exposed to, has been growing enormously every year, the need for a better communication medium has become a must. But
How to Create a Google Data Studio Account
Google Data Studio is one of the tools within Google Cloud Platform. As long as you have a Google account, it will be easy and swift to create a Google Data Studio Account and start working. StepsNavigate to http://datastudio.google.com/Click on “Use it for free”, a new
How to connect a data source to Google Data Studio
What is a data source?There are 2 types of data sources and they are connected by “connectors”. A connector is a mechanism by which Data Studio accesses a specific data platform, system, or product. Google Connectors (aka. free connectors)Partner Connectors (aka. community connectors)There are free…
A First Look at the Google Data Studio
In this tutorial, we will have a first look at the main report building elements. ToolbarOn the top of the page is a toolbar, and on the right upper corner is a share button and a “View” button. By default, you are in “Edit” mode. Add a page: You can
How to add a page to Google Data Studio?
One of the brilliant functions of Google Data Studio is to be able to create several pages. You can consider different data sources for each page or sometimes you might want to break down elements in less number of chart to increase readablity. How to add a new page?Click
How to share reports in Google Data Studio
Sharing is probably one of the most useful functions of Google Data Studio. For many years, we shared a copy of a spreadsheet or slide presentation, they didn’t have any sync function or collaboration whatsoever. Google Data Studio, works on Google Cloud Platform. Users can login with their Google a…
How to colour your reports? Formatting and Themes
We all used spreadsheets once in our lives. Most of us use them still. Sure, they are very efficient and right to the point. But aren’t they boring? A little colour and a touch of art might create wonders. And by wonders, we mean easier to read and appealing dashboards!
Dimensions vs Metrics: Using Them in Google Data Studio
What are Dimensions and Metrics?Dimension and metrics are 2 main data source types or field types. All data sources have these 2 main types of data fields. | Dimensions and metrics are fundemental units of all data sources. You’ll encounter into metrics and dimensions whether you’re using Google D…

Chart Types

Google Data Studio is a practical tool that provides you with professional features beyond the Google Analytics dashboard. This reporting solution allows for transforming data into appealing reports suitable for your audience.

How to use Google Maps in Google Data Studio
Geographic (or just “Geo”) charts and Google Maps allow you to represent your metrics on a map. Geo Maps were the first - for a long time they were the only - kind of visualisations in Data Studio. Since August 2020, Google Maps became available. Google Maps charts differ in
Google Data Studio Time Series & Area Charts
A time-series graph (times series chart) is a data visualization tool that illustrates values at successive intervals of time. Each data point on the graph corresponds to both a time and a quantity that is being measured. Area Charts are variations of time series charts. What are time series charts?
How to create a pie chart in Google Data Studio
Pie charts present numerical information in a circular form, with sections of the circle representing the range of data series. Pie charts are useful for displaying a small number of data points with large variations in proportion, making them great for visualizing proportions of qualitative and num…
Creating and Customizing Scorecard KPI in Google Data Studio
A scorecard is a way to track a single metric that measures the relative health or performance of your business or area of activity. For example, a scorecard tracks total sales, average bounce rate, count of ad impressions, maximum hold time, minimum failure rate and more. Scorecards in Data Studio
How to set up a bar chart on Google Data Studio
A bar chart uses horizontal or vertical bars to show comparisons among categories. The longer the bar, the greater the value it represents. One axis of the chart shows the specific categories being compared, and the other axis represents a discrete value. Here are 2 bar charts from the Google
Google Data Studio Scatterplot & Bubble Charts
Scatterplot & Bubble charts are for comparing variable according to relationships between them. Charts might have points or circles. Charts have X and Y axis. Scatter charts in help see the relationship between 2 metrics for up to 3 dimensions. For example, a scatter chart can show if there’s a
Google Data Studio Line and Combo Charts
Line charts and combo charts are very useful when you want to observe data changes, fluctuations over certain periods of time. These charts can use lines, bars or sometimes both (combo charts). Usually, date/time is used as an X-Axis dimension but it is not mandatory. Line charts can plot
Create Bullet Chart in Google Data Studio
Bullet charts show a single metric. They help you to see how good is selected metric is performing and they do it in a simple, easy to ready way. A centre bar showing the actual value of the metric you are graphingA vertical line showing a target valueColoured bands that
Creating TreeMap Chart in Google Data Studio
In computing and information visualization, treemaps are a way of displaying hierarchical data with nested rectangles. Each branch of the tree is given a rectangle, which is then tiled with smaller rectangles representing sub-branches. Data in a treemap is displayed in “branches” (also called “nodes…
Google Data Studio Table Chart
Tables display your data in a grid of rows and columns. Each column represents a dimension or metric, while each row is one record of your data. Tables are staple charts of Google Data Studio. They might not look appealing or attractive compared to other charts. But they will show
Google Data Studio Pivot Tables
This pivot table of grouped values shows the sums, averages, or other statistics of all the individual items in a more extensive table. Pivot tables can be created by using pivot charts to rearrange information. Pivot tables, take the rows in a standard table and pivot them so they become

Advanced Topic

Data Studio has gone from being a buggy interface to Google Analytics dashboards to becoming a BI tool that competes with the Power BI and Tableau – but like any Google product, knowing a few hacks and tricks means it is far more powerful than it first appears.

Working with Google Data Studio Filters
Filters refine or reduce the data in your reports. By this, you can focus on the data that is most relevant to your needs. 💡 You can apply a filter to a chart, control, page, or the entire report using the DATA properties tab. There are 2 types of filters: Include
How to use Reference Lines in Google Data Studio
Usually marketers want to know how their campaigns are performing over a time period. They would like to be able to group data by specific date ranges if they use the date range filters. This angle give them changes in KPIs over time and let them make calculated decisions. How
Using Community Visualizations in Google Data Studio
Data Studio community visualizations allow anyone to build, use, and share custom visualizations in Google Data Studio. So they are charts created by third-party developers that work with your data and can be configured just like Data Studio’s default charts. These elements are essentially graphs, t…
How to Create CASE Statements in Google Data Studio
Case statements are conditional expressions used in calculated fields. They define one or more conditions and returns a result when a condition is met. You can define a default result if none of the conditions is met. Case statements are most often used to create new categories or groupings of
How to Blend Data in Google Data Studio
Data Blending is one of the marvels of Google Data Studio. This function helps you join information from multiple sources and gives you a unified view. By default, charts in Data Studio get their information from a single data source. Blending lets you create charts based on multiple data sources,
How to work with date in Data Studio?
You can use functions in calculated fields to create new columns of date and time data in your data source or directly in components on the report. Where to use them?For example, you can construct a complete date from separate numeric day, month, and year fields using the DATE
How to use parameters in Google Data Studio?
We mentioned dimensions and metrics here. They are the main segments of data that we use on charts and reports. But they are bringing values from the data sources. What are you want to input a unique or custom variable which is not in the data source but relevant to

Spread the word