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