Create reports & data visualisations from Google Analytics, Google Sheets, BigQuery or any other data source
What you'll learn:
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
