Google Cloud for Data Analysts

The Google Cloud for Data Analysts training course is designed to get beginner data analysts, SQL developers, and software engineers started with using Google Cloud for insightful, scalable, and responsive data analysis and impactful data visualization.

This course will begin with learning about the BigQuery serverless data warehouse on Google Cloud and understand the advantages of using columnar vs. row-based data stores for effective structured data analysis. After reviewing key SQL concepts for popular data analysis use cases, students will learn how to import data into BigQuery and how to ensure data quality once it has been imported.

Next, students will learn how to improve the performance of the data analysis SQL queries by exploring how optimizations for columnar data stores with table partitions differ from traditional normalization/denormalization techniques in relational databases. Students will also learn about more advanced SQL 2011 standard features such as arrays and structs for semi-structured data analysis.

The remainder of the course will cover Data Studio for building effective and actionable dashboards based on the results of your analysis. Students will learn how to create and share BigQuery-based reports and to ensure that the reports are shared safely with role-based access control and row-level access security. The course also delves into working with BigQuery ML for predictive analytics to generate experimental regression and classification models with sample datasets.

Course Summary

Purpose: 
Learn how to perform insightful and responsive data analysis at scale and delight the consumers of the analysis with effective data visualizations.
Audience: 
Beginner data analysts and SQL developers who have some experience with relational databases like Oracle, SQL Server, MySQL or PostgreSQL.
Skill Level: 
Learning Style: 

Hands-on training is customized, instructor-led training with an in-depth presentation of a technology and its concepts, featuring such topics as Java, OOAD, and Open Source.

Hands On help

Seminars are highly-focused, lecture-heavy, half-day to multi-day learning events. Seminars are a great way to create an awareness level of knowledge for a large number of concepts, in a short period of time. Think wide (breadth) and thin (depth).

Seminar help

Workshops are instructor-led lab-intensives focused on the practical application of technologies through the facilitation of a project-related lab. Workshops are just the opposite of Seminars. They deliver the highest level of knowledge transfer of any format. Think wide (breadth) and deep (depth).

Workshop help
Duration: 
2 Days
Productivity Objectives: 
  • Describe the capabilities of Google Cloud for structured data analytics
  • Use basic and advanced SQL capabilities for common data analysis use cases
  • Modify SQL statements to improve their performance and reduce associated costs
  • Build effective visualization dashboards based on visual theory techniques

What You'll Learn

In the Google Cloud for Data Analysts training course you’ll learn:

  • Google Cloud Fundamentals
  • Why Google Cloud for Data Analysts
    • Data Analysis Query, Storage, and Infrastructure
    • Managed Virtual Infrastructure vs. Serverless
  • BigQuery
    • Serverless Data Warehousing
    • Columnar vs. Row-Based Data Storage
    • Projects, Datasets, Tables
    • SQL and User Interface
  • SQL Functions
    • Output Formatting
    • Locating and Excluding Duplicate Records
    • Date/Time Analysis
    • Union and Join Tables
    • Approximate Aggregations
    • User-Defined Functions in SQL and JavaScript
  • Data Import/Export
    • Managed Storage
    • Federated Storage
    • Permanent Tables vs Views
    • Integration with Google Cloud
    • Streaming Data Ingest/Import
    • Query Cache vs. Direct Access
  • Data Quality
    • Garbage-In/Garbage-Out Issues
    • Validity, Accuracy, and Consistency
    • Uniformity and Uniqueness
  • Cost Planning
    • Storage and Processing Costs
    • Batch and Streaming Data Costs
    • On-demand vs. Flat rate vs High Compute Plans
    • Cost Optimizations
  • Performance Optimization
    • Data Skew
    • Normalization vs. Denormalization
    • Semi-Structured Data with Columnar Stores
    • Arrays and Structs for Semi-Structured Data
    • Query Performance Analysis
  • Data Studio
    • Data Visualization Basics
    • Effective Visuals
    • Prefetch and Query Cache
    • Report Sharing and Collaboration
  • Predictive Analytics
    • Machine Learning with BigQuery ML
    • Regression vs. Classification
    • Machine Learning Model Training and Evaluation
    • Predictive Analytics with a Trained BigQuery ML Model
  • Security
    • Role Based Access Control
    • Row-Level / User-Specific Access Control

Get Custom Training Quote

We'll work with you to design a custom Google Cloud for Data Analysts training program that meets your specific needs. A 100% guaranteed plan that works for you, your team, and your budget.

Learn More

Chat with one of our Program Managers from our Boulder, Colorado office to discuss various training options.

DevelopIntelligence has been in the technical/software development learning and training industry for nearly 20 years. We’ve provided learning solutions to more than 48,000 engineers, across 220 organizations worldwide.

About Develop Intelligence
Di Clients
Need help finding the right learning solution?   Call us: 877-629-5631