Dynamic Dashboards and Data Analysis with Data Studio – 2022 | Udemy

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

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

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

ddownload.com/0ukwvbi44ca6/UD-Dynamic-Dashboards-and-Data-Analysis.part1.rar
ddownload.com/rrit2hxqc412/UD-Dynamic-Dashboards-and-Data-Analysis.part2.rar

rapidgator.net/file/0c9cbc009be88182fb2018f492e60476/UD-Dynamic-Dashboards-and-Data-Analysis.part1.rar.html
rapidgator.net/file/ef167c0539223070f7ab6a0c6144b40b/UD-Dynamic-Dashboards-and-Data-Analysis.part2.rar.html

If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9