Google Data Studio | Beginner to Expert
Create reports & data visualisations from Google Analytics, Google Sheets, BigQuery or any other data source
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
Why take this course?
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