Data Visualization in Google Data Studio/Looker Studio, 2023

Focused View

Galina Ivannikova

6:45:13

101 View

1. Introduction

1.1 1 01 Introduction to the course.pdf

1. Introduction to the course.mp4

02:07

2.1 1 02 What is Looker Studio .pdf

2.2 1 02 What is Looker Studio slides.pdf

2. What is Looker Studio.mp4

03:34

3. Creating your Looker Studio account.mp4

01:56

4.1 1 04 Business case slides.pdf

4.2 1 04 Business case text.pdf

4. Business case.mp4

01:18

2. Dashboard purpose and structure

1.1 02 00 Dashboard purpose and structure slides.pdf

1. Section overview.mp4

00:39

2.1 02 01 Main parts of the dashboard slides.pdf

2.2 02 01 Main parts of the dashboard.pdf

2. Main parts of the dashboard.mp4

04:20

3.1 02 02 Report specification slides.pdf

3.2 02 02 Report specification.pdf

3. Report specification.mp4

03:59

4.1 02 03 Layout and grids slides.pdf

4.2 02 03 Layout and grids.pdf

4. Layout and grids.mp4

02:52

3. Connect the data source and setup the theme

1.1 3 00 Section overview.pdf

1. Section overview.mp4

00:36

2.1 03 01 Data sources overview eng.pdf

2.2 3 01 Data sources overview eng slides.pdf

2. Data Sources.mp4

04:54

3.1 3 02 Connect your first data source eng slides.pdf

3.2 3 02 Connect your first data source.pdf

3. Connect your first data source.mp4

07:00

4.1 3 03 Interface overview eng slides.pdf

4.2 3 03 Interface overview eng.pdf

4. Interface overview.mp4

07:19

5.1 3 04 Theme and layout Theme setup slides.pdf

5.2 3 04 Theme and layout Theme setup.pdf

5. Theme and layout Theme setup.mp4

08:04

6.1 3 05 Theme and layout Colors and Grids slides.pdf

6.2 3 05 Theme and layout Colors and Grids.pdf

6. Theme and layout Colors and Grids.mp4

09:26

7.1 3 06 Theme and layout Page navigation and Layout slides.pdf

7.2 3 06 Theme and layout Page navigation and Layout.pdf

7. Theme and layout Page navigation and Layout.mp4

08:57

8. Knowledge Check. Connect the data source and setup the theme.html

9.1 3 Homework.pdf

9. Homework.html

4. Building the dashboard Header

1.1 04 00 Building the dashboard Header (Section overview) (1).pdf

1. Section overview.mp4

00:37

2.1 04 01 Building the dashboard Header slides.pdf

2.2 04 01 Building the dashboard Header.pdf

2. Image and text elements.mp4

09:54

3.1 04 02 Date range (1).pdf

3.2 04 02 Date range slides.pdf

3. Date range.mp4

14:34

4.1 04 03 Shapes and lines slides.pdf

4.2 04 03 Shapes and lines.pdf

4. Shapes and lines.mp4

04:41

5.1 04 04 Page and report-level elements slides.pdf

5.2 04 04 Page and report-level elements.pdf

5. Page and report-level elements.mp4

04:56

6. Knowledge Check. Building the dashboard Header.html

7.1 04 Homework.pdf

7. Homework.html

5. KPIs section scorecards, bar charts, and tables

1.1 05 00 Building the dashboard KPIs.pdf

1.2 G21-screen.mp4

01:12

1. Section overview.mp4

00:42

2.1 05 01 Building the dashboard KPIs slides.pdf

2.2 05 01 Scorecards.pdf

2. Scorecards.mp4

09:33

3.1 05 02 Building the dashboard - KPIs - Optional metrics slides.pdf

3.2 05 02 Optional metrics.pdf

3. Optional metrics.mp4

03:17

4.1 05 03 Bar charts.pdf

