Google Data Studio | Beginner to Expert

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

What you'll 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

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