- Course overview
- Course details
- Prerequisites
Course overview
About this course
This course teaches participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The course features interactive scenarios 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, and data visualization.
Audience
-
Data Analyst professionals
-
Business Analyst professionals
-
Business Intelligence professionals
-
Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform
Course details
Module 1: Introduction to From Data to Insights with Google Cloud
• Highlight Analytics Challenges Faced by Data Analysts
• Compare Big Data On-Premises vs on the Cloud
• Analytics Transformation Case Studies
• Navigate Google Cloud Platform Project Basics
Module 2: Big Data Tools Overview
• Overview of Data Analyst Tasks and GCP Tools
• Demo: Analyze 10 billion Records with Google Big Query
• Explore 9 Fundamental Google Big Query Features
• Compare GCP Tools for Analysts, Data Scientists, and Data Engineers
• Lab: Exploring Datasets with Google Big Query
Module 3: Exploring Your Data with SQL
• Compare Common Data Exploration Techniques
• Learn How to Code High Quality Standard SQL
• Explore Google Big Query Public Datasets
• Visualization Preview: Google Data Studio
Module 4: Cleaning and Transforming Your Data
• Examine the 5 Principles of Dataset Integrity
• Characterize Dataset Shape and Skew
• Clean and Transform Data using SQL
• Introducing Cloud Data prep
Module 5: Ingesting New Datasets into Google Big Query
• Query from External Data Sources
• Avoiding Data Ingesting Pitfalls
Prerequisites
- Basic proficiency with ANSI SQL
Enquiry
Course : From Data to Insights with Google Cloud
Enquiry
request for : From Data to Insights with Google Cloud
