Skip to content

Campaigns
Free Workshops
Principals
Blog & Resources
Facilities Rental
Team Building

All Courses

Search for:

My Account
- Username:
  Password:
  Remember Me
  Register
Request a Quote
WooCommerce Cart

You are viewing

GCPDI: From Data to Insights with Google Cloud

HRD Corp Claimable

HRD Corp SBL-Khas Claimable

My Account
- Username:
  Password:
  Remember Me
  Register
Request a Quote
WooCommerce Cart

Menu

Principals
All Courses
Campaigns
Free Workshops
Blog & Resources
Modalities
Facilities Rental
My Account

Cart

Search for:

Home » Google Cloud Certified » Smart Analytics & Data Management » GCPDI: From Data to Insights with Google Cloud

GCPDI: From Data to Insights with Google Cloud

Unleash Your Data Potential with Google Cloud Data Analyst courses.

The need for data analysis skills grew by 86% from 2013 to 2018. Become data-driven with Google Cloud. Leverage data and gain real-time insights that improve your decision-making and accelerate innovation. Learn how to design and build data processing systems.

Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Data to Insights in Google Cloud features interactive scenarios and hands-on labs where you can explore, mine, load, visualize, and extract insights from diverse BigQuery datasets.

Fees:

RM7,200.00

Course duration

3 days

Accredited by

