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.
Request Course Information
What you’ll learn
This course teaches participants the following skills:
Derive insights from data using the analysis and visualisation tools on Google Cloud
Load, clean, and transform data at scale with Dataprep
Explore and visualise data using Locker Studio
Troubleshoot, optimise, 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 BigQuery ML
Google Cloud at Lumify Work
Lumify Work is Australia's only national Google Cloud Authorised Training Partner. Get the skills needed to build, test, and deploy applications on this highly scalable infrastructure. Engineered to handle the most data-intensive work you can throw at it, Lumify Work can support you through training wherever you are in your Cloud adoption journey.
Module 9: Designing Schemas that Scale: Arrays and Structs in BigQuery
BigQuery Versus Traditional Relational Data Architecture
ARRAY and STRUCT Syntax
BigQuery Architecture
Module 10: Optimising 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
Authorised Views
IAM and BigQuery Dataset Roles
Access Pitfalls
Module 12: Predicting Visitor Return Purchases with BigQuery ML
Machine Learning on Structured Data
Scenario: Predicting Customer Lifetime Value
Choosing the Right Model Type
Creating ML models with SQL
Module 13: Deriving Insights From Unstructured Data Using Machine Learning
ML Drives Business Value
How does ML on Unstructured Data Work?
Choosing the Right ML Approach
Pre-built AI Building Blocks
Customising Pre-built Models with AutoML
Building a Custom Model
Prerequisites
To get the most out of this course, participants should have:
Basic proficiency with ANSI SQL
FREE E-BOOK: The New Era of Cloud Computing
We've created this e-book to assist you on your cloud journey, from defining the optimal cloud infrastructure and choosing a cloud platform, to security in the cloud and the core challenges in moving to the cloud.
The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.
Request Course Information
Personalise your schedule with Lumify USchedule
Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.