Google Data Studio A-Z For Data Visualization And Dashboards (updated 9/2022)

Use Google Data Studio to create reports & data visualizations from Google Sheets| Google Analytics| Google Ads|BigQuery

What you'll learn
How to use Google Data Studio to turns your data into fully customizable informative reports and dashboards that are easy to read and share
All chart types that one can draw in Google Data Studio
Sharing and collaborating on Data studio reports
Branding a report - Adding Logo and setting theme
Embedding external content into the report
Embedding your Google Datastudio report on your website
Adding date range and filter controls to your dashboard
Requirements
You just need a computer with internet connection. This is a beginner friendly course and does not require any previous knowledge.
Description
6 Reasons why you should choose this Google Data Studio courseCarefully designed course, teaching you not only how to draw all types of charts in Google Data Studio, but also advanced Data studio specific featuresConcise - you can complete this Google Data Studio course within one weekendBusiness-related examples and case studiesAmple practice exercises because Data Visualization and Google Data Studio require practiceDownloadable resources for learning Google Data Studio and Data VisualizationYour queries will be responded by the Instructor himselfStart using Google Data Studio to its full potential to become proficient at Google Data Studio and Data Visualization and reporting tasks today!Either you're new to Data Visualization or Google Data Studio, or you've made some charts and graphs using some data visualization software such as MS Excel or Tableau. Either way, this course will be great for you.A Verifiable Certificate of Completion is presented to all students who undertake this Google Data Studio course.Why should you choose this course?This is a complete and concise tutorial on Google Data Studio which can be completed within 6 hours. We know that your time is important and hence we have created this fast paced course without wasting time on irrelevant operations.What makes us qualified to teach you?The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. We have in-depth understanding on and practical exposure to Google Data Studio and Data Visualization.We are also the creators of some of the most popular online courses - with over 600,000 enrollments and thousands of 5-star reviews like these ones:I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! - SikiruVery insightful, learning very nifty tricks and enough detail to make it stick in your mind. - ArmandOur PromiseTeaching our students is our job and we are committed to it. If you have any questions about the course content, Google Data Studio, Data Visualization, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.What is covered in this course?This course covers everything you need to create insightful and dynamic reports using Google Data Studio in the professional work place.Below are the course contents of this complete and concise course on Google Data studio:Introduction - In this section, the structure and the contents of the course are discussed. We also discuss the reason to why should we learn Google Data Studio.Theoretical concepts - This lecture covers the prerequisite understanding of key terminologies and concepts before we start to work on Google Data Studio.All charts and tables in Data Studio - We cover all the available chart types one-by-one. It includes Data tables, scorecards, bar charts, time series, pie charts, GeoMaps, pivot tables and many more.Data filter controls - This lecture covers the filtering options that can be given to the report viewers so that each viewer can filter the data and see only what s/he wants to see.Branding the report - Branding a report is a very popular business practice and we will see how we can do it using brand logo and brand colorsEmbedding external content - We can add videos, quizzes, feedback forms, company websites to our report. Yes! It is possible. We will see how in this section.Blending multiple data sets - Real life data is in multiple tables. To plot a graph using data from multiple tables requires data blending. Very Important Section.Report Sharing and Collaborating - This section covers ways in which you can give viewing or editing rights to others. You can also schedule regular reports to the management using Google Data Studio. Report sharing is something where no other Data Visualization tool can beat Google Data Studio.And so much more!By the end of this course, your confidence in using Google data studio for data visualisation will soar. You'll have a thorough understanding of how to use Google Data Studio for creating insightful dashboards and beautiful reports.Go ahead and click the enroll button, and I'll see you in lesson 1 of this Google Data Studio course!CheersStart-Tech AcademyFAQ'sWhat you can do with Data Studio?Visualize your data through highly configurable charts and tables.Easily connect to a variety of data sources.Share your insights with your team or with the world.Collaborate on reports with your team.Speed up your report creation process with built-in sample reports.Is Google Data Studio free to use?Google Data Studio is offered completely free by Google.What is the use of Google Data Studio?Google Data Studio gives you everything you need to turn your client's analytics data into informational, easy-to-understand reports through data visualization. The reports are easy to read, easy to share and even customizable to each of your clientsThe Authors of this course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of Google Data Studio and Data visualization techniques in today's corporate world.

Overview

Section 1: Introduction

Lecture 1 Course Introduction

Lecture 2 Course Resources

Lecture 3 Why Data Studio?

Lecture 4 This is a milestone!

Section 2: Terminologies & Theoretical concepts for Data Studio

Lecture 5 Data Studio Home Screen & Dataset vs Data Source

Lecture 6 Structure of Input data

Lecture 7 Dimensions vs Measures (new definition)

Section 3: Practical part begins here

Lecture 8 Opening Data Studio

Lecture 9 Adding a data source

Lecture 10 Managing added data source

Section 4: Charts to highlight numbers

Lecture 11 Data Table

Lecture 12 Styling tab for data table

Lecture 13 Scorecards

Section 5: Charts for comparing categories : Bar charts and stacked charts

Lecture 14 Simple Bar and Column chart

Lecture 15 Stacked Column chart

Section 6: Charting maps of a country, continent, or region - Geomaps

Lecture 16 GeoMap

Section 7: Charts to highlight trends: Time Series, Line and Area charts

Lecture 17 Time Series

Lecture 18 Update to Time Series chart

Lecture 19 Line Chart and Combo Chart

Section 8: Highlighting contribution to total: Pie chart & Donut Chart

Lecture 20 Pie Chart and Donut Chart

Lecture 21 Stacked Area Charts

Section 9: Relationship between two or more variables: Scatter plots

Lecture 22 Scatter Plots and Bubble charts

Section 10: Aggregating on two dimensions: Pivot tables

Lecture 23 Pivot tables for cross tabulation

Section 11: All about a single Metric: Bullet Chart

Lecture 24 Bullet Chart

Section 12: Chart for highlighting heirarchy: TreeMap

Lecture 25 TreeMaps

Section 13: Branding a Report

Lecture 26 Branding a Report: Brand Logo and Company Details

Lecture 27 Brand colors for report branding

Section 14: Giving the power to filter Data to viewers

Lecture 28 Filter controls for viewers

Section 15: Add Videos, Feeedback form etc. to your Report

Lecture 29 URL Embed to include external content

Section 16: Sometimes data is in multiple tables

Lecture 30 Blending data from multiple tables

Lecture 31 Different types of Joins while blending data

Section 17: Sharing and Collaborating on Data Studio report

Lecture 32 Downloading report as PDF and Page Management

Lecture 33 Sharing report and Data Credentials

Lecture 34 Sharing report using a link

Lecture 35 Scheduling emails

Lecture 36 Embeding report on Website

Section 18: Google BigQuery Connection

Lecture 37 Connecting and Visualizing Data in Google BigQuery

Section 19: Charting Best Practices

Lecture 38 Highlighting chart message

Lecture 39 Eliminating Distractions from the Graph

Lecture 40 Avoiding clutter

Lecture 41 Avoiding the Spaghetti plot

Lecture 42 The final milestone!

Section 20: Congratulations & about your certificate

Lecture 43 Bonus Lecture

Students who wish to join the field of analytics,Working professionals looking to learn a powerful dashboarding and Data Visualization tool