Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication 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 Certifications Network & Security Hardware Operating Systems & Servers 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 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 Paid 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 & Gardening 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 & Diet Yoga Mental Health Martial Arts & 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 Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation Sound Therapy CBT Cognitive Behavioral Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Podcasting

BusinessBusiness Analytics & IntelligenceData Analysis

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
Rating: 4.6 out of 54.6 (838 ratings)
3,710 students
Created by Lachezar Arabadzhiev, SkildLabs Inc.
Last updated 3/2022
English
English [Auto]

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

Featured review

H.S. Ganesh Keerthi
H.S. Ganesh K.
8 courses
8 reviews
Rating: 5.0 out of 5a year 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.

Instructors

Lachezar Arabadzhiev
Founder and CEO
Lachezar Arabadzhiev
  • 4.6 Instructor Rating
  • 1,332 Reviews
  • 8,134 Students
  • 5 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.
Building Better Learning Experience!
SkildLabs Inc.
  • 4.6 Instructor Rating
  • 1,332 Reviews
  • 8,134 Students
  • 5 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.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.