From Data to Insights with Google Cloud Platform

PT25145
Training Summary
Explore ways to derive insights from data at scale using BigQuery, Google Cloud’s serverless, highly scalable, and cost-effective cloud data warehouse. This course uses lectures, demos, and hands-on labs to teach you the fundamentals of BigQuery, including how to create a data transformation pipeline, build a BI dashboard, ingest new datasets, and design schemas at scale.
Prerequisites
Before taking this course, student should have basic proficiency with ANSI SQL.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for Data Analysts, Business Analysts, Business Intelligence professionals, and Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform.
Course Topics
  • Introduction to Data on Google Cloud
  • Analyzing Large Datasets with BigQuery
  • Exploring your Public Dataset with SQL
  • Cleaning and Transforming your Data with Dataprep
  • Visualizing Insights and Creating Scheduled Queries
  • Storing and Ingesting New Datasets
  • Enriching your Data Warehouse with JOINs
  • Advanced Features and Partitioning your queries and Tables for Advanced Insights
  • Designing Schemas that Scale: Arrays and Structs in BigQuery
  • Optimizing Queries for Performance
  • Controlling Access with Data Security
  • Predicting Visitor Return Purchase with BigQuery ML
  • Deriving Insights from Unstructured Data Using Machine Learning

Related Scheduled Courses