10 тысяч подписчиков
95 видео
Scheduling BigQuery Uploads with Google Apps Script Triggers
How to connect a data source to Google Data Studio
Intro to Data Build Tool (DBT)
Using math + CASE statements in BigQuery
Snapshot data on a trigger in Sheets using Apps Script
BigQuery + Data Studio (pricing, upload limits, formatting)
Adding Date and Control Filters in Data Studio
BigQuery Recipes: Website Quality Audit
Campaign Type Mapping in Sheets + BigQuery
Nesting + joining queries in Google Sheets
Data Pipeline Stories (Scott Zakrajsek of Sproutward)
Graduating from Sheets to BigQuery
Aggregate by day, week and month in BigQuery
Running SQL Models on a Schedule with Sinter
5 Advanced Ecommerce Reports (Shopify + BigQuery)
Date comparisons in Google Sheets queries: why so complex?
Google Sheets QUERY vs SQL: what’s the difference?
How We Automated an SEO Agency - 155% Increase in REVENUE
Pulling Data from APIs into Google Sheets
Unnesting RECORD arrays in BigQuery SQL
Working with JSON data in BigQuery
Google Sheets formula hacks for Marketers
BigQuery Pricing: How Much Does it Cost?
Shopify Buyer Segmentation [Backyard Analytics]
Automate your Startup w Google Sheets (CIFL + OKDork)
BigQuery Partitioning and Clustering, Explained
The Google Sheets Query: Forget your other Functions
How to style charts using themes in Google Data Studio
WITH statements in BigQuery SQL
How to create time series charts in Google Data Studio
Using GROUP BY in BigQuery to aggregate metrics
Connect your DBT SQL models to BigQuery
Data Studio News: Filter on click, drilldowns, advanced date ranges, and more
How to Productize Your Agency's Services
Business of Data AMA (Nov 20, 2020)
Measuring Search Efficiency by Page in Sheets (w Google Analytics + Search Console)
The Traffic Projection Tool (Google Sheets)
Getting Started with BigQuery
Why Learn the Query Function
Joining tables in BigQuery SQL
Connect BigQuery to Google Sheets (Push + Query)
Building Calculated Fields in Data Studio
Debugging Sheets query errors -
Conditional color formatting with custom formulas in Sheets
Matching Column Headers in a Sheets Query
Pushing Google Analytics data to BigQuery with Stitch
Query multiple Google Sheets: importrange + {} = friends
BigQuery Data Pipeline for Digital Agencies
Make pivot tables with the Google Sheets query
Writing your first BigQuery query
Why Use BigQuery for Google + FB Ads Data?
