Build Interactive Dashboards And Reports With Google Data Studio

Create powerful data visualisations within minutes from google analytics and google sheets to speed up time to insight

Last updated 2022-01-10 | 4.2

- Connect to a range of Data Sources (Google Analytics
- Google Sheets)
- Get started with a FREE Data Studio Account
- Create and customise a range of data visualisations (scorecards
- time series charts
- bar charts
- area charts
- tables)

What you'll learn

Connect to a range of Data Sources (Google Analytics

Google Sheets)

Get started with a FREE Data Studio Account

Create and customise a range of data visualisations (scorecards

time series charts

bar charts

area charts

tables)

Create re-usable report templates that follow best practice principles to share with collegues

Create advance visualisations (maps

scatter charts

bullet charts)

Add dynamic date and dimension filters to make dashboards interactive

Tell powerful stories from your data

Confidently create interactive analytical dashboards with your own Data

Complete a final assignment and receive feedback on your final dashboard

* Requirements

* A google or gmail account
* Any experience with Google Analytics
* Google Sheets or Excel will be helpful

Description

NEW LECTURE! (November 2018)

Overview of The Explorer feature in Data Studio and how it can help you to reach insights faster!

This course also now supports Captions in English to help support your learning.

The Power of Data Studio

Intuitive Design - create dashboard designs that are more intuitive than dashboards in GA & Google Sheets
Scale your insights - build shareable dashboards saved in Google Drive
Speed up time to insight - build reports and visualisations to answer questions within minutes
User friendly Templates and Layouts - will make it easier for users to interpret the data.

Data Studio is a new Data Visualisation Tool created by Google. It is part of the Google Suite including Google Docs, Google Sheets and Google Slides.

Data Studio is FREE and allows you to connect to a range of data sources.

It's an incredible tool to create powerful and interactive dashboards for you to explore your underlying data.

I look forward to showing you how powerful Data Studio is for speeding up time to insight.

Target Audience

This course is for anyone who wants to learn how to find meaning from their data and communicating insights through great dashboards.

Your role might fall into one of the following

Online Marketer
Product Analyst
Data Analyst
Product Owners/Manager
Small business Owner

Data Sources you may already use

Google Analytics, Adwords or other Google Product
Google Sheets
Excel

Data Studio has 3 Key Pillars which are;

1. Connecting to many data sources

2. Visualising data through a range of customisable reports and widgets

3. Sharing dashboards for collaboration and communicating insights.

NEW LECTURE (May 2018)

Asking the question is Data Studio the right tool for me? In this new lecture 'Why Data Studio?' I explore how you can evaluate how Data Studio fits within your existing toolset and how to evaluate Data Studio against other Business Intelligence Tools in the market.

NEW ASSIGNMENT! (April 2018)

To ensure you have even more hands-on experience there is now an Assignment at the end of the course for you to complete! You will create a dashboard from scratch and answer key questions about the data set to pass the assignment and receive feedback on your final Data Studio Report.

NEW LECTURES! (DEC 2017)

Calculated Metrics - Simple Arithmetic - Learn how to create new metrics from your existing data sets directly in Data Studio, to explore your data in new ways

NEW LECTURES! (NOV 2017)

Handling Sampling of Google Analytics Data in Data Studio

NEW LECTURES (AUG 2017)

Prepare your data in Google Sheets for Data Studio
Connecting Google Sheets to Data Studio
Connect your own Google Analytics Data to Power your reports

NEW LECTURES (SEPT 2017)

Tracking Usage of your Data Studio Reports

Who this course is for:

Anyone who wants to learn how to tell stories from data using dashboards
Improve your analytical skills and capabilities
Users of Google Analytics, Google Sheets, Excel or a Database
Data Analysts/Online Marketers/Product Owners/ Business Intelligence Analysts/Business Owners

Course content

13 sections • 53 lectures

Introduction to the Course and Data Studio 1 lectures

What you will learn and what you will gain Preview 02:58

An overview of the key topics and goals in this course and the skills you will have gained at the end of it.

Get familiar with Data Studio 8 lectures

Introduction to the Homepage Preview 03:51

