Dynamic Dashboards and Data Analysis with Data Studio - 2022

Focused View

Lachezar Arabadzhiev,SkildLabs Inc.

3:49:37

110 View

1 - Getting Started with Google Data Studio

1 - Welcome to the Course.mp4

01:07

2 - Creating your Google Data Studio account.mp4

02:27

2 - google data studio website.zip

3 - Introducing the concepts of connectors and data flow.mp4

03:31

4 - Setting up the course data sets in Google Sheets.mp4

01:27

4 - google sheets data sets course materials.zip

5 - Using the Data Studio Solutions Manual.mp4

00:47

5 - data studio solutions manual and templates.zip

2 - Aggregation Dynamic Tables and Filters

6 - Understanding aggregation and data schemas.mp4

09:01

7 - Creating a pivot table and using the Expandcollapse function.mp4

05:43

8 - Creating a comparative heat map pivot table with filters.mp4

03:59

3 - Calculated Fields Custom Dimensions and Advanced Statements

9 - Creating your first calculated field.mp4

07:42

10 - Applying style settings to your metrics.mp4

01:05

11 - Understanding Local and Global scope.mp4

02:37

12 - Creating a custom dimension with conditional expressions CASE IN.mp4

05:28

13 - Using a regular expression REGEXMATCH to alter an existing dimension.mp4

06:22

13 - top 5 most useful calculated fields and functions in google data studio.zip

14 - Applying IF statements within a CASE and using operators.mp4

05:02

4 - Advanced Date Selection Data Comparison and Interaction Filters

15 - Creating a time series and exploring date formats.mp4

05:39

16 - Applying advanced date filters and compare date ranges.mp4

05:52

17 - Automating reports with advanced date selection.mp4

02:20

18 - Using interaction filters Geo and Tree Map Charts.mp4

07:23

19 - Configuring a Gauge chart with a single metric.mp4

04:57

20 - Adding range limits to specify threshold values.mp4

05:51

5 - Blending Data Sources and High Cardinality Dimensions

21 - Blending two data sources and understanding the concept of a JOIN.mp4

07:49

22 - Creating blended calculated fields.mp4

04:14

23 - Configuring tables with multiple join keys and exploring cardinality.mp4

07:49

24 - New JOIN Configuration and Operators in Google Data Studio 2022.html

24 - advanced data blending and join operators in google data studio – 2022.zip

6 - Project 1 Create a User Journey Funnel with Google Analytics

25 - Connecting Google Analytics Demo account to Data Studio.mp4

03:08

25 - google analytics demo account.zip

26 - Part 1 Creating a User Journey Funnel with Google Analytics.mp4

08:23

27 - Part 2 Synchronize segments with Google Analytics and applying extra filters.mp4

06:56

7 - Project 2 Create a device breakdown visualization with userlevel data

28 - Understanding userlevel data and granularity.mp4

03:17

29 - Part 1 Creating a device breakdown view in your report.mp4

06:42

30 - Part 2 Interpreting userlevel data with a scatter plot.mp4

08:02

8 - Advanced Design and Formatting

31 - A framework for designing an insightful and intuitive dashboard.mp4

07:47

32 - Using conditional formatting and exploring rule sequencing.mp4

06:11

33 - Selecting a field as an input value in conditional formatting.mp4

02:41

34 - Applying OR and AND statements to Google Ads keyword data.mp4

06:14

35 - Adding multiple pages and applying different report navigation styles.mp4

04:02

36 - Extracting a theme and color scheme from an ImageURL.mp4

03:24

36 - link to nike logo.zip

37 - Using presentation mode and exploring the Data Studio streamlined toolbar.mp4

04:02

9 - Sharing Reports Version History and Scheduling

38 - Permission levels Data Source and Report Access.mp4

05:11

39 - URL Embedding PDF Downloads Version History and Scheduling.mp4

03:51

40 - Report publishing functionality Published vs Draft mode.mp4

03:47

41 - Creating custom email schedules for your reports.mp4

05:36

41 - more info.zip

10 - Getting familiar with Google BigQuery for Data Studio

42 - Creating a Google Cloud Platform GCP account for free.mp4