4.2 05 03 Building the dashboard - KPIs - Bar Charts.pdf

4. Bar Charts.mp4

10:11

5.1 05 04 Align and distribute.pdf

5.2 05 04 Building the dashboard - KPIs - Align and distribute.pdf

5. Align and distribute.mp4

10:26

6. Knowledge Check. KPIs section scorecards, bar charts, and tables.html

7.1 05 Homework.pdf

7. Homework.html

6. Key metrics month by month Tables

1.1 06 00 Key metrics month by month - Tables.pdf

1. Section overview.mp4

00:51

2.1 06 08 Bar table settings .pdf

2.2 06 08 Bar table settings text.pdf

2. Create a simple table.mp4

13:51

3.1 06 02 Drill diwn dimensions text.pdf

3.2 06 02 Drill down dimensions.pdf

3. Drill down dimensions.mp4

05:19

4.1 06 03 Metrics and Column Distribution text.pdf

4.2 06 03 Metrics and column distribution.pdf

4. Metrics and columns distribution.mp4

03:19

5.1 06 04 Rows per page use case text.pdf

5.2 06 04 Rows per page use case.pdf

5. Rows per page use case.mp4

04:02

6.1 06 05 Table sorting text.pdf

6.2 06 05 Table sorting.pdf

6. Table sorting.mp4

03:46

7.1 06 06 Conditional formatting text.pdf

7.2 06 06 Conditional formatting.pdf

7. Conditional formatting.mp4

03:22

8.1 06 07 Heatmap table text.pdf

8.2 06 07 Heatmap table.pdf

8. Heatmap table.mp4

03:42

9.1 06 07 Heatmap table text.pdf

9.2 06 07 Heatmap table.pdf

9. Bar table settings.mp4

03:40

10. Knowledge Check. Key metrics month by month Tables.html

11.1 06 Homework.pdf

11. Homework.html

7. Website Users Time Series Graphs

1.1 07 00 Section Overview.pdf

1. Section overview.mp4

00:50

2.1 07 01 Determine user metrics text.pdf

2.2 07 01 Determine users metrics.pdf

2. Determine users metrics.mp4

06:08

3.1 07 02 Time series chart setup text.pdf

3.2 07 02 Time series chart setup.pdf

3. Time series chart setup.mp4

04:45

4.1 07 03 Stylize time series chart .pdf

4.2 07 03 Stylize time series chart text.pdf

4. Stylize time series chart.mp4

07:26

5.1 07 04 Finishing to stylize time chart .pdf

5.2 07 04 Finishing to stylize time chart text.pdf

5. Finishing stylizing time chart.mp4

08:41

6. Knowledge Check. Website Users Time Series Graphs.html

7.1 07 Homework.pdf

7. Homework.html

8. Tech overview pie chart, stacked bar chart, pivot table

1.1 08 00 Tech overview - pie chart, stacked bar chart, pivot table.pdf

1. Section overview.mp4

01:17

2.1 08 01 Current page settings text.pdf

2.2 08 01 Current page settings.pdf

2. Current page settings.mp4

02:26

3.1 08 02 Observe the data text.pdf

3.2 08 02 Observe the data.pdf

3. Observe the data.mp4

04:39

4.1 08 03 Pie and doughnut chart settings text.pdf

4.2 08 03 Pie and doughnut chart settings.pdf

4. Pie and doughnut chart settings.mp4

05:55

5.1 08 04 Pie chart styles text.pdf

5.2 08 04 Pie chart styles.pdf

5. Pie chart styles.mp4

04:22

6.1 08 05 Stacked bar chart set up text.pdf

6.2 08 05 Stacked bar chart set up.pdf

6. Stacked bar chart set up.mp4

03:34

7.1 08 06 Stacked bar chart style text.pdf

7.2 08 06 Stacked bar chart style.pdf

7. Stacked bar chart style.mp4

08:55

8.1 08 07 Create a pivot table text.pdf

