Building a Data Agency by Coding is for Losers
Login Buy for $999

Getting Started with BigQuery SQL

Building a Data Agency / Additional (FREE) CIFL Courses

learn.codingisforlosers.com/learn-bigquery-sql

Visit Link
If you or your team are unfamiliar with BigQuery SQL syntax (or new to writing SQL), you'll want to start with this free course from CIFL.

Building a Data Agency

How you can offer "data pipelines as a service" on Google BigQuery, following our end-to-end process

Buy for $999 Learn more
Already enrolled?
Sign in to continue learning.

Table of contents

Building a Data Agency

by Coding is for Losers
ui-24px-outline-1_lock
Getting Started + FAQs Getting Started + FAQs
Draft ***ALL THE TEMPLATE LINKS***
Draft ***ALL THE TEMPLATE LINKS***
Draft **GETTING HELP**
Draft **GETTING HELP**
Draft The business of data, end-to-end
Draft The business of data, end-to-end
Draft Why'd we republish this course?
Draft Why'd we republish this course?
Draft Who is this for, and what will you learn?
Draft Who is this for, and what will you learn?
Draft What is a data pipeline?
Draft What is a data pipeline?
Draft [THROWBACK ALERT] WTF is ADP?
Draft [THROWBACK ALERT] WTF is ADP?
ui-24px-outline-1_lock
Additional (FREE) CIFL Courses Additional (FREE) CIFL Courses
Draft Getting Started with BigQuery SQL
Draft Getting Started with BigQuery SQL
Draft Data Studio the Lazy Way
Draft Data Studio the Lazy Way
ui-24px-outline-1_lock
0.1 The Sales Flow 0.1 The Sales Flow
Draft 0.1.1 Finding your niche
Draft 0.1.1 Finding your niche
Draft 0.1.2 Building an inbound content strategy
Draft 0.1.2 Building an inbound content strategy
Draft 0.1.3 Why we arrived at the sprint pricing model
Draft 0.1.3 Why we arrived at the sprint pricing model
Draft 0.1.4 Why we publish pricing
Draft 0.1.4 Why we publish pricing
Draft 0.1.5 The initial sales call
Draft 0.1.5 The initial sales call
Draft 0.1.6 The roadmapping process
Draft 0.1.6 The roadmapping process
Draft 0.1.7 Deal closing + contracts
Draft 0.1.7 Deal closing + contracts
ui-24px-outline-1_lock
0.2 Staffing & Resourcing 0.2 Staffing & Resourcing
Draft 0.2.1 The sprint flow + roles
Draft 0.2.1 The sprint flow + roles
Draft 0.2.2 Hiring reporting + data modeling analysts
Draft 0.2.2 Hiring reporting + data modeling analysts
Draft COMING SOON - Making a staffing plan & budget
Draft COMING SOON - Making a staffing plan & budget
ui-24px-outline-1_lock
1.1 Planning Development Sprints 1.1 Planning Development Sprints
Draft 1.1.0 Meet the Tracking Plan
Draft 1.1.0 Meet the Tracking Plan
Draft 1.1.1 Breaking the roadmap into a Tracking Plan
Draft 1.1.1 Breaking the roadmap into a Tracking Plan
Draft 1.1.2 Mapping our raw data source requirements
Draft 1.1.2 Mapping our raw data source requirements
Draft 1.1.3 What you'll do with data source schemas
Draft 1.1.3 What you'll do with data source schemas
Draft 1.1.4 Mapping out data source schemas
Draft 1.1.4 Mapping out data source schemas
Draft 1.1.5 Populating key starter questions for reporting
Draft 1.1.5 Populating key starter questions for reporting
Draft 1.1.6 Scoping out each Site or Client
Draft 1.1.6 Scoping out each Site or Client
ui-24px-outline-1_lock
2.1 Data Feeds - Getting Started 2.1 Data Feeds - Getting Started
Draft 2.1.1 Intro to data feeds
Draft 2.1.1 Intro to data feeds
Draft 2.1.2 BigQuery initial setup
Draft 2.1.2 BigQuery initial setup
Draft 2.1.3 Setting up your BigQuery tables
Draft 2.1.3 Setting up your BigQuery tables
Draft 2.1.4 Pushing data from Sheets to BigQuery
Draft 2.1.4 Pushing data from Sheets to BigQuery
Draft 2.1.5 Supermetrics quickstart for beginners
Draft 2.1.5 Supermetrics quickstart for beginners
Draft 2.1.6 Pulling data from unsupported APIs into the Tracking Plan
Draft 2.1.6 Pulling data from unsupported APIs into the Tracking Plan
ui-24px-outline-1_lock
2.2 Data Feeds - Stitch 2.2 Data Feeds - Stitch
Draft 2.2.1 Stitch initial setup
Draft 2.2.1 Stitch initial setup
Draft 2.2.2 Pulling GA data using Stitch
Draft 2.2.2 Pulling GA data using Stitch
Draft 2.2.3 Pulling Adwords data using Stitch
Draft 2.2.3 Pulling Adwords data using Stitch
Draft 2.2.4 Pulling FB Ads data using Stitch
Draft 2.2.4 Pulling FB Ads data using Stitch
ui-24px-outline-1_lock
3.1 Intro to dbt 3.1 Intro to dbt
Draft 3.1.1 Intro to dbt for SQL data modeling
Draft 3.1.1 Intro to dbt for SQL data modeling
Draft 3.1.2 Planning your Data Models
Draft 3.1.2 Planning your Data Models
Draft 3.1.3 Creating your dbt project
Draft 3.1.3 Creating your dbt project
Draft 3.1.4 Connect your BigQuery database to dbt
Draft 3.1.4 Connect your BigQuery database to dbt
Draft 3.1.5 Managing your dbt project via Github
Draft 3.1.5 Managing your dbt project via Github
ui-24px-outline-1_lock
3.2 Data modeling with dbt 3.2 Data modeling with dbt
Draft 3.2.1 Writing your 'processing' level SQL queries
Draft 3.2.1 Writing your 'processing' level SQL queries
Draft 3.2.2 Writing your 'join' level SQL models
Draft 3.2.2 Writing your 'join' level SQL models
Draft 3.2.3 Sidenote: on debugging dbt models
Draft 3.2.3 Sidenote: on debugging dbt models
Draft 3.2.4 Pro tip: standardizing URL structure
Draft 3.2.4 Pro tip: standardizing URL structure
Draft 3.2.5 Pro tip: using dbt macros
Draft 3.2.5 Pro tip: using dbt macros
Draft 3.2.6 Writing your 'admin' level SQL models
Draft 3.2.6 Writing your 'admin' level SQL models
Draft 3.2.7 Writing your 'math' and 'visualization' level SQL models
Draft 3.2.7 Writing your 'math' and 'visualization' level SQL models
Draft COMING SOON - Data documentation in dbt
Draft COMING SOON - Data documentation in dbt
Draft COMING SOON - Data + schema testing in dbt
Draft COMING SOON - Data + schema testing in dbt
ui-24px-outline-1_lock
3.3 Productionalizing your dbt project 3.3 Productionalizing your dbt project
Draft 3.3.1 Intro to productionalizing your pipeline
Draft 3.3.1 Intro to productionalizing your pipeline
Draft 3.3.2 Using dbt cloud to run your SQL models on a schedule
Draft 3.3.2 Using dbt cloud to run your SQL models on a schedule
Draft 3.3.3 Scheduling your data pipeline orchestrations
Draft 3.3.3 Scheduling your data pipeline orchestrations
Draft 3.3.4 Testing changes to your data pipeline
Draft 3.3.4 Testing changes to your data pipeline
Draft 3.3.5 QCing data using Supermetrics as a check
Draft 3.3.5 QCing data using Supermetrics as a check
ui-24px-outline-1_lock
4.1 Visualizations in Data Studio 4.1 Visualizations in Data Studio
Draft 4.1.1 The "PDA" reporting design framework
Draft 4.1.1 The "PDA" reporting design framework
Draft 4.1.2 Designing reports in the Tracking Plan
Draft 4.1.2 Designing reports in the Tracking Plan
Draft 4.1.3 Executing the reporting build
Draft 4.1.3 Executing the reporting build
Draft 4.1.4 Reviewing reporting
Draft 4.1.4 Reviewing reporting
Draft 4.1.5 Pulling data from BigQuery into Sheets
Draft 4.1.5 Pulling data from BigQuery into Sheets
ui-24px-outline-1_lock
5.1 Sprint wrapup + review 5.1 Sprint wrapup + review
Draft 5.1.1 Conditions for closing out a sprint
Draft 5.1.1 Conditions for closing out a sprint
Draft 5.1.2 Wiring up reporting with live data
Draft 5.1.2 Wiring up reporting with live data
Draft 5.1.3 Sharing draft models + visualizations with clients
Draft 5.1.3 Sharing draft models + visualizations with clients
Draft 5.1.4 Transitioning to support mode
Draft 5.1.4 Transitioning to support mode
ui-24px-outline-1_lock
Congrats! Congrats!
Draft Wapow! You made it.
Draft Wapow! You made it.
Draft Interested in working with CIFL?
Draft Interested in working with CIFL?
Powered by
Terms Privacy
Welcome!
Enter your info below to login.
Forgot your password?