02:32

42 - free google cloud platform account.zip

43 - Creating a GCP project and configuring data sets within BigQuery.mp4

06:41

43 - google analytics ecommerce dataset.zip

44 - Running a SQL query and visualizing the output table in Google Data Studio.mp4

09:11

11 - Automating marketing reporting and data connectors with Supermetrics

45 - Why is reporting automation important.mp4

01:05

46 - What is Supermetrics and how to create a free trial account.mp4

06:55

46 - supermetrics free trial.zip

47 - Connecting and automating Facebook Ads data in Data Studio.mp4

05:00

12 - Dashboard Building Challenge Create a dashboard in 10 minutes and get feedback

13 - Conclusion

48 - Next Steps.mp4

00:47

48 - google data studio tips techniques and tutorials.zip

48 - linkedin lachezar arabadzhiev.zip

49 - FREE Dashboard Template.html

49 - free dashboard template.zip

50 - Advanced Page and Report Navigation in Google Data Studio – 2021.html

50 - advanced page and report navigation in google data studio – 2021.zip

51 - Top 5 Most Useful Calculated Fields and Functions in Google Data Studio.html

51 - top 5 most useful calculated fields and functions in google data studio.zip

52 - 3 Ways to Use Google Data Studio for Benchmarks and Sales Targets.html

52 - 3 ways to use google data studio for benchmarks and sales targets.zip

53 - How to filter metric values with a slider control in Google Data Studio.html

53 - how to filter metric values with a slider control in google data studio.zip

54 - How to use parameters in Google Data Studio in 2021.html

54 - google data studio parameters.zip

55 - BONUS 20 OFF a Supermetrics subscription conditions apply.html

55 - supermetrics.zip

Description

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

Who is this 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

What You Need to Know?

Gmail Account (Free)

Google Data Studio Registration (Free)

Google Analytics Demo Account (Free and Provided)

Google BigQuery Account (Free)

More details

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 Analytics
Project 2: Create a device breakdown visualization with user-level data
NEW* 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 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
Configure Gauge charts to track performance against a specific goal or KPI
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
Apply IF statements within a CASE and use operators

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

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Lachezar Arabadzhiev

Instructor's Courses

Hey there! I'm Lachezar Arabadzhiev and for the past five years, I have helped companies harness the power of data, visual storytelling, and education in a variety of ways to drive business growth and innovation. I began my career as a digital marketer at Microsoft but soon transitioned to the audience and analytics world, where I had the opportunity to work with major brands including Air Canada, RBC, Walmart, Kimberly-Clark, StackAdapt, LinkedIn, Mazda, and HSBC. Throughout all that time, I always loved teaching and developing learning programs for my fellow colleagues and friends. That passion materialized in early 2021 in the form of a brand new company that I was luckily enough to start.I am currently the Founder and CEO of SkildLabs, where I help companies and individuals build better learning experiences through the power of education and technology. With SkildLabs, I believe we have the ability to empower students globally and create more interactive learning experiences. How? By combining the learning tools already available and a better method for organizing learning experiences.What about Google Data Studio?I have been working with the Google Data Studio beta since early 2017 and have built a wide variety of visualisations and automation flows. From performance-based dashboards with joined GMP sources (GA360, CM and DV360) to audience-driven segmented views with log-level data. In addition, I am a Display and Video 360 (DV360) expert having ran the audience strategy, inventory selection and programmatic optimisation experiments for the programmatic media buying at Royal Bank of Canada (RBC).I am also a Certified GMP expert and an official speaker at the Canadian Google Data & Analytics Summit, 2018.

SkildLabs Inc.

Instructor's Courses

With the rapid switch to virtual workspaces and community meeting places, we’ve watched organizations of all sizes struggle to appropriately and effectively marshal their online learning resources and present them in a comprehensive, easy-to-use format.SkildLabs aims to solve that problem by providing consulting and implementation that lets organizations build their business using the power of education. Whether the goal is upskilling employees, creating a community around courses, or building a micro-academy to explain the intricacies of a product or service, SkildLabs will take your online learning objectives and ideas and turn them into reality, and the best part is we will be there every step of the way.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.