8.2 08 07 Create a pivot table.pdf

8. Create a pivot table.mp4

08:30

9.1 08 08 Styles for pivot tables text.pdf

9.2 08 08 Styles for pivot tables.pdf

9. Styles for pivot tables.mp4

06:30

10. Knowledge Check. Tech overview pie chart, stacked bar chart, pivot table.html

11.1 08 Homework.pdf

11. Homework.html

9. Geography overview geo chart

1.1 09 00 Geography section overview.pdf

1. Section overview.mp4

00:44

2.1 09 01 Create and setup Geo chart text.pdf

2.2 09 01 Create and setup Geo chart.pdf

2. Create and setup Geo chart.mp4

07:18

3.1 09 02 Geo chart styles text.pdf

3.2 09 02 Geo chart styles.pdf

3. Geo chart styles.mp4

02:18

4.1 09 03 Table data for geo chart text.pdf

4.2 09 03 Table data for geo chart.pdf

4. Table data for geo chart.mp4

05:03

5.1 09 04 Bubble map options text.pdf

5.2 09 04 Bubble map options.pdf

5. Bubble map options.mp4

04:38

6.1 09 05 Filled and other types of Google Maps text.pdf

6.2 09 05 Filled and other types of Google maps.pdf

6. Filled and other types of Google maps.mp4

06:09

7. Knowledge Check. Geography overview geo chart.html

8.1 09 Homework.pdf

8. Homework.html

10. Default Channel Overview Bubble chart

1.1 10 00 Default Channel Overview.pdf

1. Section overview.mp4

00:47

2.1 10 01 Default Channels Table text.pdf

2.2 10 01 Default Channels Table.pdf

2. Default channels table.mp4

06:06

3.1 10 02 Bubble Chart Settings text.pdf

3.2 10 02 Bubble Chart Settings.pdf

3. Bubble chart settings.mp4

08:18

4.1 10 03 Bubble Chart style (1).pdf

4.2 10 03 Bubble Chart style text (1).pdf

4. Bubble chart style.mp4

08:14

5. Knowledge Check. Default Channel Overview Bubble chart.html

6. Homework.html

11. Products Analytics TreeMap, Control elements, Footer

1.1 11 00 Products Analytics.pdf

1. Section overview.mp4

00:53

2.1 11 01 Supporting table text.pdf

2.2 11 01 Supporting table.pdf

2. Supporting table.mp4

06:34

3.1 11 02 TreeMap Graph text.pdf

3.2 11 02 TreeMap Graph.pdf

3. TreeMap Graph.mp4

08:53

4.1 11 03 Control elements text.pdf

4.2 11 03 Control elements.pdf

4. Control elements.mp4

10:53

5.1 11 02 TreeMap Graph text.pdf

5.2 11 02 TreeMap Graph.pdf

5. Groups and control elements.mp4

03:43

6.1 11 05 Add a footer (1).pdf

6.2 11 05 Add a footer text (1).pdf

6. Add a footer.mp4

06:34

7. Knowledge Check. Products Analytics TreeMap, Control elements, Footer.html

8.1 11 Homework.pdf

8. Homework.html

12. From beginner to advanced user introduction

1.1 12 00 From beginner to advanced user.pdf

1. Section overview.mp4

00:51

2.1 12 01 Comparison calculation text.pdf

2.2 12 01 Comparison calculation.pdf

2. Comparison calculation.mp4

10:01

3.1 12 02 How to use filters text.pdf

3.2 12 02 How to use filters.pdf

3. How to use filters.mp4

09:04

4.1 12 03 Introduction to calculated fields text.pdf

4.2 12 03 Introduction to calculated fields.pdf

4. Introduction to calculated fields.mp4

08:29

5.1 12 04 Calculated fields on the chart base and report base text.pdf

5.2 12 04 Calculated fields on the chart base and report base.pdf

