Dynamic Dashboards And Data Analysis With Data Studio - 2022

Learn how to build powerful data visualizations and unlock insights with ease in Google Data Studio

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
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 AnalyticsProject 2: Create a device breakdown visualization with user-level dataNEW* Dashboard Building Challenge: Create a dashboard in 10 minutes and get feedback from the instructor and/or your fellow students! (Assignment)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 SheetsCreate custom dimensions with conditional expressions (CASE + REGEXP_MATCH + IN)Build a user journey funnel with Google Analytics data based on a "Page Title" dimensionCreate 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 StudioCreate time series with rolling dates and interaction filtersConfigure Gauge charts to track performance against a specific goal or KPIAutomate reports with advanced date selection filtersUnderstand 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 StudioApply IF statements within a CASE and use operatorsWhat 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." - SilviaWho 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.BonusThe 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.

Overview

Section 1: Getting Started with Google Data Studio

Lecture 1 Welcome to the Course!

Lecture 2 Creating your Google Data Studio account

Lecture 3 Introducing the concepts of connectors and data flow

Lecture 4 Setting up the course data sets in Google Sheets

Lecture 5 Using the Data Studio Solutions Manual

Section 2: Aggregation, Dynamic Tables and Filters

Lecture 6 Understanding aggregation and data schemas

Lecture 7 Creating a pivot table and using the "Expand-collapse" function

Lecture 8 Creating a comparative heat map pivot table with filters

Section 3: Calculated Fields, Custom Dimensions and Advanced Statements

Lecture 9 Creating your first calculated field

Lecture 10 Applying style settings to your metrics

Lecture 11 Understanding "Local" and "Global" scope

Lecture 12 Creating a custom dimension with conditional expressions (CASE + IN)

Lecture 13 Using a regular expression (REGEX_MATCH) to alter an existing dimension

Lecture 14 Applying IF statements within a CASE and using operators

Section 4: Advanced Date Selection, Data Comparison and Interaction Filters

Lecture 15 Creating a time series and exploring date formats

Lecture 16 Applying advanced date filters and compare date ranges

Lecture 17 Automating reports with advanced date selection

Lecture 18 Using interaction filters (Geo and Tree Map Charts)

Lecture 19 Configuring a Gauge chart with a single metric

Lecture 20 Adding range limits to specify threshold values

Section 5: Blending Data Sources and High Cardinality Dimensions

Lecture 21 Blending two data sources and understanding the concept of a JOIN

Lecture 22 Creating blended calculated fields

Lecture 23 Configuring tables with multiple join keys and exploring cardinality

Lecture 24 New JOIN Configuration and Operators in Google Data Studio [2022]

Section 6: Project 1: Create a User Journey Funnel with Google Analytics

Lecture 25 Connecting Google Analytics Demo account to Data Studio

Lecture 26 Part 1: Creating a User Journey Funnel with Google Analytics

Lecture 27 Part 2: Synchronize segments with Google Analytics and applying extra filters

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

Lecture 28 Understanding user-level data and granularity

Lecture 29 Part 1: Creating a device breakdown view in your report

Lecture 30 Part 2: Interpreting user-level data with a scatter plot

Section 8: Advanced Design and Formatting

Lecture 31 A framework for designing an insightful and intuitive dashboard

Lecture 32 Using conditional formatting and exploring rule sequencing

Lecture 33 Selecting a field as an input value in conditional formatting

Lecture 34 Applying OR and AND statements to Google Ads keyword data

Lecture 35 Adding multiple pages and applying different report navigation styles

Lecture 36 Extracting a theme and color scheme from an Image/URL

Lecture 37 Using presentation mode and exploring the Data Studio streamlined toolbar

Section 9: Sharing Reports, Version History and Scheduling

Lecture 38 Permission levels: Data Source and Report Access

Lecture 39 URL Embedding, PDF Downloads, Version History and Scheduling

Lecture 40 Report publishing functionality: "Published" vs "Draft" mode

Lecture 41 Creating custom e-mail schedules for your reports

Section 10: Getting familiar with Google BigQuery for Data Studio

Lecture 42 Creating a Google Cloud Platform (GCP) account for free

Lecture 43 Creating a GCP project and configuring data sets within BigQuery

Lecture 44 Running a SQL query and visualizing the output table in Google Data Studio

Section 11: Automating marketing reporting and data connectors with Supermetrics

Lecture 45 Why is reporting automation important?

Lecture 46 What is Supermetrics and how to create a free trial account?

Lecture 47 Connecting and automating Facebook Ads data in Data Studio

Section 12: Dashboard Building Challenge: Create a dashboard in 10 minutes and get feedback!

Section 13: Conclusion

Lecture 48 Next Steps

Lecture 49 FREE Dashboard Template

Lecture 50 Advanced Page and Report Navigation in Google Data Studio – 2021

Lecture 51 Top 5 Most Useful Calculated Fields and Functions in Google Data Studio

Lecture 52 3 Ways to Use Google Data Studio for Benchmarks and Sales Targets

Lecture 53 How to filter metric values with a slider control in Google Data Studio?

Lecture 54 How to use parameters in Google Data Studio in 2021?

Lecture 55 BONUS: 20% OFF a Supermetrics subscription (conditions apply)

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