BigQuery for Data Analysts
This course is designed for data analysts who want to learn about using BigQuery for their data analysis needs. Through a combination of videos, labs, and demos, we cover various topics that discuss how to ingest, transform, and query your data in BigQuery to derive insights that can help in business decision-making.
- Duration: 2 days
- Languages: English, German
- Level: Intermediate
- Group size: Up to 16
What you'll learn
- Learn the purpose and value of BigQuery, Google Cloud’s enterprise data warehouse, and discuss its data analytics features.
- Analyze large datasets in BigQuery with SQL.
- Clean and transform your data in BigQuery with SQL.
- Ingest new BigQuery datasets, and discuss options for external data sources.
- Review visualization principles, and use Connected Sheets and Looker Studio to visualize data insights from BigQuery.
- Use Dataform to develop scalable data transformation pipelines in BigQuery.
- Use new integrations and assistive capabilities introduced with BigQuery Studio.
Prerequisites
- Introduction to Data Analytics on Google Cloud
Course outline
Course introduction
- This module introduces the course agenda.
BigQuery for data analysts
- Overview
- Data analytics on Google Cloud
- From data to insights with BigQuery
- Real-world use cases of companies transformed through analytics on Google Cloud
Exploring and preparing your data with BigQuery
- Overview
- Common data exploration techniques
- Analysis of large datasets with BigQuery
- Query basics
- Working with functions
- Enriching your queries with UNIONs and JOINs
Cleaning and transforming your data
- Overview
- Five principles of dataset integrity
- Clean and transform data using SQL
- Clean and transform data: Other options
Ingesting and storing new BigQuery datasets
- Overview
- Permanent versus temporary data tables
- Ingesting new datasets
- External data sources
Visualizing your insights from BigQuery
- Overview
- Data visualization principles
- Connected Sheets
- Common data visualization pitfalls
- Looker Studio
- Analysis in a notebook
Developing scalable data transformation pipelines in BigQuery with Dataform
- Overview
- What is Dataform?
- Getting started with Dataform
BigQuery Studio
- BigQuery Studio: What and why?
- Unified analytics
- Asset management
- Embedded assistance
Summary
- Summary
Related courses
AlloyDB Essentials
This course explores the benefits of AlloyDB, especially compared to PostgreSQL on Cloud SQL. It will walk you through AlloyDB’s unique architecture, and explain how to configure deployments on Google Cloud.The course is divided into two parts: AlloyDB Administration Essentials (architecture and configuration) and AlloyDB Optimization Essentials (performance tuning).
Data Engineering on Google Cloud
Get hands-on experience with designing and building data processing systems on Google Cloud. This course uses lectures, demos, and hands-on labs to show you how to design data processing systems, build end-to-end data pipelines, analyze data, and implement machine learning. This course covers structured, unstructured, and streaming data.
Data Integration with Cloud Data Fusion
This 2-day course introduces learners to Google Cloud’s data integration capability using Cloud Data Fusion. In this course, we discuss challenges with data integration and the need for a data integration platform (middleware). We then discuss how Cloud Data Fusion can help to effectively integrate data from a variety of sources and formats and generate insights. We take a look at Cloud Data Fusion’s main components and how they work, how to process batch data and real time streaming data with visual pipeline design, rich tracking of metadata and data lineage, and how to deploy data pipelines on various execution engines.
Not sure which course fits?
Book a 30-minute call. We'll look at where your team is, what they need to be able to do, and put together either a specific course date or a tailored learning plan.