Google Data Studio | Beginner to Expert

Create reports & data visualisations from Google Analytics, Google Sheets, BigQuery or any other data source

Ratings 4.62 / 5.00

What You Will Learn!

Connect Google Analytics and Google Sheets
Connect 3rd party tools as data sources
Create and style Graphs, Tables, and Pivot Tables
Learn about methods of aggregation (sum, avg, max, etc.)
Create custom metrics
Blend multiple data sources
Use CASE statements to modify data
Export, email and/or share reports

Description

The goal of this course:
Be able to create insightful visualisations and data reports no matter what data source you've been given

To achieve this we'll go over:
- Basics of Google Data Studio
- How to add Data Sources (e.g. Google Analytics, Sheets, BigQuery, MySQL, Google Ads, Search Console, etc.)
- Add, format and style visualisations
- Manipulating data with date ranges, filters and segments
- Creation of custom metrics & blending of data sources
- Exporting, emailing & sharing of reports

For the visualisations, we'll go over: Graphs, Tables, Pivot Tables, Column & Bar Charts, Pie Charts, Geographic Maps, Scatterplots, and Score Cards