Training Google Cloud

Training goals

code: G-DIGCP

Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Welcome to the Data Insights course! This four-course accelerated online specialization teaches course participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The courses feature interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The courses also cover data loading, querying, schema modeling, optimizing performance, query pricing, and data visualization. This specialization is intended for the following participants: Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform To get the most out of this specialization, we recommend participants have some proficiency with ANSI SQL.

Audience:

Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform.

The course includes presentations, demonstrations, and hands-on labs.

Conspect Show list

  1. Intro to Google Cloud Platform
    • Highlight Analytics Challenges Faced by Data Analysts
    • Compare Big Data On-Premises vs on the Cloud
    • Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud
    • Navigate Google Cloud Platform Project Basics
  2. 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: BigQuery Basics
  3. Exploring your Public Dataset 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: Explore your Ecommerce Dataset with SQL in Google BigQuery
  4. 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: Introducing Cloud Dataprep
    • Lab: Creating a Data Transformation Pipeline with Cloud Dataprep
  5. Visualizing Insights and Creating Scheduled Queries
    • Overview of Data Visualization Principles
    • Exploratory vs Explanatory Analysis Approaches
    • Demo: Google Data Studio UI
    • Connect Google Data Studio to Google BigQuery
    • Lab: How to Build a BI Dashboard Using Google Data Studio and BigQuery
  6. Storing and Ingesting new Datasets
    • Compare Permanent vs Temporary Tables
    • Save and Export Query Results
    • Performance Preview: Query Cache
    • Lab: Ingesting New Datasets into BigQuery
  7. Enriching your Data Warehouse with JOINs
    • 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: Troubleshooting and Solving Data Join Pitfalls
  8. Partitioning your Queries and Tables for Advanced Insights
    • 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: Creating Date-Partitioned Tables in BigQuery
  9. Designing Schemas that Scale: Arrays and Structs in BigQuery
    • 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
    • Lab: Schema Design for Performance: Arrays and Structs in BigQuery
  10. Optimizing Queries for Performance
    • Walkthrough of a BigQuery Job
    • Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs
    • Optimize Queries for Cost
  11. Controlling Access with Data Security Best Practices
    • Data Security Best Practices
    • Controlling Access with Authorized Views
  12. Predicting Visitor Return Purchases with BigQuery ML
    • Intro to ML
    • Feature Selection
    • Model Types
    • Machine Learning in BigQuery
    • Lab: Predict Visitor Purchases with a Classification Model with BigQuery ML
  13. Deriving Insights from Unstructured Data using Machine Learning
    • Structured vs Unstructured ML
    • Prebuilt ML models
    • Lab: Extract, Analyze, and Translate Text from Images with the Cloud ML APIs
    • Lab: Training with Pre-built ML Models using Cloud Vision API and AutoML
  14. Completion
    • Summary and course wrap-up
Download conspect training as PDF

Additional information

Difficulty level
Duration 3 days
Certificate

The participants will obtain certificates signed by Google Cloud Platform.

This course along with the course Data Engineering on Google Cloud Platform additionally prepares you for Professional Data Engineer certification exam available at Kryterion test centers.
Trainer

Authorized Google Cloud Platform Trainer.

Other training Google Cloud | Data Analysis

Google Cloud show more courses
Training thematically related

Cloud

Infinity Specializations | Check Point

  • Download conspect training as PDF: Check Point Certified Cloud Specialist (CCCS)

    Check Point Certified Cloud Specialist (CCCS) training Check Point

    available training dates
    price from: 1100 EUR
    duration: 2 days
    difficulty level: 3 of 6
    code: CP-CCCS
    version: R81.20
    2026-01-20 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-01-20 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-10 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-10 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-10 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-10 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-04-14 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-04-14 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-05 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-05 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-09 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-09 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    Check Point
    Infinity Specializations
    Cloud
    Security
    Security

Cloud-Native (Kubernetes) | Component Soft

OpenStack | Component Soft

Cloud Essentials | CompTIA

Cloud+ | CompTIA