EXERCISE - Create your Data Studio Account - FOR FREE! Preview 00:32

An Introduction to Data Sources Preview 02:15

EXERCISE - More about Data Sources Preview 00:35

Connecting to Google Analytics Sample Data Preview 03:32

EXERCISE - Connecting your own Google Analytics Data Preview 01:01

The Reporting Interface Preview 09:05

EXERCISE - Customising your Layout Preview 00:32

Your first Dashboard and Beyond 14 lectures

Scorecards for your KPIs and Comparisons Preview 04:58

EXERCISE - Additional Scorecard Customisations Preview 00:45

Time Series Charts for Analysing Trends Preview 05:18

EXERCISE - More Options for Time Series Charts Preview 00:39

Bar Charts for making Comparisons Preview 03:52

EXERCISE - Bar Chart Options Preview 00:33

Tables for Presenting Detail Preview 04:50

EXERCISE - Customise your Tables Preview 00:46

Add new pages to your Report Preview 02:14

Use a Pie Chart (if you really need to) to show Categorical Data Preview 05:02

EXERCISE - Pie Chart Customisation Preview 00:38

The Pie Chart Data Visualisation is great for showing additional details about your data for reference.

You have learnt to customise Tables by:

Adding in multiple metrics - you can add a maximum of 10 (though that's a lot of data for someone to understand)
Adding in comparisons with % changes - comparisons help add context to your data
Showing and Hiding Row numbers - it's helpful to show them when you're interested in Rank
Showing and hiding pagination (the ability to click through to another page of data within the table) - Pagination is useful if there is useful data past the first page of results
How to Change the number of Rows shown per page in the table
Changing the colour of the header background

Below are some things you can try out to customise your tables even further.

In the Style Tab

Wrap the text so that you can see the full descriptions of the products without the ellipsis i.e the ...
Set the decimal precision of Columns 1 and 2 to 0 decimal places
For column 2 show the absolute change rather than the % change
Set the odd-row colour to grey

That's tables for you!

Add an Area Chart to segment your data Preview 02:16

EXERCISE - 100% Stack your Area Chart Preview 00:43

How Date Comparisons Work Preview 03:05

Make your Dashboards Interactive with Filters 4 lectures

Filtering by Date Preview 03:24

EXERCISE - Date Range Filters Preview 00:51

Filtering by Dimensions Preview 03:16

EXERCISE - Dimension Filters Preview 00:33

Advance Data Visualisations 7 lectures

The Map Visualisation Preview 04:57

EXERCISE - More about Maps Preview 00:36

Exploring Data with Scatter Charts Preview 05:26

EXERCISE - Scatter Charts Preview 00:51

Bullet Charts for Showing Targets Preview 04:41

EXERCISE - Everything to know about Bullet Charts Preview 00:20

Adding Heatmaps and Bar Charts to Tables Preview 05:40

The Explorer 2 lectures

The Explorer Preview 05:59

The Explorer - Further Reading Preview 00:19

Sharing your dashboard 2 lectures

Sharing your Reports Preview 02:23

Exercise - Accessing your Dashboards in Google Drive Preview 01:10

Data Sources - Connect your Google Analytics Data 4 lectures

Data Sources - Connect your Google Analytics Data Preview 03:41

NEW INTERFACE - Data Sources Preview 00:22

Handling Sampling in Google Analytics Preview 03:17

EXERCISE - Read more about sampling in Google Analytics Preview 00:20

Data Sources - Connecting Google Sheets to Data Studio 2 lectures

Preparing Data in Google Sheets Preview 06:07

Connecting Google Sheets to Data Studio Preview 06:22

Calculated Fields (Advance) 2 lectures

Calculated Fields - Simple Arithmetic Preview 06:39

EXERCISE - Create your own Custom Metrics Preview 00:59

Assignment - Build a Dashboard from Scratch and Receive Feedback 1 lectures

Create a Dashboard from Scratch - Analyse 2,750 Ramen Reviews!

In this assignment you are going to use the skills you have learned to create a dashboard from scratch and answer questions about a data set that contains 2,750 reviews of ramen noodles. The data set contains the noodle brand, country, style of eating e.g bowl, variety and star rating. Have fun!