Dynamic Dashboards and Data Analysis with Google Data Studio
4.5 (137 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
700 students enrolled

Dynamic Dashboards and Data Analysis with Google Data Studio

Learn how to build powerful data visualizations and unlock insights with ease in Google Data Studio
4.5 (137 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
700 students enrolled
Last updated 3/2020
English
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 3 articles
  • 2 Practice Tests
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand the art of capturing data-driven insights and visual storytelling
  • Use all chart types throughout the course (Bullets, Pie Charts, Scorecards, Scatter plot and etc.)
  • Get familiar with Google BigQuery for Google Data Studio
  • Build advanced dashboards with pivot tables and use the "Expand-collapse" function
  • Connect and blend data sources, and learn about dimension cardinlity
  • Build a user journey funnel with Google Analytics data (Practical Example #1)
  • Create a device breakdown visualization with user-level data (Practical Example #2)
  • Create custom dimensions with conditional expressions (CASE + REGEXP_MATCH + IN)
  • Explore dashboard design and conditional formatting
  • Create time series with rolling dates and interaction filters
  • Get a FREE dashboard template
Requirements
  • Gmail Account (Free)
  • Google Data Studio Registration (Free)
  • Google Analytics Demo Account (Free and Provided)
  • Google BigQuery Account (Free)
Description

LATEST CONTENT UPDATE: May, 2020


Welcome to Dynamic Dashboards and Data Analysis with Google Data Studio! In this course, you will learn how to build powerful data visualizations and unlock insights that can help you drive business results for your clients or employers. This course aims to strike a balance between the foundations of data analysis and hands-on practical examples. The course starts with an introductory view of key concepts such as aggregation, pivot tables, calculated fields, data blending and then dives into real-world projects, including:

  • Project 1: Create a User Journey Funnel with Google Analytics

  • Project 2: Create a device breakdown visualization with user-level data


By the end of the course, you will be able to:

  • Use  and understand all chart types throughout the course (Bullets, Pie Charts, Scorecards, Scatter plot and etc.)

  • Connect and blend data sources from Google Analytics and Google Sheets

  • Create custom dimensions with conditional expressions (CASE + REGEXP_MATCH + IN)

  • Build a user journey funnel with Google Analytics data based on a "Page Title" dimension

  • Create a device breakdown visualization and explore user-level data with scatter plot (eCommerece)

  • Create a Google BigQuery table based on a specific SQL query and visualize it in Data Studio

  • Create time series with rolling dates and interaction filters

  • Automate reports with advanced date selection filters

  • Understand the access levels in Data Studio "Owner" vs "Viewer"

  • Apply conditional formatting rules to signal data anomalies

  • Extract a report theme and colour scheme from an image in Data Studio


What are the students who took the course saying?


"The pace of the course was great and I was able to follow along with all the exercises using the provided data files and Google Analytics demo account" - Tricia


"The course is fantastic. The instructor was clear and on-point when it came to the content. Lachezar took me from a complete beginner to someone who can actually build dashboards and understand how DS works.

I was blown away by how relatively short the video content was compared to the value I received - if you go beyond what's instructed and dive deep to recreate every single step (and dashboard) presented in this course yourself, it'll take you easily 10-15 hours of work to do.

This is a no fluff course, updated, with great support from the instructor - I urge you to go for it." - Roi


"This course has been very very done, clear and insightful. I will start to use Data studio from today on." - Silvia


Who is the instructor?

Lachezar Arabadzhiev is a digital markitech with 4+ years of experience in performance analytics and data visualization. Lachezar began his career as a digital marketer at Microsoft, but soon transitioned to the measurement and analytics world, where he has had the opportunity to work with major brands such as Air Canada, RBC, Kimberly-Clark, Mazda and HSBC.

Lachezar has been working with Data Studio and BigQuery since early 2017 and has built a wide variety of visualizations and automation flows. From performance-based dashboards with joined GMP sources (Google Analytics 360, Campaign Manager and Display & Video 360) to audience-driven segmentation views with user-level eCommerce data.

Lachezar is a certified GMP expert and an official speaker at the Canadian Google Data & Analytics Summit, 2018.


Bonus

The course includes custom Google Sheets data sets for each section, a Data Studio Solutions Manual and a FREE Dashboard Template upon completion of the course. And don't worry, if the course does not work out for you, you can always get your money back in 30 days.


Who this course is for:
  • Professionals who want to learn how to make data savvy decisions
  • Traditional agency or client-side marketers who want to transition to digital
  • Campaign Managers, Media Planners, Analysts
Course content
Expand all 40 lectures 03:05:18
+ Getting Started with Google Data Studio
5 lectures 09:17
Introducing the concepts of connectors and data flow
03:31
Setting up the course data sets in Google Sheets
01:27

In the link below, you would be able to find a solution manual to all the exercises we will go through during the course. If you get stuck on an exercise, feel free to take a look :)

Using the Data Studio Solutions Manual
00:45
+ Aggregation, Dynamic Tables and Filters
3 lectures 18:43
Understanding aggregation and data schemas
09:01
Creating a pivot table and using the "Expand-collapse" function
05:43
Creating a comparative heat map pivot table with filters
03:59
Knowledge Check
3 questions
+ Calculated Fields, Custom Dimensions and Advanced Statements
5 lectures 23:14
Creating your first calculated field
07:42
Applying style settings to your metrics
01:05
Understanding "Local" and "Global" scope
02:37
Using a regular expression (REGEX_MATCH) to alter an existing dimension
06:22
Knowledge Check
3 questions
+ Advanced Date Selection, Data Comparison and Interaction Filters
4 lectures 21:14
Creating a time series and exploring date formats
05:39
Applying advanced date filters and compare date ranges
05:52
Automating reports with advanced date selection
02:20
Using interaction filters (Geo and Tree Map Charts)
07:23
Knowledge Check
3 questions
+ Blending Data Sources and High Cardinality Dimensions
3 lectures 19:51
Blending two data sources and understanding the concept of a JOIN
07:48
Creating blended calculated fields
04:14
Configuring tables with multiple join keys and exploring cardinality
07:49
Knowledge Check
2 questions
+ Project 1: Create a User Journey Funnel with Google Analytics
3 lectures 18:27
Part 1: Creating a User Journey Funnel with Google Analytics
08:23
Part 2: Synchronize segments with Google Analytics and applying extra filters
06:56
Practical Activity
5 questions
+ Project 2: Create a device breakdown visualization with user-level data
3 lectures 18:01
Understanding user-level data and granularity
03:17
Part 1: Creating a device breakdown view in your report
06:42
Part 2: Interpreting user-level data with a scatter plot
08:02
Practical Activity
5 questions
+ Advanced Design and Formatting
5 lectures 26:17
A framework for designing an insightful and intuitive dashboard
07:47
Using conditional formatting and exploring rule sequencing
06:11
Selecting a field as an input value in conditional formatting
02:41

On October 24, 2019, the Google Data Studio Team enabled us to create conditional formatting AND and OR rules, to add colour and style to our data when those conditions are met.

Applying OR and AND statements to Google Ads keyword data
06:14

As of January 23, 2020, you can now automatically generate a custom theme for your reports based on the colors in an image. This makes it easy to coordinate the text and data colors with an image in your report, such as a logo or product photo. You can also create themes from images you upload or can access on the web.

Extracting a theme and color scheme from an Image/URL
03:24
Knowledge Check
2 questions
+ Sharing Reports, Version History and Scheduling
3 lectures 10:05
Permission levels: Data Source and Report Access
05:11
URL Embedding, PDF Downloads, Version History and Scheduling
03:51
Creating custom e-mail schedules for your reports
01:03
Knowledge Check
2 questions
+ Getting familiar with Google BigQuery for Data Studio
3 lectures 18:24
Creating a GCP project and configuring data sets within BigQuery
06:41
Running a SQL query and visualizing the output table in Google Data Studio
09:11
Knowledge Check
2 questions