Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
.jpg)
Get Unlimited Learning Access
$29
4 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
4 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
$29
What you'll learn?
- You will learn how to create dashboards in Looker Studio / Google Data Studio from Google Sheets data
Course Overview
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.
Pre-requisites
- Some basic knowledge of Google Sheets would be good, but not mandatory
Target Audience
- 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
Curriculum 15 Lectures 02:21:03
-
Section 1 : Intro
-
Section 2 : Google Sheets: Data Modelling
- 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
- 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
Our learners work at
Frequently Asked Questions
-
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?
Instructor
472 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!
View More...
