Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2020-12-22 04:36:47
30-Day Money-Back Guarantee

This course includes:

  • 3.5 hours on-demand video
  • 6 articles
  • 2 practice tests
  • Full lifetime access
  • Access on mobile and TV
Business Business Analytics & Intelligence Data Analysis

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
Rating: 4.5 out of 54.5 (301 ratings)
1,474 students
Created by Lachezar Arabadzhiev
Last updated 12/2020
English
English [Auto]
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

Requirements

  • Gmail Account (Free)
  • Google Data Studio Registration (Free)
  • Google Analytics Demo Account (Free and Provided)
  • Google BigQuery Account (Free)

Description

LATEST CONTENT UPDATE: December, 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

Featured review

H.S. Ganesh Keerthi
H.S. Ganesh Keerthi
7 courses
7 reviews
Rating: 5.0 out of 57 months ago
It is good to see so many options which were hiding in settings. Thanks for explaining them clearly. The only problem is the slang, It will be little tough for indian's and we should go through the lessons once more to understand it.

Course content

12 sections • 46 lectures • 3h 20m total length

  • Preview01:07
  • Preview02:27
  • Introducing the concepts of connectors and data flow
    03:31
  • Setting up the course data sets in Google Sheets
    01:27
  • Using the Data Studio Solutions Manual
    00:45

  • 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

  • Creating your first calculated field
    07:42
  • Applying style settings to your metrics
    01:05
  • Understanding "Local" and "Global" scope
    02:37
  • Preview05:28
  • Using a regular expression (REGEX_MATCH) to alter an existing dimension
    06:22
  • Knowledge Check
    3 questions

  • 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 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

  • Preview03:08
  • 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

  • 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

  • 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
  • Applying OR and AND statements to Google Ads keyword data
    06:14
  • Extracting a theme and color scheme from an Image/URL
    03:24
  • Knowledge Check
    2 questions

  • 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

  • Preview02:32
  • 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

Instructor

Lachezar Arabadzhiev
Performance Analytics and Visualization Professional
Lachezar Arabadzhiev
  • 4.5 Instructor Rating
  • 460 Reviews
  • 2,048 Students
  • 2 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.