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
Screenshots