Dynamic Dashboards and Data Analysis with Data Studio – 2022
Dynamic Dashboards and Data Analysis with Data Studio – 2022, available at $79.99, has an average rating of 4.51, with 55 lectures, 10 quizzes, based on 1702 reviews, and has 6752 subscribers.
You will learn about 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 This course is ideal for individuals who are Professionals who want to learn how to make data savvy decisions or Traditional agency or client-side marketers who want to transition to digital or Campaign Managers, Media Planners, Analysts It is particularly useful for Professionals who want to learn how to make data savvy decisions or Traditional agency or client-side marketers who want to transition to digital or Campaign Managers, Media Planners, Analysts.
Enroll now: Dynamic Dashboards and Data Analysis with Data Studio – 2022
Summary
Title: Dynamic Dashboards and Data Analysis with Data Studio – 2022
Price: $79.99
Average Rating: 4.51
Number of Lectures: 55
Number of Quizzes: 10
Number of Published Lectures: 55
Number of Published Quizzes: 10
Number of Curriculum Items: 66
Number of Published Curriculum Objects: 66
Number of Practice Tests: 2
Number of Published Practice Tests: 2
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will 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 Should Attend
- 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
Target Audiences
- 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
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.
Course Curriculum
Chapter 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
Chapter 2: Aggregation, Dynamic Tables and Filters
Lecture 1: Understanding aggregation and data schemas
Lecture 2: Creating a pivot table and using the "Expand-collapse" function
Lecture 3: Creating a comparative heat map pivot table with filters
Chapter 3: Calculated Fields, Custom Dimensions and Advanced Statements
Lecture 1: Creating your first calculated field
Lecture 2: Applying style settings to your metrics
Lecture 3: Understanding "Local" and "Global" scope
Lecture 4: Creating a custom dimension with conditional expressions (CASE + IN)
Lecture 5: Using a regular expression (REGEX_MATCH) to alter an existing dimension
Lecture 6: Applying IF statements within a CASE and using operators
Chapter 4: Advanced Date Selection, Data Comparison and Interaction Filters
Lecture 1: Creating a time series and exploring date formats
Lecture 2: Applying advanced date filters and compare date ranges
Lecture 3: Automating reports with advanced date selection
Lecture 4: Using interaction filters (Geo and Tree Map Charts)
Lecture 5: Configuring a Gauge chart with a single metric
Lecture 6: Adding range limits to specify threshold values
Chapter 5: Blending Data Sources and High Cardinality Dimensions
Lecture 1: Blending two data sources and understanding the concept of a JOIN
Lecture 2: Creating blended calculated fields
Lecture 3: Configuring tables with multiple join keys and exploring cardinality
Lecture 4: New JOIN Configuration and Operators in Google Data Studio [2022]
Chapter 6: Project 1: Create a User Journey Funnel with Google Analytics
Lecture 1: Connecting Google Analytics Demo account to Data Studio
Lecture 2: Part 1: Creating a User Journey Funnel with Google Analytics
Lecture 3: Part 2: Synchronize segments with Google Analytics and applying extra filters
Chapter 7: Project 2: Create a device breakdown visualization with user-level data
Lecture 1: Understanding user-level data and granularity
Lecture 2: Part 1: Creating a device breakdown view in your report
Lecture 3: Part 2: Interpreting user-level data with a scatter plot
Chapter 8: Advanced Design and Formatting
Lecture 1: A framework for designing an insightful and intuitive dashboard
Lecture 2: Using conditional formatting and exploring rule sequencing
Lecture 3: Selecting a field as an input value in conditional formatting
Lecture 4: Applying OR and AND statements to Google Ads keyword data
Lecture 5: Adding multiple pages and applying different report navigation styles
Lecture 6: Extracting a theme and color scheme from an Image/URL
Lecture 7: Using presentation mode and exploring the Data Studio streamlined toolbar
Chapter 9: Sharing Reports, Version History and Scheduling
Lecture 1: Permission levels: Data Source and Report Access
Lecture 2: URL Embedding, PDF Downloads, Version History and Scheduling
Lecture 3: Report publishing functionality: "Published" vs "Draft" mode
Lecture 4: Creating custom e-mail schedules for your reports
Chapter 10: Getting familiar with Google BigQuery for Data Studio
Lecture 1: Creating a Google Cloud Platform (GCP) account for free
Lecture 2: Creating a GCP project and configuring data sets within BigQuery
Lecture 3: Running a SQL query and visualizing the output table in Google Data Studio
Chapter 11: Automating marketing reporting and data connectors with Supermetrics
Lecture 1: Why is reporting automation important?
Lecture 2: What is Supermetrics and how to create a free trial account?
Lecture 3: Connecting and automating Facebook Ads data in Data Studio
Chapter 12: Dashboard Building Challenge: Create a dashboard in 10 minutes and get feedback!
Chapter 13: Conclusion
Lecture 1: Next Steps
Lecture 2: FREE Dashboard Template
Lecture 3: Advanced Page and Report Navigation in Google Data Studio – 2021
Lecture 4: Top 5 Most Useful Calculated Fields and Functions in Google Data Studio
Lecture 5: 3 Ways to Use Google Data Studio for Benchmarks and Sales Targets
Lecture 6: How to filter metric values with a slider control in Google Data Studio?
Lecture 7: How to use parameters in Google Data Studio in 2021?
Lecture 8: BONUS: 20% OFF a Supermetrics subscription (conditions apply)
Instructors
-
Lachezar Arabadzhiev
Founder and CEO -
SkildLabs Inc.
Building Better Learning Experience!
Rating Distribution
- 1 stars: 5 votes
- 2 stars: 16 votes
- 3 stars: 167 votes
- 4 stars: 609 votes
- 5 stars: 905 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024