GB
/
GBP
/
EN_GB

Shaping the future of IT skills

Maximising IT performance through learning

From Data to Insights with Google Cloud Platform

WGAC-GGL-DIGCP

Google
Open

From Data to Insights with Google Cloud Platform

27 Sep 2022 - 3 days

English

GMT UTC+00:00

£1,885

Description

Show Tabs
Introduction
Module 1: Introduction to Data on the Google Cloud Platform
  • Highlight Analytics Challenges Faced by Data Analysts
  • Compare Big Data On-Premise vs on the Cloud
  • Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud
  • Navigate Google Cloud Platform Project Basics
  • Lab: Getting started with Google Cloud Platform
Module 2: Big Data Tools Overview
  • Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools
  • Demo: Analyze 10 Billion Records with Google BigQuery
  • Explore 9 Fundamental Google BigQuery Features
  • Compare GCP Tools for Analysts, Data Scientists, and Data Engineers
  • Lab: Exploring Datasets with Google BigQuery
Module 3: Exploring your Data with SQL
  • Compare Common Data Exploration Techniques
  • Learn How to Code High Quality Standard SQL
  • Explore Google BigQuery Public Datasets
  • Visualization Preview: Google Data Studio
  • Lab: Troubleshoot Common SQL Errors
Module 4: Google BigQuery Pricing
  • Walkthrough of a BigQuery Job
  • Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs
  • Optimize Queries for Cost
  • Lab: Calculate Google BigQuery Pricing
Module 5: Cleaning and Transforming your Data
  • Examine the 5 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
  • Lab: Explore and Shape Data with Cloud Dataprep
Module 6: Storing and Exporting Data
  • Compare Permanent vs Temporary Tables
  • Save and Export Query Results
  • Performance Preview: Query Cache
  • Lab: Creating new Permanent Tables
Module 7: Ingesting New Datasets into Google BigQuery
  • Query from External Data Sources
  • Avoid Data Ingesting Pitfalls
  • Ingest New Data into Permanent Tables
  • Discuss Streaming Inserts
  • Lab: Ingesting and Querying New Datasets
Module 8: Data Visualization
  • Overview of Data Visualization Principles
  • Exploratory vs Explanatory Analysis Approaches
  • Demo: Google Data Studio UI
  • Connect Google Data Studio to Google BigQuery
  • Lab: Exploring a Dataset in Google Data Studio
Module 9: Joining and Merging Datasets
  • Merge Historical Data Tables with UNION
  • Introduce Table Wildcards for Easy Merges
  • Review Data Schemas: Linking Data Across Multiple Tables
  • Walkthrough JOIN Examples and Pitfalls
  • Lab: Join and Union Data from Multiple Tables
Module 10: Advanced Functions and Clauses
  • Review SQL Case Statements
  • Introduce Analytical Window Functions
  • Safeguard Data with One-Way Field Encryption
  • Discuss Effective Sub-query and CTE design
  • Compare SQL and JavaScript UDFs
  • Lab: Deriving Insights with Advanced SQL Functions
Module 11: Schema Design and Nested Data Structures
  • Compare Google BigQuery vs Traditional RDBMS Data Architecture
  • Normalization vs Denormalization: Performance Tradeoffs
  • Schema Review: The Good, The Bad, and The Ugly
  • Arrays and Nested Data in Google BigQuery
  • Lab: Querying Nested and Repeated Data
Module 12: More Visualization with Google Data Studio
  • Create Case Statements and Calculated Fields
  • Avoid Performance Pitfalls with Cache considerations
  • Share Dashboards and Discuss Data Access considerations
Module 13: Optimizing for Performance
  • Avoid Google BigQuery Performance Pitfalls
  • Prevent Hotspots in your Data
  • Diagnose Performance Issues with the Query Explanation map
  • Lab: Optimizing and Troubleshooting Query Performance
Module 14: Data Access
  • Compare IAM and BigQuery Dataset Roles
  • Avoid Access Pitfalls
  • Review Members, Roles, Organizations, Account Administration, and Service Accounts
Module 15: Notebooks in the Cloud
  • Cloud Datalab
  • Compute Engine and Cloud Storage
  • Lab: Rent-a-VM to process earthquakes data
  • Data Analysis with BigQuery
Module 16: How Google does Machine Learning
  • Introduction to Machine Learning for analysts
  • Practice with Pretrained ML APIs for image and text understanding
  • Lab: Pretrained ML APIs