Google Business and Management | Google Cloud

  • recommended training recommended training
    Download conspect training as PDF: Cloud Digital Leader

    Cloud Digital Leader training Google Cloud

    available training dates
    price from: 1000 EUR
    duration: 2 days
    difficulty level: 2 of 6
    code: G-CDL
    version: 2.0
    2026-01-22 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-01-22 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-19 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-19 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-19 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-19 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-04-16 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-04-16 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-21 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-21 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-25 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-25 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    Google Cloud
    Google Business and Management
    Cloud

Fundamentals Courses | Google Cloud

Cloud Infrastructure | Google Cloud

Networking and Security | Google Cloud

Application modernization | Google Cloud

Data Analysis | Google Cloud

Data Engineering | Google Cloud

AI and Machine Learning | Google Cloud

  • Download conspect training as PDF: Machine Learning on Google Cloud

    Machine Learning on Google Cloud training Google Cloud

    available training dates
    price from: 2300 EUR
    duration: 5 days
    difficulty level: 4 of 6
    code: G-MLGC
    version: v4.0
    2025-12-22 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-01-26 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-01-26 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-16 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-16 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-16 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-16 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-11 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-11 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-18 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-18 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-15 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-15 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    Google Cloud
    AI and Machine Learning
    Cloud
    Data analysis

Contact Center Engineer | Google Cloud

Azure | Microsoft

Windows Server Technologies | Microsoft

Cloud Workshop | Microsoft

Microsoft AI | Microsoft

Data Platform | Microsoft

Security | Microsoft

  • Download conspect training as PDF: AZ-500T00-A Microsoft Azure Security Technologies

    AZ-500T00-A Microsoft Azure Security Technologies training Microsoft

    available training dates
    price from: 1900 EUR
    duration: 4 days
    difficulty level: 3 of 6
    code: AZ-500T00
    version: A
    2026-02-24 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-24 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-17 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-17 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-24 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-24 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-04-21 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-04-21 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-19 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-19 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-23 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-23 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    Microsoft
    Security
    Cloud
    Security
    Security

Cloud Security | Mile2

Cloud | SCADEMY

Kubernetes | SUSE

Kubernetes | The Linux Foundation

E-learning | The Linux Foundation

Exam | The Linux Foundation

Bundle (e-learning + exam) | The Linux Foundation

Big Data

Cloudera Administrator | Cloudera

Cloudera Data Analyst | Cloudera

Cloudera Data Developer | Cloudera

  • Download conspect training as PDF: Cloudera Training for Apache Kafka

    Cloudera Training for Apache Kafka training Cloudera

    available training dates
    price from: 3000 EUR
    duration: 4 days
    difficulty level: 4 of 6
    code: CLOUDERA-CTAK
    2026-02-24 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-24 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-24 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-24 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-19 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-19 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-26 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-26 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-23 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-23 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-30 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-30 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    Cloudera
    Cloudera Data Developer
    Big Data
    Data analysis
    DevOps

Data Analysis | Google Cloud

Data Engineering | Google Cloud

Contact Center Engineer | Google Cloud

Microsoft SQL Server | Microsoft

Data analysis

Cloudera Administrator | Cloudera

Cloudera Data Analyst | Cloudera

Cloudera Data Developer | Cloudera

  • Download conspect training as PDF: Cloudera Training for Apache Kafka

    Cloudera Training for Apache Kafka training Cloudera

    available training dates
    price from: 3000 EUR
    duration: 4 days
    difficulty level: 4 of 6
    code: CLOUDERA-CTAK
    2026-02-24 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-24 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-24 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-24 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-19 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-19 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-26 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-26 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-23 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-23 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-30 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-30 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    Cloudera
    Cloudera Data Developer
    Big Data
    Data analysis
    DevOps

Data+ | CompTIA

DataSys+ | CompTIA

Data Analysis | Google Cloud

Data Engineering | Google Cloud

AI and Machine Learning | Google Cloud

  • Download conspect training as PDF: Machine Learning on Google Cloud

    Machine Learning on Google Cloud training Google Cloud

    available training dates
    price from: 2300 EUR
    duration: 5 days
    difficulty level: 4 of 6
    code: G-MLGC
    version: v4.0
    2025-12-22 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-01-26 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-01-26 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-16 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-16 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-16 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-16 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-11 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-11 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-18 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-18 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-15 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-15 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    Google Cloud
    AI and Machine Learning
    Cloud
    Data analysis

