Google Data Studio | Beginner to Expert

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

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

Who Should Attend!

• Anyone interested in visualising data no matter whether your data source is Sheets, Google Analytics, PostgreSQL, CSVs or BigQuery

TAKE THIS COURSE