- Mastering Data Analysis: Google Sheets, Google Colab, Google Data Studio, Google Apps Script, Data Storytelling
- Free tutorial
- Rating: 3.0 out of 53.0 (3 ratings)
- 811 students
- 1hr 44min of on-demand video
- Created by Larry G
- English
What you’ll learn
- Use various Google tools and platforms for data analysis, visualization, and communication.
- Use Google Sheets for data analysis, including importing and manipulating data, creating pivot tables, using formulas and functions, and presenting data.
- Use Google Colab, a cloud-based platform for Python programming, for data manipulation, analysis, and visualization.
- Use Google Data Studio (Looker) to create reports and dashboards, connect data sources, customize visualizations, and use advanced techniques to analyze data.
- Use Google Apps Script, a scripting language for automating and extending the functionality of various Google products.
- Use Google tools and platforms for data analysis and communication, from basic data manipulation to advanced visualization and automation techniques.
- Apply skills to real-world data analysis and communication scenarios.
Requirements
- Basic computer literacy, including knowledge of how to use a keyboard and mouse, navigate the internet, and manage files and folders.
- Familiarity with the software or tools used in the course.
- A fundamental understanding of the course subject matter.
- Access to required equipment, such as a computer or internet connection.
Description
In this comprehensive course, you will learn how to leverage Google’s powerful suite of tools to improve your data analysis skills and become a more effective data analyst.
We will start with an introduction to Google Sheets, where you’ll learn the basics of the interface and how to set up your data for analysis. Then we will move on to Google Colab, where you’ll discover how to use this powerful tool to write and execute Python code in a browser-based environment.
Next, we will dive into Google Data Studio (Looker), a data visualization tool that allows you to create interactive reports and dashboards to communicate insights from your data. You’ll learn best practices for report and dashboard design, how to add interactive features to your reports, and how to customize visualizations to tell a compelling data story.
We’ll also cover Google Apps Script, which will teach you how to automate repetitive tasks and streamline your workflow using custom scripts and add-ons.
Finally, we will explore the art of data storytelling, where you’ll learn how to effectively communicate your data insights to your audience and make a meaningful impact with your analysis.
By the end of this course, you’ll have a complete toolkit of Google products and skills to become a proficient data analyst and enhance your ability to make data-driven decisions.
Module 1 Description:
In this module, you will learn how to use Google Sheets as a powerful tool for data analysis. Google Sheets offers a wide range of functions and features that can help you manipulate and analyze data more efficiently. Whether you are new to data analysis or looking to expand your skills, this module will provide you with a strong foundation in using Google Sheets for data analysis. You will learn how to import and manipulate data, create pivot tables, and use formulas and functions to analyze data. You will also learn best practices for organizing and presenting data in a clear and effective manner.
Module Outline:
Lesson 1: Introduction to Google Sheets
Lesson 2: Importing and Manipulating Data
Lesson 3: Creating Pivot Tables
Lesson 4: Formulas and Functions
Lesson 5: Data Visualization and Presentation
Lesson 6: Advanced Techniques and Tips
Module Goals:
- Understand the basics of using Google Sheets for data analysis
- Learn how to import and manipulate data effectively
- Master the use of Pivot Tables for data analysis
- Understand formulas and functions and use them effectively for data analysis
- Create clear and effective data visualizations and presentations
- Learn advanced techniques and tips for using Google Sheets more efficiently and troubleshooting common issues.
Module 2 Description:
Google Colab is a free, cloud-based platform that allows users to write and execute Python code in a collaborative environment. It is becoming increasingly popular among data analysts and data scientists for its ability to perform complex tasks using a web browser. In this module, you will learn how to use Google Colab to manipulate, analyze, and visualize data in a collaborative environment.
Module Outline:
Lesson 1: Introduction to Google Colab
Lesson 2: Getting Started with Google Colab
Lesson 3: Data Manipulation in Google Colab
Lesson 4: Data Analysis and Visualization in Google Colab
Lesson 5: Advanced Techniques in Google Colab
Module Goals:
- Understand the key features and benefits of Google Colab
- Set up and navigate the Google Colab interface
- Import and manipulate data in Google Colab
- Perform data analysis and visualization in Google Colab
- Use advanced techniques in Google Colab, including machine learning and collaborative coding
Module 3 Description:
This online module is designed for data analysts who want to learn how to use Google Data Studio (Looker) to create compelling data visualizations and dashboards. In this module, you will learn how to connect your data sources, create reports and dashboards, customize visualizations, and use advanced techniques and tips to analyze and present your data effectively.
Module Outline:
Lesson 1: Introduction to Google Data Studio (Looker)
Lesson 2: Connecting Data Sources
Lesson 3: Creating Reports and Dashboards
Lesson 4: Customizing Visualizations
Lesson 5: Advanced Techniques and Tips
By the end of this module, you will have a solid understanding of how to use Google Data Studio (Looker) to create professional-grade reports and dashboards that effectively communicate your data insights.
Module 4 Description:
Google Apps Script is a scripting language that allows you to automate and extend the functionality of various Google apps, including Google Sheets, Google Docs, and Google Forms. In this module, you will learn how to use Google Apps Script to create custom functions, automate workflows, and build custom applications that interact with Google apps. You will also learn best practices for writing efficient and effective code, as well as how to troubleshoot common issues.
Module Outline:
Lesson 1: Introduction to Google Apps Script
Lesson 2: Getting Started with Google Apps Script
Lesson 3: Automating Workflows with Google Apps Script
Lesson 4: Building Custom Applications with Google Apps Script
Lesson 5: Advanced Techniques and Tips for Google Apps Script
By the end of this module, you will have the skills and knowledge needed to use Google Apps Script to automate workflows, build custom applications, and extend the functionality of various Google apps. You will also have a strong understanding of best practices for writing efficient and effective code.
Module 5 Description:
This module is designed to help data analysts master the art of data storytelling using various Google tools. In this module, you will learn how to turn raw data into compelling narratives and present them in a visually appealing and engaging way. You will learn how to use Google Sheets, Google Data Studio (Looker), and other Google tools to create dynamic visualizations and dashboards that communicate insights effectively. You will also learn best practices for data visualization and storytelling, and how to incorporate storytelling techniques into your data analysis process.
Module Outline:
Lesson 1: Introduction to Data Storytelling
Lesson 2: Gathering and Preparing Data
Lesson 3: Visualizing Data
Lesson 4: Creating a Data Story
Lesson 5: Advanced Techniques and Tips
Who this course is for:
- This course is designed for individuals who are interested in developing their skills in data analysis and visualization.
- Learners who want to acquire knowledge in statistical analysis, data manipulation, and data visualization using popular tools like Python and Tableau will find this course valuable.
- This course is suitable for beginners who have no prior experience in data analysis, as well as those who want to expand their knowledge in this field.
- This course is ideal for students, researchers, analysts, and professionals who want to use data analysis and visualization to improve decision-making, solve complex problems, and gain insights from data.
- Anyone who works with data or wants to work with data, such as data scientists, data analysts, business analysts, market researchers, and marketing professionals will find this course helpful in enhancing their skills and knowledge.
Show less
Course content
6 sections • 54 lectures • 1h 43m total lengthCollapse all sections
Introduction1 lecture • 1min
- Introduction01:15
Google Sheets: Beginner’s Crash Course for 20238 lectures • 19min
- Introduction00:48
- Introduction to Google Sheets02:29
- Introduction to Google Sheets Basics10 questions
- Summary: Introduction to Google Sheets00:29
- Importing and Manipulating Data02:42
- Google Sheets Data Import, Manipulation, and Organization Quiz5 questions
- Creating Pivot Tables02:00
- Pivot Tables in Google Sheets5 questions
- Formulas and Functions03:50
- Google Sheets Formulas and Functions for Data Analysis Quiz10 questions
- Data Visualization and Presentation03:20
- Data Visualization Best Practices in Google Sheets5 questions
- Advanced Techniques and Tips03:19
- Advanced Google Sheets Techniques Quiz5 questions
Google Colab: Beginner’s Crash Course for 202311 lectures • 20min
- Introduction00:38
- Introduction to Google Colab03:22
- Introduction to Google Colab5 questions
- Summary: Introduction to Google Colab00:29
- Getting Started with Google Colab02:30
- Getting Started with Google Colab for Data Analysis7 questions
- Summary: Getting Started with Google Colab00:59
- Data Manipulation in Google Colab03:16
- Data Manipulation in Google Colab10 questions
- Summary: Data Manipulation in Google Colab00:59
- Data Analysis and Visualization in Google Colab03:12
- Analyzing and Visualizing Data with Google Colab5 questions
- Summary: Data Analysis and Visualization in Google Colab00:50
- Advanced Techniques in Google Colab03:16
- Advanced Techniques in Google Colab4 questions
- Summary: Advanced Techniques in Google Colab00:22
Google Data Studio (Looker): Beginner’s Crash Course for 202312 lectures • 27min
- Introduction00:48
- Introduction to Google Data Studio (Looker)03:25
- Google Data Studio (Looker) Overview Quiz5 questions
- Summary: Introduction to Google Data Studio (Looker)00:42
- Connecting Data Sources03:03
- Connecting Data Sources to Google Data Studio (Looker)10 questions
- Summary: Connecting Data Sources00:56
- Creating Reports and Dashboards03:29
- Looker Studio Overview06:03
- Google Data Studio (Looker) for Report and Dashboard Design5 questions
- Summary: Creating Reports and Dashboards01:01
- Customizing Visualizations02:58
- Customizing Charts and Graphs in Google Data Studio (Looker)5 questions
- Summary: Customizing Visualizations00:24
- Advanced Techniques and Tips02:51
- Google Data Studio (Looker) Advanced Techniques Quiz7 questions
- Summary: Advanced Techniques and Tips00:58
Google Apps Scripts: Beginner’s Crash Course for 202311 lectures • 17min
- Introduction00:48
- Introduction to Google Apps Script03:33
- Introduction to Google Apps Script5 questions
- Summary: Introduction to Google Apps Script00:27
- Getting Started with Google Apps Script02:59
- Getting Started with Google Apps Script4 questions
- Summary: Getting Started with Google Apps Script00:16
- Automating Workflows with Google Apps Script02:13
- Automating Workflows with Google Apps Script5 questions
- Summary: Automating Workflows with Google Apps Script00:22
- Building Custom Applications with Google Apps Script02:24
- Building Custom Applications with Google Apps Script5 questions
- Summary: Building Custom Applications with Google Apps Script00:22
- Advanced Techniques and Tips for Google Apps Script02:34
- Advanced Techniques for Google Apps Script5 questions
- Summary: Advanced Techniques and Tips for Google Apps Script00:53
Data Storytelling: Beginner’s Crash Course for 202311 lectures • 20min
- Introduction00:52
- Introduction to Data Storytelling03:36
- Data Storytelling5 questions
- Summary: Introduction to Data Storytelling00:23
- Gathering and Preparing Data02:39
- Mastering Data Preparation and Analysis with Google Sheets5 questions
- Summary: Gathering and Preparing Data00:23
- Visualizing Data04:24
- Data Visualization and Google Data Studio Quiz5 questions
- Summary: Visualizing Data00:25
- Creating a Data Story03:10
- Creating a Compelling Data Story5 questions
- Summary: Creating a Data Story00:26
- Advanced Techniques and Tips03:28
- Advanced Data Storytelling Quiz4 questions
- Summary: Advanced Techniques and Tips00:23