Module 17: Applying Machine Learning to your Datasets (BQML)
  • Building Machine Learning datasets and analyzing features
  • Creating classification and forecasting models with BQML
  • Lab: Predict Visitor Purchases with a Classification Model in BQML
  • Lab: Predict Taxi Fare with a BigQuery ML Forecasting Model
Prerequisites & Audience

To get the most out of this course, participants should have:

  • Basic proficiency with ANSI SQL
Course Benefits

This course teaches participants the following skills:

  • Derive insights from data using the analysis and visualization tools on Google Cloud Platform
  • 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
Course Topics
  • Module 1: Introduction to Data on the Google Cloud Platform
  • Module 2: Big Data Tools Overview
  • Module 3: Exploring your Data with SQL
  • Module 4: Google BigQuery Pricing
  • Module 5: Cleaning and Transforming your Data
  • Module 6: Storing and Exporting Data
  • Module 7: Ingesting New Datasets into Google BigQuery
  • Module 8: Data Visualization
  • Module 9: Joining and Merging Datasets
  • Module 10: Advanced Functions and Clauses
  • Module 11: Schema Design and Nested Data Structures
  • Module 12: More Visualization with Google Data Studio
  • Module 13: Optimizing for Performance
  • Module 14: Data Access
  • Module 15: Notebooks in the Cloud
  • Module 16: How Google does Machine Learning
  • Module 17: Applying Machine Learning to your Datasets (BQML)

Google courses


Cloud Digital Leader
CODE: WGAC-GGL-CDL
Data Integration with Cloud Data Fusion
CODE: WGAC-GGL-DICDF
Preparing for Your Professional Cloud Network Engineer Journey
CODE: WGAC-GGL-PYPCNEJ
Deploying and Managing Windows Workloads on Google Cloud
CODE: WGAC-GGL-DMWWGC
Installing and Managing Google Cloud's Apigee API Platform for Private Cloud
CODE: WGAC-GGL-IMAPIPC
Customer Experiences with Contact Center AI - Dialogflow CX
CODE: WGAC-GGL-CCAIDCX
Customer Experiences with Contact Center AI - Dialogflow ES
CODE: WGAC-GGL-CCAIDES
Application Development with Cloud Run
CODE: WGAC-GGL-ADCR
Serverless Data Processing with Dataflow
CODE: WGAC-GGL-SDPF
Developing Data Models with LookML
CODE: WGAC-GGL-DDMLML
Analyzing and Visualizing Data with Looker
CODE: WGAC-GGL-AVDL
Machine Learning on Google Cloud
CODE: WGAC-GGL-MLGC
Developing APIs with Google Cloud's Apigee API platform
CODE: WGAC-GGL-T-APIENG-B
Managing Google Cloud's Apigee API Platform for Hybrid Cloud
CODE: WGAC-GGL-T-APIHYB-B
Logging, Monitoring, and Observability in Google Cloud
CODE: WGAC-GGL-LMOGC
Security in Google Cloud Platform
CODE: WGAC-GGL-SGCP-3D
Google Cloud Fundamentals for Azure Professionals
CODE: WGAC-GGL-GCPAZURE
Preparing for the Associate Cloud Engineer Examination
CODE: WGAC-GGL-PPACE
Architecting Hybrid Cloud Infrastructure with Anthos
CODE: WGAC-GGL-T-AHYBRID-I
Architecting with Google Kubernetes Engine
CODE: WGAC-GGL-AGKE
Architecting with Google Compute Engine
CODE: WGAC-GGL-AGCE
Preparing for the Professional Data Engineer Examination
CODE: WGAC-GGL-PPDEE
Networking in Google Cloud Platform
CODE: WGAC-GGL-NGCP
Preparing for the Professional Cloud Architect Examination
CODE: WGAC-GGL-PPCAE
Getting Started with Google Kubernetes Engine
CODE: WGAC-GGL-GCP-GSGKE
Google Cloud Platform Fundamentals for AWS Professionals
CODE: WGAC-GGL-GCP-FAP
Developing Applications with Google Cloud Platform
CODE: WGAC-GGL-DAGCP
From Data to Insights with Google Cloud Platform
CODE: WGAC-GGL-DIGCP
Data Engineering on Google Cloud Platform
CODE: WGAC-GGL-DEGCP
Google Cloud Fundamentals: Big Data and Machine Learning
CODE: WGAC-GGL-GCF-BDM
Architecting with Google Cloud Platform: Design and Process
CODE: WGAC-GGL-AGCP-DP
Google Cloud Fundamentals: Core Infrastructure
CODE: WGAC-GGL-GCF-CI
We use cookies to understand how you use our site and to improve your experience. To learn more, click here. Read our revised Privacy Policy and Terms and Conditions.