Array
(
    [ID] => 8281
    [id] => 8281
    [title] => googlecloud
    [filename] => googlecloud.svg
    [filesize] => 7364
    [url] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
    [link] => https://trainocate.com.my/?attachment_id=8281
    [alt] => Google Cloud Training & Certification
    [author] => 1
    [description] => 
     => Google Cloud training and certifications validate your expertise and showcase your ability to transform businesses with Google Cloud technology.
    [name] => googlecloud
    [status] => inherit
    [uploaded_to] => 2926
    [date] => 2021-08-25 01:59:09
    [modified] => 2021-08-30 01:24:15
    [menu_order] => 0
    [mime_type] => image/svg+xml
    [type] => image
    [subtype] => svg+xml
    [icon] => https://trainocate.com.my/wp-includes/images/media/default.png
    [width] => 200
    [height] => 100
    [sizes] => Array
        (
            [thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [thumbnail-width] => 150
            [thumbnail-height] => 150
            [medium] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [medium-width] => 300
            [medium-height] => 300
            [medium_large] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [medium_large-width] => 768
            [medium_large-height] => 1
            [large] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [large-width] => 1024
            [large-height] => 1024
            [1536x1536] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [1536x1536-width] => 200
            [1536x1536-height] => 100
            [2048x2048] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [2048x2048-width] => 200
            [2048x2048-height] => 100
            [blog-large] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [blog-large-width] => 200
            [blog-large-height] => 100
            [blog-medium] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [blog-medium-width] => 200
            [blog-medium-height] => 100
            [recent-posts] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [recent-posts-width] => 200
            [recent-posts-height] => 100
            [recent-works-thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [recent-works-thumbnail-width] => 66
            [recent-works-thumbnail-height] => 33
            [fusion-200] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [fusion-200-width] => 200
            [fusion-200-height] => 100
            [fusion-400] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [fusion-400-width] => 200
            [fusion-400-height] => 100
            [fusion-600] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [fusion-600-width] => 200
            [fusion-600-height] => 100
            [fusion-800] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [fusion-800-width] => 200
            [fusion-800-height] => 100
            [fusion-1200] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [fusion-1200-width] => 200
            [fusion-1200-height] => 100
            [portfolio-full] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [portfolio-full-width] => 200
            [portfolio-full-height] => 100
            [portfolio-one] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [portfolio-one-width] => 200
            [portfolio-one-height] => 100
            [portfolio-two] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [portfolio-two-width] => 200
            [portfolio-two-height] => 100
            [portfolio-three] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [portfolio-three-width] => 200
            [portfolio-three-height] => 100
            [portfolio-five] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [portfolio-five-width] => 177
            [portfolio-five-height] => 89
            [woocommerce_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [woocommerce_thumbnail-width] => 200
            [woocommerce_thumbnail-height] => 100
            [woocommerce_single] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [woocommerce_single-width] => 200
            [woocommerce_single-height] => 100
            [woocommerce_gallery_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [woocommerce_gallery_thumbnail-width] => 200
            [woocommerce_gallery_thumbnail-height] => 100
        )

)

Home » Google Cloud Certified » Smart Analytics & Data Management » GCPDI: From Data to Insights with Google Cloud

GCPDI: From Data to Insights with Google Cloud

Unleash Your Data Potential with Google Cloud Data Analyst courses.

The need for data analysis skills grew by 86% from 2013 to 2018. Become data-driven with Google Cloud. Leverage data and gain real-time insights that improve your decision-making and accelerate innovation. Learn how to design and build data processing systems.

Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Data to Insights in Google Cloud features interactive scenarios and hands-on labs where you can explore, mine, load, visualize, and extract insights from diverse BigQuery datasets.

Course duration:

3 days

Fees:

RM7,200.00

Accredited by:

Array
(
    [ID] => 8281
    [id] => 8281
    [title] => googlecloud
    [filename] => googlecloud.svg
    [filesize] => 7364
    [url] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
    [link] => https://trainocate.com.my/?attachment_id=8281
    [alt] => Google Cloud Training & Certification
    [author] => 1
    [description] => 
     => Google Cloud training and certifications validate your expertise and showcase your ability to transform businesses with Google Cloud technology.
    [name] => googlecloud
    [status] => inherit
    [uploaded_to] => 2926
    [date] => 2021-08-25 01:59:09
    [modified] => 2021-08-30 01:24:15
    [menu_order] => 0
    [mime_type] => image/svg+xml
    [type] => image
    [subtype] => svg+xml
    [icon] => https://trainocate.com.my/wp-includes/images/media/default.png
    [width] => 200
    [height] => 100
    [sizes] => Array
        (
            [thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [thumbnail-width] => 150
            [thumbnail-height] => 150
            [medium] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [medium-width] => 300
            [medium-height] => 300
            [medium_large] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [medium_large-width] => 768
            [medium_large-height] => 1
            [large] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [large-width] => 1024
            [large-height] => 1024
            [1536x1536] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [1536x1536-width] => 200
            [1536x1536-height] => 100
            [2048x2048] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [2048x2048-width] => 200
            [2048x2048-height] => 100
            [blog-large] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [blog-large-width] => 200
            [blog-large-height] => 100
            [blog-medium] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [blog-medium-width] => 200
            [blog-medium-height] => 100
            [recent-posts] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [recent-posts-width] => 200
            [recent-posts-height] => 100
            [recent-works-thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [recent-works-thumbnail-width] => 66
            [recent-works-thumbnail-height] => 33
            [fusion-200] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [fusion-200-width] => 200
            [fusion-200-height] => 100
            [fusion-400] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [fusion-400-width] => 200
            [fusion-400-height] => 100
            [fusion-600] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [fusion-600-width] => 200
            [fusion-600-height] => 100
            [fusion-800] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [fusion-800-width] => 200
            [fusion-800-height] => 100
            [fusion-1200] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [fusion-1200-width] => 200
            [fusion-1200-height] => 100
            [portfolio-full] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [portfolio-full-width] => 200
            [portfolio-full-height] => 100
            [portfolio-one] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [portfolio-one-width] => 200
            [portfolio-one-height] => 100
            [portfolio-two] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [portfolio-two-width] => 200
            [portfolio-two-height] => 100
            [portfolio-three] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [portfolio-three-width] => 200
            [portfolio-three-height] => 100
            [portfolio-five] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [portfolio-five-width] => 177
            [portfolio-five-height] => 89
            [woocommerce_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [woocommerce_thumbnail-width] => 200
            [woocommerce_thumbnail-height] => 100
            [woocommerce_single] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [woocommerce_single-width] => 200
            [woocommerce_single-height] => 100
            [woocommerce_gallery_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/googlecloud.svg
            [woocommerce_gallery_thumbnail-width] => 200
            [woocommerce_gallery_thumbnail-height] => 100
        )

)

Overview
Course Curriculum
Training Options
Exam & Certification
FAQs

Overview

Data Analysts gather data, analyze that data and translate the results into insights to share with business stakeholders.

Explore ways to derive insights from data at scale using BigQuery, Google Cloud’s serverless, highly scalable, and cost-effective cloud data warehouse. This GCPDI: From Data to Insights with Google Cloud 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.

Skills Covered

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
Audience:

Who Should Attend

This class is intended for the following participants:

Data analysts, business analysts, business intelligence professionals.

Course Curriculum

Prerequisites

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

Basic proficiency with ANSI SQL

Download Syllabus

Download Course Syllabus

Name*

Email*

Phone*

Download Link

Request a callback*

Yes - Please reach out to me

No - That's all for now

This field should be left blank

Course Modules

Expand all Collapse all

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

Avoid Performance Pitfalls with Cache considerations.
Share Dashboards and Discuss Data Access considerations.
Create Case Statements and Calculated Fields.

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.

Request More Information

I'm inquiring for

Myself

My Company

By providing your contact details, you agree to our Privacy Policy

This field should be left blank

Training Options

Filter by:

ILT: Instructor-Led Training
VILT: Virtual Instructor-Led Training

Intake: 27-29 Feb 2024

Duration: 3 Days

Guaranteed: TBC

Modality: ILT

Price:

RM7,200.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Intake: 27-29 Feb 2024

Duration: 3 Days

Guaranteed: TBC

Modality: VILT

Price:

RM7,200.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Intake: 7-9 May 2024

Duration: 3 Days

Guaranteed: TBC

Modality: ILT

Price:

RM7,200.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Intake: 7-9 May 2024

Duration: 3 Days

Guaranteed: TBC

Modality: VILT

Price:

RM7,200.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Intake: 6-8 Aug 2024

Duration: 3 Days

Guaranteed: TBC

Modality: ILT

Price:

RM7,200.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Intake: 6-8 Aug 2024

Duration: 3 Days

Guaranteed: TBC

Modality: VILT

Price:

RM7,200.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Intake: 5-7 Nov 2024

Duration: 3 Days

Guaranteed: TBC

Modality: ILT

Price:

RM7,200.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Intake: 5-7 Nov 2024

Duration: 3 Days

Guaranteed: TBC

Modality: VILT

Price:

RM7,200.00Enroll Now

Exam: Exam fees excluded

Course added

View Quote Page

Exam & Certification

This course is not associated with any Certification.

Training & Certification Guide

Frequently Asked Questions

Stay connected. Be the first to know.

Company

About Us
Blog & Resources
Modalities
Career
Become Our Trainer
Contact Us

Customer Service

My Account
Payment & Policies
PDPA
Copyright & Trademarks

Principals

Microsoft Certified
Red Hat Training
Google Cloud Certified
IBM Education
DELL-EMC
View All

2023 Top 20 IT Training and Technical Company

HRD Corp Training Provider 2

Stay connected. Be the first to know.

2023 Top 20 IT Training and Technical Company

HRD Corp Training Provider 2

No. 1 IT Training Center & Provider in Malaysia

Trainocate is the new and exciting development of the 25-year old establishment – Global Knowledge. The name Trainocate is inspired from the term “Training Advocate” which resonates the feeling of continuous learning, something that each member of the Trainocate team carries with them. We are in the business of empowering work forces in the Asia-Pacific region by maximizing their capabilities through training and certification. This not only helps with improving work performance but also, explores untapped potential within each individual.

Located in KL Eco City and just next to Mid Valley City, Trainocate Malaysia is a HRD Corp Registered Training Provider and Authorized Training Partner for big tech companies such as AWS, Alibaba Cloud, Cisco, Dell EMC, Fortinet, Google Cloud, IBM, Microsoft, NetApp, Nutanix, Oracle, Splunk, Red Hat, Trend Micro, and VMware. We also provide a broad range of human capital development and people skills training to individuals and organizations under American Management Association (AMA).

Years of experience in IT Training Provider Industry equates to bettering ourselves to ensure we deliver only the best training programs to our loyal clients, both in technology and people skills.

© Copyright Trainocate 2024. All rights reserved. IT Training Provider Malaysia