From Data to Insights with Google Cloud

Want to familiarize yourself with the fundamental aspects of BigQuery? Learn how derive detailed insights through data analysis and visualization using Google Cloud on this advanced data insights course.

google badge
Book this course
$1,995 ex TAX
3 day course
Partner of the Year
Virtual, Private
Virtual Classroom
A convenient and interactive learning experience, that enables you to attend one of our courses from the comfort of your own home or anywhere you can log on. We offer Virtual Classroom on selected live classroom courses where this will appear as an option under the location drop down if available. These can also be booked as Private Virtual Classrooms for exclusive business sessions.
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 delivered via Virtual Classroom. We also offer it as a private training session that can be delivered virtually or at a location of your choice in the US.

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

Upcoming courses

Mon, Nov 25 2024.Virtual Classroom
From Data to Insights with Google Cloud
$1,995
Mon, Mar 24 2025.Virtual Classroom
From Data to Insights with Google Cloud
$1,995
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