Data Analytics with Google Data Studio

Show the key insights from your AppSheet or Google Sheets data into a Google Data Studio dashboard

Created by : Rated :4 811 views

Last Updated: 2023-05-05 12:05:22 English Course Type: Self Learning

You will learn how to create dashboards in Looker Studio / Google Data Studio from Google Sheets data

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.

Some basic knowledge of Google Sheets would be good, but not mandatory

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

Section 1 : Intro 1 Lectures 00:01:02
Lecture 1 :
Course Overview Preview
Section 2 : Google Sheets: Data Modelling 3 Lectures 00:25:33
Lecture 1 :
Google Sheets Formatting
Lecture 2 :
Sheet Functions - Query Import Range
Lecture 3 :
Sheet Functions - Vlookup Defined Range
Section 3 : Google / Looker Data Studio: Dashboard Design & Build 11 Lectures 01:54:28
Lecture 1 :
Data Source Connection
Lecture 2 :
Calculated Fields
Lecture 3 :
Theme Definition
Lecture 4 :
Page Layout Design
Lecture 5 :
Charts - Scorecard
Lecture 6 :
Charts - Time Series
Lecture 7 :
Data Blending
Lecture 8 :
Charts - Bar Donut Treemap
Lecture 9 :
Charts - Interactive Filters
Lecture 10 :
Project Analysis Page
Lecture 11 :
Client Analysis Page

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Pedro Bailadeira,

811 Course Views

1 Courses

Welcome to my course on Data Analytics with Google Data Studio! I am excited to help you unlock the power of this powerful data visualization and reporting tool. As a seasoned instructor and expert in Google Data Studio, I have spent years helping students and professionals alike to gain a deep understanding of this tool and use it to its full potential. With my course, you will learn how to use Google Data Studio to create visually stunning and highly informative reports, automate your data analysis process, and make data-driven decisions with confidence. By the end of the course, you will have a strong foundation in data analytics and be able to use Google Data Studio to create insightful reports that will impress your clients, colleagues, or boss. In addition to my expertise in Google Data Studio, I also have a deep understanding of Google Sheets, which is an essential tool for data analysis and reporting. This knowledge will help you to integrate your data sources and create more complex reports with ease. Whether you're a marketer, business owner, or data analyst, this course is perfect for anyone looking to gain a deeper understanding of data analytics and take their reporting skills to the next level. So, sign up today and let's start exploring the world of data analytics with Google Data Studio!