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 le...
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 str...
0.1.3 Why we arrived at the sprint pr...
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 modelin...
COMING SOON - Making a staffing plan ...
1.1 Planning Development Sprints
1.1.0 Meet the Tracking Plan
1.1.1 Breaking the roadmap into a Tra...
1.1.2 Mapping our raw data source req...
1.1.3 What you'll do with data source...
1.1.4 Mapping out data source schemas
1.1.5 Populating key starter question...
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 Big...
2.1.5 Supermetrics quickstart for beg...
2.1.6 Pulling data from unsupported A...
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 ...
3.1.5 Managing your dbt project via G...
3.2 Data modeling with dbt
3.2.1 Writing your 'processing' level...
3.2.2 Writing your 'join' level SQL m...
3.2.3 Sidenote: on debugging dbt models
3.2.4 Pro tip: standardizing URL stru...
3.2.5 Pro tip: using dbt macros
3.2.6 Writing your 'admin' level SQL ...
3.2.7 Writing your 'math' and 'visual...
COMING SOON - Data documentation in dbt
COMING SOON - Data + schema testing i...
3.3 Productionalizing your dbt project
3.3.1 Intro to productionalizing your...
3.3.2 Using dbt cloud to run your SQL...
3.3.3 Scheduling your data pipeline o...
3.3.4 Testing changes to your data pi...
3.3.5 QCing data using Supermetrics a...
4.1 Visualizations in Data Studio
4.1.1 The "PDA" reporting design fram...
4.1.2 Designing reports in the Tracki...
4.1.3 Executing the reporting build
4.1.4 Reviewing reporting
4.1.5 Pulling data from BigQuery into...
5.1 Sprint wrapup + review
5.1.1 Conditions for closing out a sp...
5.1.2 Wiring up reporting with live data
5.1.3 Sharing draft models + visualiz...
5.1.4 Transitioning to support mode
Congrats!
Wapow! You made it.
Interested in working with CIFL?
Products
Course
Section
2.2 Data Feeds - Stitch
2.2 Data Feeds - Stitch
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 le...
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 str...
0.1.3 Why we arrived at the sprint pr...
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 modelin...
COMING SOON - Making a staffing plan ...
1.1 Planning Development Sprints
1.1.0 Meet the Tracking Plan
1.1.1 Breaking the roadmap into a Tra...
1.1.2 Mapping our raw data source req...
1.1.3 What you'll do with data source...
1.1.4 Mapping out data source schemas
1.1.5 Populating key starter question...
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 Big...
2.1.5 Supermetrics quickstart for beg...
2.1.6 Pulling data from unsupported A...
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 ...
3.1.5 Managing your dbt project via G...
3.2 Data modeling with dbt
3.2.1 Writing your 'processing' level...
3.2.2 Writing your 'join' level SQL m...
3.2.3 Sidenote: on debugging dbt models
3.2.4 Pro tip: standardizing URL stru...
3.2.5 Pro tip: using dbt macros
3.2.6 Writing your 'admin' level SQL ...
3.2.7 Writing your 'math' and 'visual...
COMING SOON - Data documentation in dbt
COMING SOON - Data + schema testing i...
3.3 Productionalizing your dbt project
3.3.1 Intro to productionalizing your...
3.3.2 Using dbt cloud to run your SQL...
3.3.3 Scheduling your data pipeline o...
3.3.4 Testing changes to your data pi...
3.3.5 QCing data using Supermetrics a...
4.1 Visualizations in Data Studio
4.1.1 The "PDA" reporting design fram...
4.1.2 Designing reports in the Tracki...
4.1.3 Executing the reporting build
4.1.4 Reviewing reporting
4.1.5 Pulling data from BigQuery into...
5.1 Sprint wrapup + review
5.1.1 Conditions for closing out a sp...
5.1.2 Wiring up reporting with live data
5.1.3 Sharing draft models + visualiz...
5.1.4 Transitioning to support mode
Congrats!
Wapow! You made it.
Interested in working with CIFL?
Stitch
is the preferred ETL (extract, transform, load) platform used by CIFL to pull data from APIs like Google Analytics, FB Ads and more into BigQuery.
4 Lessons
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