Show the key insights from your AppSheet or Google Sheets data into a Google Data Studio dashboard
What you'll learn
- Google Data Studio
- Google Sheets
- Data Analytics
- Data Visualization
- Dashboard Design
Requirements
- Not really, some basic knowledge of Google Sheets would be good, but not mandatory
Description
Learn how to design a beautiful, professional-looking interactive Google Data Studio dashboard to show the main insights of your data!In this course, you will learn step-by-step, how to prepare the data in Google Sheets (it can be a simple sheet, or it can be connected to other sources, like an AppSheet app) to be consumed in Google Data Studio, how to connect Google Sheets to GDS, and how to design a multi-page GDS dashboard.
During the course, you will learn the most important Google Sheets formulas (such as vlookup, sumifs, query, importrange, etc.), and how to cross calculation between sheets, and how to design nice-looking tables in Google Sheets.
Also, learn how to connect different data sources into a Google Data Studio dashboard, how to format the fields of the data sources, how to create calculated fields, and how to blend data from different data sources.
And improve your dashboard design skills by watching how to build a multi-page dashboard from scratch, which includes setting up the theme, customize the page layout, customize different charts, and select which ones to use in different scenarios to best show the main insights from your data.
Last but not least, the course covers some advanced functionalities like how to set up filters and to make the visuals interactive between them, to allow to explore the dashboard to get hidden insights.
Who this course is for:
- Beginners that want to learn more about Google Data Studio, using data from Google Sheets
- Intermediate level users that want to improve their Google Data Studio design skills
