Mastering Data Analysis: Google Sheets, Google Colab, Google Data Studio, Google Apps Script, Data Storytelling

What you will 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.

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:


Get Instant Notification of New Courses on our Telegram channel.


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

English
language

Content

Introduction

Introduction

Google Sheets: Beginnerโ€™s Crash Course for 2023

Introduction
Introduction to Google Sheets
Introduction to Google Sheets Basics
Summary: Introduction to Google Sheets
Importing and Manipulating Data
Google Sheets Data Import, Manipulation, and Organization Quiz
Creating Pivot Tables
Pivot Tables in Google Sheets
Formulas and Functions
Google Sheets Formulas and Functions for Data Analysis Quiz
Data Visualization and Presentation
Data Visualization Best Practices in Google Sheets
Advanced Techniques and Tips
Advanced Google Sheets Techniques Quiz

Google Colab: Beginnerโ€™s Crash Course for 2023

Introduction
Introduction to Google Colab
Introduction to Google Colab
Summary: Introduction to Google Colab
Getting Started with Google Colab
Getting Started with Google Colab for Data Analysis
Summary: Getting Started with Google Colab
Data Manipulation in Google Colab
Data Manipulation in Google Colab
Summary: Data Manipulation in Google Colab
Data Analysis and Visualization in Google Colab
Analyzing and Visualizing Data with Google Colab
Summary: Data Analysis and Visualization in Google Colab
Advanced Techniques in Google Colab
Advanced Techniques in Google Colab
Summary: Advanced Techniques in Google Colab

Google Data Studio (Looker): Beginnerโ€™s Crash Course for 2023

Introduction
Introduction to Google Data Studio (Looker)
Google Data Studio (Looker) Overview Quiz
Summary: Introduction to Google Data Studio (Looker)
Connecting Data Sources
Connecting Data Sources to Google Data Studio (Looker)
Summary: Connecting Data Sources
Creating Reports and Dashboards
Looker Studio Overview
Google Data Studio (Looker) for Report and Dashboard Design
Summary: Creating Reports and Dashboards
Customizing Visualizations
Customizing Charts and Graphs in Google Data Studio (Looker)
Summary: Customizing Visualizations
Advanced Techniques and Tips
Google Data Studio (Looker) Advanced Techniques Quiz
Summary: Advanced Techniques and Tips

Google Apps Scripts: Beginnerโ€™s Crash Course for 2023

Introduction
Introduction to Google Apps Script
Introduction to Google Apps Script
Summary: Introduction to Google Apps Script
Getting Started with Google Apps Script
Getting Started with Google Apps Script
Summary: Getting Started with Google Apps Script
Automating Workflows with Google Apps Script
Automating Workflows with Google Apps Script
Summary: Automating Workflows with Google Apps Script
Building Custom Applications with Google Apps Script
Building Custom Applications with Google Apps Script
Summary: Building Custom Applications with Google Apps Script
Advanced Techniques and Tips for Google Apps Script
Advanced Techniques for Google Apps Script
Summary: Advanced Techniques and Tips for Google Apps Script

Data Storytelling: Beginnerโ€™s Crash Course for 2023

Introduction
Introduction to Data Storytelling
Data Storytelling
Summary: Introduction to Data Storytelling
Gathering and Preparing Data
Mastering Data Preparation and Analysis with Google Sheets
Summary: Gathering and Preparing Data
Visualizing Data
Data Visualization and Google Data Studio Quiz
Summary: Visualizing Data
Creating a Data Story
Creating a Compelling Data Story
Summary: Creating a Data Story
Advanced Techniques and Tips
Advanced Data Storytelling Quiz
Summary: Advanced Techniques and Tips