In this course, you will learn how to derive insights through data analysis and visualization using the Google Cloud Platform. The course features interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The course covers data loading, querying, schema modeling, optimizing performance, query pricing, data visualization, and machine learning.
Học phí: 14,100,000 VND
After completing the course, students will have the following knowledge:
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.
Analyzing Large Datasets with BigQuery
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.
Exploring your Public Dataset with SQL
Compare Common Data Exploration Techniques.
Learn How to Code High Quality Standard SQL.
Explore Google BigQuery Public Datasets.
Lab: Troubleshoot Common SQL Errors.
Cleaning and Transforming your Data with Cloud Dataprep
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:UX
Introducing Cloud Dataprep
Visualizing Insights and Creating Scheduled Queries
Overview of Data Vizualization principles
Exploratory and Explanatory analysis approaches
Demo: Comment Data Vizalization pitfalls
Connect Google Data Studio to Google BigQuery.
Storing and Ingesting new Datasets
Compare Permanent vs Temporary Tables
Save and Export Query Results
Ingesting new datasets
Enriching your Data Warehouse with JOINs
Merge Historical Data Tables with UNION.
Introduce table Wildcards for easy merges
Review Data Schemas: Linking Data Across Mutiple tables
Walkthrough JOIN Example and pitfalls
Partitioning your Queries and Tables for Advanced Insights
Introduce Advanced Functions (Statistical, Analytic, User-Defined)
Designing Schemas that Scale: Arrays and Structs in BigQuery
Compare Google BigQuery vs Traditional
Relational Data Architecture.
Demo: Nested and Repeated Fields
Review ARRAY and STRUCT syntax.
Optimizing Queries for Performance
Avoid BigQuery Performance Pitfalls
Prevent Hotspots in your Data
Diagnose Performance Issues with the Query
Controlling Access with Data Security Best Practices
Safeguard Data with One-way Field Encryption.
Creating Authorized Views
Compare IAM and BigQuery Dataset Roles.
Avoid Access Pitfalls
Review Members, Roles, Organiztions, Account Administration and Service Accounts
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
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.
Using Pre-built AI to create a chatbot.
Customizing Pre-built models with AutoML.
Building a custom model
Google Cloud expert
Cloud Ace Training
Bringing great experiences to students
Trần Tuấn Anh
Nguyễn Ngọc Minh Thy
Trương Quốc Thắng
Phạm Văn Hùng
Dương Minh Phương
TO BECOME " GOOGLE CLOUD EXPERT"
câu hỏi thường gặp
Cloud Ace is a Google Cloud training unit, so it does not organize exams and provide Google Cloud certifications. Cloud Ace only supports providing certificates of course completion for students while waiting for the Google Cloud certification exam
In addition, if you want to take the Google Cloud certification exam, Cloud Ace will guide you to register for the Online or Offline exam at the authorized Google Cloud test centers in Vietnam.
Of course, during the learning process, you will constantly be solving quizzes, simulated mock tests that are similar to Google Cloud's actual exam questions. In addition, Cloud Ace also provides Dump questions that are constantly updated with question types, exam questions from Google Cloud to help you have the best preparation for the exam.
Of course. You will be supported by Cloud Ace during the learning process and even at the end of the course. You can interact with the Trainer via Slack, email hoặc qua Group Google Cloud Plartform User HCM để được các Trainer hỗ trợ nhé.
After completing the course, if you have any questions about the knowledge or have difficulties in implementing the project on Google Cloud, you can contact the Trainer for answers.
The Google Cloud course is not only suitable for software engineers or system development engineers, but also suitable for data processing engineers such as Data Analytics, Data Engineer, Data Scientist.
In addition, if you are a Marketer or working in the field of finance, banking, e-commerce, logistics .... constantly faced with big data to solve, then you can refer to the courses Big Data Machine Learning Fundamental or From Data to Insight on Google Cloud Platform courses to refer to simple data processing and create professional reports on Google Cloud.