5. Calculated fields on the chart base and report base.mp4

05:02

6.1 12 05 Data blending overview text.pdf

6.2 12 05 Data blending overview.pdf

6. Data blending overview.mp4

06:16

7.1 12 06 Data blending example text.pdf

7.2 12 06 Data blending example.pdf

7. Data blending example.mp4

10:05

8.1 12 07 Third-party connector services text.pdf

8.2 12 07 Third-party connector services.pdf

8. Partner connector services.mp4

06:36

9.1 12 08 How to copy report text.pdf

9.2 12 08 How to copy report.pdf

9. How to copy report.mp4

05:12

10. Knowledge Check. From beginner to advanced user introduction.html

11.1 12 Homework.pdf

11. Homework.html

13. Summary

1. Summary of Looker Studio dashboard creation.mp4

01:58

2.1 13 02 Next steps txt.pdf

2.2 Next steps (1).pdf

2. Next steps.mp4

01:40

Description

Learn how to automate marketing dashboards with Looker Studio / Google Data Studio based on Google Analytics (GA4) data.

What You'll Learn?

Learn how to prepare, analyze, and visualize data using Looker Studio (Google Data Studio)
Master the creation of comprehensive dashboards based on key metrics and without programming
Consolidate your knowledge through hands-on practice: complete 10 assignments and a final project
Practical tips and tricks from the professional teacher, who works with Looker Studio (Google Data Studio) daily basis
In this hands-on Looker Studio online course, you will learn to create a digital marketing dashboard from scratch.

Who is this for?

Marketing and sales managers who work in-house

Marketing agencies managers

Beginners to data analysis and Business Intelligence

Specialists working with reports in Excel and Google Sheets looking for a way to automate the routine processes

More details

Description
Streamline your reporting processes and work more efficiently with this course on Looker Studio (formerly Google Data Studio). Learn how to automate routine tasks and create interactive marketing and sales reports, saving you time and effort.
During the online course for Looker Studio by Google, previously known as Google Data Studio, you will be required to complete 10 homework assignments and a final project. Through this course, you will gain practical experience in integrating the knowledge that you have acquired.
The Looker Studio online course is allowing you to create a digital marketing dashboard from scratch.
You will be provided with a business case scenario, where you will play the role of a digital marketing manager responsible for creating a report for your monthly meeting with top management.
The dashboard you create will be based on:
either Google Analytics 4 (GA4)
or Universal Analytics (UA) data source.
The course will offer tips for both versions so that you can choose the one that best suits your needs.
You will be provided with real data to prepare the course report, enabling you to apply the skills you have learned to your own work and gain valuable insights for your business.
By finishing the course you will have a dashboard example that can be added to your portfolio.

Who this course is for:
Marketing and sales managers who work in-house
Marketing agencies managers
Beginners to data analysis and Business Intelligence
Specialists working with reports in Excel and Google Sheets looking for a way to automate the routine processes

User Reviews

Rating

average 0

Total votes0

Focused display

Hi, My name is Gala, I’m a data analyst and a founder of the Gaille Reports. I help different businesses to automate their marketing and sales dashboard on the Google platform base. My main service is to prepare your data for visualization and create an easy-to-read interactive dashboard in Looker Studio (Google Data Studio). What was the story?I have more than 10 years of background in marketing that helps me to understand business owners and management needs.When I quit my office career and started to run my own marketing agency I started to spend a lot of time preparing reports for my clients and one day I decided to automate my routine work as much as I can. And I did it. I automated marketing and sales dashboards for myself. Then I did it for my clients. After that, I started to offer this service to different companies and agencies. If you have different marketing and sales data sources such as Google Ads, Facebook Ads, Bing Ads, CRM-system, and so on, and you don’t see the full picture of your business, I would be happy to help you to bring all your data to one place and create an easy to read and a useful dashboard that you can make data-driven decisions and invest your time and resources to the most profitable channels.

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.