Getting Started with BigQuery
- Buy now
- Learn more
Getting Acquainted

1) All the links: datasets, templates and tools
2) Join us on Slack
3) How we can help
Why Work in BigQuery?

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

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

Joining Tables
Using WITH for cleaner Joins
Window (analytic) functions
Deduping query results
Quiz 2
Getting Data Into BigQuery

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

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

Hire CIFL to build your data pipeline
Learn to build your own data pipeline
Execute common marketing "Recipes" with Query.recipes
Office Hours

How Google Cloud Functions et al fit with BigQuery
BigQuery Partitioning and Clustering, Explained
Working with JSON data in BigQuery
Upcoming!

User-defined functions
Partitioning with dbt

Upcoming!

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

2 Lessons