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

1 - Getting Started with Google Data Studio

1 - Welcome to the Course

2 - Creating your Google Data Studio account

2 - google data studio website.zip

3 - Introducing the concepts of connectors and data flow

4 - Setting up the course data sets in Google Sheets

4 - google sheets data sets course materials.zip

5 - Using the Data Studio Solutions Manual

5 - data studio solutions manual and templates.zip

2 - Aggregation Dynamic Tables and Filters

6 - Understanding aggregation and data schemas

7 - Creating a pivot table and using the Expandcollapse function

8 - Creating a comparative heat map pivot table with filters

3 - Calculated Fields Custom Dimensions and Advanced Statements

9 - Creating your first calculated field

10 - Applying style settings to your metrics

11 - Understanding Local and Global scope

12 - Creating a custom dimension with conditional expressions CASE IN

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

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

14 - Applying IF statements within a CASE and using operators

4 - Advanced Date Selection Data Comparison and Interaction Filters

15 - Creating a time series and exploring date formats

16 - Applying advanced date filters and compare date ranges

17 - Automating reports with advanced date selection

18 - Using interaction filters Geo and Tree Map Charts

19 - Configuring a Gauge chart with a single metric

20 - Adding range limits to specify threshold values

5 - Blending Data Sources and High Cardinality Dimensions

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

22 - Creating blended calculated fields

23 - Configuring tables with multiple join keys and exploring cardinality

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

25 - google analytics demo account.zip

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

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

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

28 - Understanding userlevel data and granularity

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

30 - Part 2 Interpreting userlevel data with a scatter plot

8 - Advanced Design and Formatting

31 - A framework for designing an insightful and intuitive dashboard

32 - Using conditional formatting and exploring rule sequencing

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

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

35 - Adding multiple pages and applying different report navigation styles

36 - Extracting a theme and color scheme from an ImageURL

36 - link to nike logo.zip

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

9 - Sharing Reports Version History and Scheduling

38 - Permission levels Data Source and Report Access

39 - URL Embedding PDF Downloads Version History and Scheduling

40 - Report publishing functionality Published vs Draft mode

41 - Creating custom email schedules for your reports

41 - more info.zip

10 - Getting familiar with Google BigQuery for Data Studio

42 - Creating a Google Cloud Platform GCP account for free

42 - free google cloud platform account.zip

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

43 - google analytics ecommerce dataset.zip

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

11 - Automating marketing reporting and data connectors with Supermetrics

45 - Why is reporting automation important

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

46 - supermetrics free trial.zip

47 - Connecting and automating Facebook Ads data in Data Studio

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

13 - Conclusion

48 - Next Steps

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

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training