Data Visualization In Google Data Studio/Looker Studio, 2023

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.

Requirements

Gmail Account (Free)

We will register a Google Data Studio account during the course

Google Analytics Demo Account (Free and Provided)

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.

Overview

Section 1: Introduction

Lecture 1 Introduction to the course

Lecture 2 What is Looker Studio?

Lecture 3 Creating your Looker Studio account

Lecture 4 Business case

Section 2: Dashboard purpose and structure

Lecture 5 Section overview

Lecture 6 Main parts of the dashboard

Lecture 7 Report specification

Lecture 8 Layout and grids

Section 3: Connect the data source and setup the theme

Lecture 9 Section overview

Lecture 10 Data Sources

Lecture 11 Connect your first data source

Lecture 12 Interface overview

Lecture 13 Theme and layout: Theme setup

Lecture 14 Theme and layout: Colors and Grids

Lecture 15 Theme and layout: Page navigation and Layout

Lecture 16 Homework

Section 4: Building the dashboard: Header

Lecture 17 Section overview

Lecture 18 Image and text elements

Lecture 19 Date range

Lecture 20 Shapes and lines

Lecture 21 Page and report-level elements

Lecture 22 Homework

Section 5: KPIs section: scorecards, bar charts, and tables

Lecture 23 Section overview

Lecture 24 Scorecards

Lecture 25 Optional metrics

Lecture 26 Bar Charts

Lecture 27 Align and distribute

Lecture 28 Homework

Section 6: Key metrics month by month: Tables

Lecture 29 Section overview

Lecture 30 Create a simple table

Lecture 31 Drill down dimensions

Lecture 32 Metrics and columns distribution

Lecture 33 Rows per page use case

Lecture 34 Table sorting

Lecture 35 Conditional formatting

Lecture 36 Heatmap table

Lecture 37 Bar table settings

Lecture 38 Homework

Section 7: Website Users: Time Series Graphs

Lecture 39 Section overview

Lecture 40 Determine users metrics

Lecture 41 Time series chart setup

Lecture 42 Stylize time series chart

Lecture 43 Finishing stylizing time chart

Lecture 44 Homework

Section 8: Tech overview: pie chart, stacked bar chart, pivot table

Lecture 45 Section overview

Lecture 46 Current page settings

Lecture 47 Observe the data

Lecture 48 Pie and doughnut chart settings

Lecture 49 Pie chart styles

Lecture 50 Stacked bar chart set up

Lecture 51 Stacked bar chart style

Lecture 52 Create a pivot table

Lecture 53 Styles for pivot tables

Lecture 54 Homework

Section 9: Geography overview: geo chart

Lecture 55 Section overview

Lecture 56 Create and setup Geo chart

Lecture 57 Geo chart styles

Lecture 58 Table data for geo chart

Lecture 59 Bubble map options

Lecture 60 Filled and other types of Google maps

Lecture 61 Homework

Section 10: Default Channel Overview: Bubble chart

Lecture 62 Section overview

Lecture 63 Default channels table

Lecture 64 Bubble chart settings

Lecture 65 Bubble chart style

Lecture 66 Homework

Section 11: Products Analytics: TreeMap, Control elements, Footer

Lecture 67 Section overview

Lecture 68 Supporting table

Lecture 69 TreeMap Graph

Lecture 70 Control elements

Lecture 71 Groups and control elements

Lecture 72 Add a footer

Lecture 73 Homework

Section 12: From beginner to advanced user: introduction

Lecture 74 Section overview

Lecture 75 Comparison calculation

Lecture 76 How to use filters

Lecture 77 Introduction to calculated fields

Lecture 78 Calculated fields on the chart base and report base

Lecture 79 Data blending overview

Lecture 80 Data blending example

Lecture 81 Partner connector services

Lecture 82 How to copy report

Lecture 83 Homework

Section 13: Summary

Lecture 84 Summary of Looker Studio dashboard creation

Lecture 85 Next steps

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