Building a Data Agency
by
Coding is for Losers
Login
Buy for $999
3.3.1 Intro to productionalizing your pipeline
Building a Data Agency
/
3.3 Productionalizing your dbt project
Diving into the basic tenets of moving from development to production.
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?
Welcome!
Enter your info below to login.
Your email
Your password
Login
Forgot your password?