Featured resource
2026 Tech Forecast
2026 Tech Forecast

1,500+ tech insiders, business leaders, and Pluralsight Authors share their predictions on what’s shifting fastest and how to stay ahead.

Download the forecast

Intermediate Google Cloud For Data Analysts

Course Summary

The Intermediate Google Cloud for Data Analysts training course is designed to advance the skills and knowledge of particpants already familiar wirth data analysis using Google Cloud to the more advanced features and functionality, including predictive, transactional, and large scale distributed data analytics. The course begins using the MapReduce-based, batch data analysis tools available as managed infrastructure services on Google Cloud, including Apache Hive, Apache Pig, and PySpark. Next, participants will use Apache Beam to analyze both batch and streaming data using a single data pipeline. The course concludes by preparing participants to perform data analysis operations commonly used in predictive analytics and machine learning, including feature creation and feature pre-processing.

Prerequisites:

  • Experience using Google Cloud for structured data analysis
  • Effective use of SQL for data analysis use cases
Purpose
Learn how to analyze large scale, distributed, and real-time datasets with MapReduce and Apache Beam based capabilities of Google Cloud and practice identification and analysis of effective data features for predictive analytics with BigQuery ML and TensorFlow
Audience
Developers using Google Cloud who need to take their MapReduce and Apache Beam capabilities to the next level
Role
Business Analyst - Data Engineer | Data Scientist | Software Developer | Technical Manager
Skill Level
Intermediate
Style
Lecture | Hands-on Activities | Labs
Duration
2 Days
Related Technologies
MySQL | BigQuery | Hadoop | Google Cloud | Tensorflow | Apache

 

Learning Objectives
  • Employ DataProc to perform MapReduce based data analysis
  • Integrate transactional data from a Cloud SQL database in data analysis
  • Apply Apache Beam based data analysis pipelines for batch and streaming data
  • Support data science and machine learning through analysis of effective data features
  • Use Google Colab and Jupyter notebooks for Python based data analysis

What You'll Learn:

In the Intermediate Google Cloud For Data Analysts training course, you'll learn:

MapReduce for Data Analysts

  • Map vs. FlatMap for MapReduce
  • Running Apache Hive, Apache Pig, and PySpark
  • Provisioning Managed Apache Hadoop/Spark/YARN Infrastructure
  • Pre-Emptible Instances for MapReduce
  • Dataproc User Interface
  • Running and Monitoring MapReduce Jobs

Cloud SQL

  • Transactional Data for Analysis
  • Provisioning Managed Database Infrastructure
  • Configuration of MySQL on GCP
  • Batch Data Import/Export with Cloud SQL
  • Web-based Interface
  • Integration of MySQL with GCP Services and Applications
  • Recommendation Systems with Cloud SQL

Apache Beam for Data Analysts

  • Batch and Streaming Data Processing Pipelines
  • Run Apache Beam in Cloud Shell
  • Apache Beam Combine vs. GroupBy
  • Submitting Apache Beam Pipelines
  • Running Batch and Streaming Dataflow Jobs
  • Apache Beam Pipelines with Side-Inputs
  • Autoscaling Streaming Apache Beam Jobs
  • Apache Beam Windows and Triggers
  • Web-based and Command Line Interface
  • Monitoring Dataflow Jobs

Jupyter for Data Analysis

  • Google Colab
  • BigQuery from Colab
  • Pandas DataFrames and Series
  • GroupBy and Pivot Table
  • Data visualization with Seaborn
  • Predictive Analytics with TensorFlow

Data Analytics for Data Science

  • Five Criteria for Effective Data Features
  • Feature Engineering Case Studies and Best Practices
  • Feature Crosses, Quantization, One-hot Encoding
  • Feature Creation and Pre-processing in a Machine Learning Pipeline
  • Feature Engineering for Wide-and-Deep Models
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By clicking submit, you agree to our Privacy Policy and Terms of Use, and consent to receive marketing emails from Pluralsight.