Contact Center Engineer | Google Cloud

Power Platform | Microsoft

  • Download conspect training as PDF: PL-300T00 Microsoft Power BI Data Analyst

    PL-300T00 Microsoft Power BI Data Analyst training Microsoft

    available training dates
    price from: 1500 EUR
    duration: 3 days
    difficulty level: 4 of 6
    code: PL-300T00
    2026-01-21 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-01-21 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-18 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-18 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-18 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-18 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-04-15 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-04-15 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-13 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-13 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-17 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-17 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    Microsoft
    Power Platform
    Data analysis

DevOps

Cloudera Administrator | Cloudera

Cloudera Data Analyst | Cloudera

Cloudera Data Developer | Cloudera

  • Download conspect training as PDF: Cloudera Training for Apache Kafka

    Cloudera Training for Apache Kafka training Cloudera

    available training dates
    price from: 3000 EUR
    duration: 4 days
    difficulty level: 4 of 6
    code: CLOUDERA-CTAK
    2026-02-24 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-24 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-24 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-24 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-19 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-19 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-26 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-26 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-23 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-23 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-30 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-30 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    Cloudera
    Cloudera Data Developer
    Big Data
    Data analysis
    DevOps

Cloud-Native (Kubernetes) | Component Soft

OpenStack | Component Soft

Foundation | DevOps Institute

Engineering | DevOps Institute

Leader | DevOps Institute

Site Reliability Engineering | DevOps Institute

Observability | DevOps Institute

AIOps | DevOps Institute

DevSecOps | DevOps Institute

Agile Service Manager | DevOps Institute

Continuous Testing | DevOps Institute

Value Stream Management | DevOps Institute

Fundamentals Courses | Google Cloud

  • recommended training recommended training
    Download conspect training as PDF: Google Cloud Fundamentals: Core Infrastructure

    Google Cloud Fundamentals: Core Infrastructure training Google Cloud

    available training dates
    price from: 600 EUR
    duration: 1 day
    difficulty level: 2 of 6
    code: G-CF:CI
    version: v5.2
    2026-01-12 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-01-12 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-01-22 | Virtual Classroom rabat termin: -600 EUR sign up
    2026-02-02 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-02 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-02 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-02 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-04-13 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-04-13 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-04 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-04 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-08 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-08 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    Google Cloud
    Fundamentals Courses
    Cloud
    DevOps
  • Download conspect training as PDF: Getting Started with Google Kubernetes Engine

    Getting Started with Google Kubernetes Engine training Google Cloud

    available training dates
    price from: 600 EUR
    duration: 1 day
    difficulty level: 3 of 6
    code: G-GSGKE
    version: v2.0
    2025-12-19 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-01-20 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-01-20 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-05 | Virtual Classroom rabat termin: -600 EUR sign up
    2026-02-10 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-02-10 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-10 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-03-10 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-04-14 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-04-14 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-12 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-05-12 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-16 | Kraków / Virtual Classroom HYBRID: hybrid training sign up
    2026-06-16 | Warszawa / Virtual Classroom HYBRID: hybrid training sign up
    Google Cloud
    Fundamentals Courses
    Cloud
    DevOps

Cloud Infrastructure | Google Cloud

Networking and Security | Google Cloud

Application modernization | Google Cloud

Data Analysis | Google Cloud

Data Engineering | Google Cloud

Contact Center Engineer | Google Cloud

Azure | Microsoft

Cloud Workshop | Microsoft

Kubernetes | SUSE

Kubernetes | The Linux Foundation

E-learning | The Linux Foundation

Exam | The Linux Foundation

Bundle (e-learning + exam) | The Linux Foundation

Contact form

Please fill form below to obtain more info about this training.






* Fields marked with (*) are required !!!

Information on data processing by Compendium - Centrum Edukacyjne Spółka z o.o.

TRAINING PRICE FROM 1500 EUR

  • In order to propose a date for this training, please contact the Sales Department

Upcoming Google Cloud training

Training schedule
Google Cloud