From Data to Insights with Google Cloud

Learn how to derive insights through data analysis and visualization using Google Cloud on this three-day advanced data insights course.
product
google badge
3 day course
Supporting material
Google Cloud Partner of the Year
Private
Private
A private training session for your team. Groups can be of any size, at a location of your choice including our training centres.

As a Google Cloud Partner, Jellyfish has been chosen to facilitate this three-day course, where you’ll learn how to query and process data, perform data analysis, and work with insights from diverse Google BigQuery datasets.

Through a combination of lectures, demonstrations and hands-on exercises, we’ll show how to derive insights through data analysis and visualization using Google Cloud. You’ll participate in interactive scenarios and hands-on labs where you’ll explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets.

The session will cover BigQuery fundamentals, including how to create a data transformation pipeline, build a BI dashboard, ingest new datasets, and design schemas at scale.

Our From Data to Insights with Google Cloud course is available as a private training session that can be delivered via Virtual Classroom or at a location of your choice in India.

Course overview

Who should attend:

This course is intended for data analysts, business analysts and business intelligence professionals. Cloud data engineers partnering with data analysts to build scalable data solutions on Google Cloud will also benefit from attending.

What you'll learn:

By the end of this course, you will be able to:

  • Derive insights from data using the analysis and visualization tools on Google Cloud
  • Load, clean, and transform data at scale with Google Cloud Dataprep
  • Explore and visualize data using Google Data Studio
  • Troubleshoot, optimize, and write high-performance queries
  • Practice with pre-built ML APIs for image and text understanding
  • Train classification and forecasting ML models using SQL with BQML

Prerequisites

To get the most out of this course, you should have basic proficiency with ANSI SQL.

Course agenda

Module 1: Introduction to Google Cloud
  • Highlight Analytics challenges faced by data analysts
  • Compare Big Data on-premises vs. on the Cloud
  • Learn from real-world use cases of companies transformed through Analytics on the Cloud
  • Navigate Google Cloud project basics
Module 2: Analyzing Large Datasets with BigQuery
  • Walk through data analyst tasks, challenges, and introduce Google Cloud Data Tools
  • Demo: Analyze 10 billion records with Google BigQuery
  • Explore fundamental Google BigQuery features
  • Compare GC tools for analysts, data scientists, and data engineers
Module 3: Exploring your Public Dataset with SQL
  • Compare common data exploration techniques
  • Identify the key components of a basic SQL SELECT statement and common pitfalls
  • Discuss the basics of SQL functions and how they create calculated fields with input parameters
  • Explore Google BigQuery public datasets
  • Visualization Preview: Google Data Studio
Module 4: Cleaning & Transforming your Data with Cloud Dataprep
  • Examine the five principles of Dataset Integrity
  • Characterize dataset shape and skew
  • Clean and transform data using SQL
  • Clean and transform data using a new UI: Introducing Cloud Dataprep
Module 5: Visualizing Insights & Creating Scheduled Queries
  • Overview of data visualization principles
  • Common data visualisation pitfalls
  • Looker Studio
Module 6: Storing & Ingesting New Datasets
  • Compare permanent vs. temporary tables
  • Ingesting new datasets
Module 7: Enriching your Data Warehouse with JOINs
  • Merge historical data tables with UNION
  • Introduce table wildcards for easy merges
  • Review data schemas: Linking data across multiple tables
  • Walk through JOIN Examples and Pitfalls
Module 8: Advanced Features & Partitioning your Queries & Tables for Advanced Insights
  • Advanced functions (statistical, analytics, user-defined)
  • Date-partitioned tables
Module 9: Designing Schemas that Scale: Arrays & Structs in BigQuery
  • Compare Google BigQuery vs. Traditional Relational data architecture
  • ARRAY and STRUCT syntax
  • BigQuery architecture
Module 10: Optimizing Queries for Performance
  • BigQuery performance pitfalls
  • Prevent data hotspots
  • Diagnose performance issues with the query explanation map
Module 11: Controlling Access with Data Security Best Practices
  • Hashing columns
  • Controlling access with authorized views
  • IAM and BigQuery dataset roles
  • Highlight key data access pitfalls
Module 12: Predicting Visitor Return Purchases with BigQuery ML
  • How does ML on structured data drive value?
  • Describe how customer LTV can be predicted with an ML model
  • Choose the right model type
  • Creating ML models with SQL
Module 13: Deriving Insights from Unstructured Data using Machine Learning
  • How does ML on unstructured data work?
  • Choosing the right ML approach
  • Pre-built AI building blocks
  • Customizing pre-built models with AutoML
  • Building a custom model
Book this course
Call our sales team today
close
Don't miss out
Keep up to date with news, views and offers from Jellyfish Training.
Your data will be handled in accordance with our Privacy Policy