Getting Started with BigQuery

Free

Getting Started with BigQuery

Making the jump from spreadsheets to databases, one small SQL query at a time.

Buy now

Getting Acquainted

A few helpful links + notes to get you on your way with BigQuery.

1) All the links: datasets, templates and tools

2) Join us on Slack

3) How we can help

Why Work in BigQuery?

Before we dive into the nitty gritty of learning how to use BigQuery, let's get acquainted + talk about *why* and *how* we use it as CIFL.

How I learned SQL

Why do we recommend BigQuery?

How does BigQuery fit into the rest of the Google stack?

How we build marketing data pipelines in BigQuery

What all do you really need to learn?

What does it cost?

BigQuery SQL - Getting Started

A mini-course diving into the basics of writing SQL in BigQuery, using the Google Analytics sample dataset as an example.

Creating a Project + Access the GA Sample Dataset

Writing your first SELECT query

Filtering data with WHERE

Ordering results with ORDER BY

Calculating aggregate totals with GROUP BY

Calculating columns (SUM, COUNT, etc) within queries

Aggregating by day, week and month

Nesting queries

Unnesting RECORD arrays

Quiz 1

Bigquery SQL - Diving Deeper

Getting familiar with joining, window functions and more, using the Google Analytics sample dataset as an example.

Joining Tables

Using WITH for cleaner Joins

Window (analytic) functions

Deduping query results

Quiz 2

Getting Data Into BigQuery

A few ways we at CIFL push data into our BigQuery warehouses.

Push from Google Sheets to BigQuery

Push from FB Ads (or any platform) to BigQuery

Reviewing Stitch vs Supermetrics for BigQuery

Scheduling BQ queries with dbt

An introduction to dbt, our favorite framework for turning a set of SQL models into a *scalable, repeatable product* hosted in a Github repo.

These lessons are excerpted from the Build your Agency Data Pipeline course.

Intro to DBT for SQL modeling

Creating your DBT project

Connect your BigQuery database to DBT

Writing basic SQL queries in DBT

The magic of DBT's {{ref}}

Debugging SQL models with DBT

Pro tip: standardizing URL structure with DBT

Pro tip: using DBT macros

Building your BigQuery pipeline

Ways we at CIFL can help you get a BigQuery data pipeline up and running.

Hire CIFL to build your data pipeline

Learn to build your own data pipeline

Execute common marketing "Recipes" with Query.recipes

Office Hours

Answering questions from Slack + email.

Have a question? Drop us a note on Twitter or in Slack.

How Google Cloud Functions et al fit with BigQuery

BigQuery Partitioning and Clustering, Explained

Working with JSON data in BigQuery

Upcoming!

Lessons requested by the CIFL community. Drop a note in Slack or on Twitter if you have any special requests.

User-defined functions

Partitioning with dbt