Mô tả

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


Bạn sẽ học được gì

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

Yêu cầu

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

Nội dung khoá học

13 sections

Introduction to the Course and Data Studio

1 lectures
What you will learn and what you will gain
02:58

Get familiar with Data Studio

8 lectures
Introduction to the Homepage
03:51
EXERCISE - Create your Data Studio Account - FOR FREE!
00:32
An Introduction to Data Sources
02:15
EXERCISE - More about Data Sources
00:35
Connecting to Google Analytics Sample Data
03:32
EXERCISE - Connecting your own Google Analytics Data
01:01
The Reporting Interface
09:05
EXERCISE - Customising your Layout
00:32

Your first Dashboard and Beyond

14 lectures
Scorecards for your KPIs and Comparisons
04:58
EXERCISE - Additional Scorecard Customisations
00:45
Time Series Charts for Analysing Trends
05:18
EXERCISE - More Options for Time Series Charts
00:39
Bar Charts for making Comparisons
03:52
EXERCISE - Bar Chart Options
00:33
Tables for Presenting Detail
04:50
EXERCISE - Customise your Tables
00:46
Add new pages to your Report
02:14
Use a Pie Chart (if you really need to) to show Categorical Data
05:02
EXERCISE - Pie Chart Customisation
00:38
Add an Area Chart to segment your data
02:16
EXERCISE - 100% Stack your Area Chart
00:43
How Date Comparisons Work
03:05

Make your Dashboards Interactive with Filters

4 lectures
Filtering by Date
03:24
EXERCISE - Date Range Filters
00:51
Filtering by Dimensions
03:16
EXERCISE - Dimension Filters
00:33

Advance Data Visualisations

7 lectures
The Map Visualisation
04:57
EXERCISE - More about Maps
00:36
Exploring Data with Scatter Charts
05:26
EXERCISE - Scatter Charts
00:51
Bullet Charts for Showing Targets
04:41
EXERCISE - Everything to know about Bullet Charts
00:20
Adding Heatmaps and Bar Charts to Tables
05:40

The Explorer

2 lectures
The Explorer
05:59
The Explorer - Further Reading
00:19

Sharing your dashboard

2 lectures
Sharing your Reports
02:23
Exercise - Accessing your Dashboards in Google Drive
01:10

Data Sources - Connect your Google Analytics Data

4 lectures
Data Sources - Connect your Google Analytics Data
03:41
NEW INTERFACE - Data Sources
00:22
Handling Sampling in Google Analytics
03:17
EXERCISE - Read more about sampling in Google Analytics
00:20

Data Sources - Connecting Google Sheets to Data Studio

2 lectures
Preparing Data in Google Sheets
06:07
Connecting Google Sheets to Data Studio
06:22

Calculated Fields (Advance)

2 lectures
Calculated Fields - Simple Arithmetic
06:39
EXERCISE - Create your own Custom Metrics
00:59

Assignment - Build a Dashboard from Scratch and Receive Feedback

1 lectures
Create a Dashboard from Scratch - Analyse 2,750 Ramen Reviews!
8 questions

Course summary and next steps

1 lectures
What you have Learned and Final words
01:39

BONUS LECTURES

5 lectures
Data Studio Help Forum & Requesting Features
00:50
Tracking Usage of your Data Studio Reports
01:13
Why Data Studio? Understanding if it's the right tool for you.
07:31
INFO - Comparing Business Intelligence Tools
00:23
Advanced Course & Promotoional Code
03:02

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.