TGx:Udemy - Google BigQuery for Marketers and Agencies

Hot Picks

First Cam

New Movies

1080p x265

New TV

Misc

Torrent details for "Udemy - Google BigQuery for Marketers and Agencies" Log in to bookmark

Quicknav > Description Read comments 0 Post guest comment

Torrent details

Name:

Udemy - Google BigQuery for Marketers and Agencies

Controls:

Report Torrent

Torrent verified by tutsnode

Category:

Other > Training

Language:

English

Total Size:

1.13 GB

Info Hash:

f8516039ebe9e50f931a28ea6f1369f9fb7b827e

Added By:

tutsnode

Added:

07-12-2020 11:23

Views:

320

Update stats Post guest comment 0

Health:

Seeds:

Leechers:

Completed:

File	Size
TutsNode.com.txt	63.00 B
[TGx]Downloaded from torrentgalaxy.to .txt	585.00 B
[TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/001 Welcome to the Course!.en.srt	775.00 B
[TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/001 Welcome to the Course!.mp4	7.25 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/002 What are Google BigQuery and SQL_.en.srt	2.00 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/002 What are Google BigQuery and SQL_.mp4	10.72 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/003 Setting up your BigQuery Sandbox account in Google Cloud Platform (GCP).en.srt	4.33 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/003 Setting up your BigQuery Sandbox account in Google Cloud Platform (GCP).mp4	19.85 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/004 Navigating the Google BigQuery interface.en.srt	5.31 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/004 Navigating the Google BigQuery interface.mp4	22.74 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/005 Using the BigQuery Solutions Manual.html	1.47 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/006 Course-Datasets.zip	1.11 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/006 Downloading the BigQuery course datasets.html	1.41 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/external-assets-links.txt	185.00 B
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/007 chicago-taxi-trips-10000-records-sample.csv	2.92 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/007 Ingesting a CSV dataset into BigQuery and creating a table.en.srt	9.11 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/007 Ingesting a CSV dataset into BigQuery and creating a table.mp4	33.34 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/008 Writing your first query with the SELECT, FROM and LIMIT clauses.en.srt	8.76 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/008 Writing your first query with the SELECT, FROM and LIMIT clauses.mp4	41.28 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/009 Aggregating data with SUM, COUNT, GROUP BY and creating aliases with AS.en.srt	8.34 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/009 Aggregating data with SUM, COUNT, GROUP BY and creating aliases with AS.mp4	41.62 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/010 Filtering values with WHERE and sorting data with ORDER BY.en.srt	8.79 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/010 Filtering values with WHERE and sorting data with ORDER BY.mp4	40.44 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/011 Understanding subqueries by using the WITH clause.en.srt	7.87 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/011 Understanding subqueries by using the WITH clause.mp4	36.35 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/012 Exporting your queries and results into a BigQuery table.en.srt	4.52 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/02 Creating and querying tables with SQL in Google BigQuery/012 Exporting your queries and results into a BigQuery table.mp4	22.54 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/03 Exploring semi-structured data with ARRAY_AGG, UNNEST and STRUCT/013 What is an _Array_ and why does it matter_.en.srt	6.36 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/03 Exploring semi-structured data with ARRAY_AGG, UNNEST and STRUCT/013 What is an _Array_ and why does it matter_.mp4	24.11 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/03 Exploring semi-structured data with ARRAY_AGG, UNNEST and STRUCT/014 Grouping values together with STRUCT to define array hierarchy.en.srt	10.02 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/03 Exploring semi-structured data with ARRAY_AGG, UNNEST and STRUCT/014 Grouping values together with STRUCT to define array hierarchy.mp4	34.12 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/03 Exploring semi-structured data with ARRAY_AGG, UNNEST and STRUCT/015 Creating an array in an existing flattened table with ARRAY_AGG.en.srt	11.87 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/03 Exploring semi-structured data with ARRAY_AGG, UNNEST and STRUCT/015 Creating an array in an existing flattened table with ARRAY_AGG.mp4	57.41 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/03 Exploring semi-structured data with ARRAY_AGG, UNNEST and STRUCT/016 Filtering and unnesting arrays with UNNEST.en.srt	10.99 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/03 Exploring semi-structured data with ARRAY_AGG, UNNEST and STRUCT/016 Filtering and unnesting arrays with UNNEST.mp4	45.31 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/03 Exploring semi-structured data with ARRAY_AGG, UNNEST and STRUCT/external-assets-links.txt	118.00 B
[TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/017 What are the different types of SQL JOINs_.en.srt	4.32 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/017 What are the different types of SQL JOINs_.mp4	24.84 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/018 campaign-actual-spend-sample.csv	3.98 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/018 campaign-planned-spend-sample.csv	2.09 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/018 Joining tables with a one-to-one relationship (INNER and LEFT JOINs).en.srt	13.65 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/018 Joining tables with a one-to-one relationship (INNER and LEFT JOINs).mp4	67.42 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/019 Calculating percentage difference within a JOIN.en.srt	4.49 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/019 Calculating percentage difference within a JOIN.mp4	23.83 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/020 creative-impressions-sample.csv	746.00 B
[TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/020 creative-total-conversions-sample.csv	672.00 B
[TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/020 Introducing multiple JOIN keys in many-to-many table relationships.en.srt	10.09 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/020 Introducing multiple JOIN keys in many-to-many table relationships.mp4	49.53 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/021 Setting up a public Google Analytics 360 dataset in BigQuery.en.srt	6.81 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/021 Setting up a public Google Analytics 360 dataset in BigQuery.mp4	32.88 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/022 Understanding website traffic sources and volume (Users, Sessions and Pageviews).en.srt	11.53 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/022 Understanding website traffic sources and volume (Users, Sessions and Pageviews).mp4	51.46 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/023 Re-grouping your traffic sources (Default Channel Groupings) with CASE.en.srt	7.95 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/023 Re-grouping your traffic sources (Default Channel Groupings) with CASE.mp4	38.86 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/024 Part 1_ Analyzing best-selling products and categories with WHERE and UNNEST.en.srt	8.92 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/024 Part 1_ Analyzing best-selling products and categories with WHERE and UNNEST.mp4	43.56 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/025 Part 2_ Analyzing best-selling products and categories with WHERE and UNNEST.en.srt	12.07 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/025 Part 2_ Analyzing best-selling products and categories with WHERE and UNNEST.mp4	58.82 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/026 Identifying high-value customers to find CRM matches and activate insights.en.srt	19.56 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/026 Identifying high-value customers to find CRM matches and activate insights.mp4	102.60 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/05 Project 1_ Exploring eCommerce and CRM user-level data in Google Analytics 360/external-assets-links.txt	118.00 B
[TutsNode.com] - Google BigQuery for Marketers and Agencies/06 Project 2_ Visualizing BigQuery tables and queries in Google Data Studio/027 Connecting your BigQuery table to Data Studio.en.srt	16.02 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/06 Project 2_ Visualizing BigQuery tables and queries in Google Data Studio/027 Connecting your BigQuery table to Data Studio.mp4	63.32 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/06 Project 2_ Visualizing BigQuery tables and queries in Google Data Studio/028 Visualizing your table by using different chart types.en.srt	11.27 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/06 Project 2_ Visualizing BigQuery tables and queries in Google Data Studio/028 Visualizing your table by using different chart types.mp4	62.11 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/06 Project 2_ Visualizing BigQuery tables and queries in Google Data Studio/029 Writing Custom SQL queries directly in Data Studio.en.srt	12.16 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/06 Project 2_ Visualizing BigQuery tables and queries in Google Data Studio/029 Writing Custom SQL queries directly in Data Studio.mp4	60.05 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/06 Project 2_ Visualizing BigQuery tables and queries in Google Data Studio/030 Using the Google Data Studio Explorer for generating insights faster.en.srt	4.18 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/06 Project 2_ Visualizing BigQuery tables and queries in Google Data Studio/030 Using the Google Data Studio Explorer for generating insights faster.mp4	19.39 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/06 Project 2_ Visualizing BigQuery tables and queries in Google Data Studio/external-assets-links.txt	169.00 B
[TutsNode.com] - Google BigQuery for Marketers and Agencies/07 Conclusion/031 Next Steps.en.srt	1.44 kB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/07 Conclusion/031 Next Steps.mp4	14.18 MB
[TutsNode.com] - Google BigQuery for Marketers and Agencies/07 Conclusion/external-assets-links.txt	85.00 B

Description

Description

LATEST CONTENT UPDATE: August, 2020

Welcome to Google BigQuery for Marketers and Agencies,the Google BigQuery course that focuses on growing the technical knowledge and expertise of the marketing professional! This course is designed to bridge the gap between data analysis and digital marketing, and help you become a data-driven decision-maker. The course curriculum is put together in a progressive fashion, starting with an introduction to the most useful SQL queries for marketers, the role of both BigQuery and SQL in the larger data ecosystem, and then diving into two hands-on projects, where you can use everything you have learned.

By the end of the course, you will be able to:

Explore eCommerce and CRM user-level data in Google Analytics 360 (Project #1)
Visualize active queries and data tables in Google Data Studio (Project #2)
Explore semi-structured data with ARRAY_AGG, UNNEST and STRUCT
Filter values with the WHERE clause to identify insights
Ingest .CSV files and create permanent BigQuery tables
Combine multiple data tables with different types of JOINs – INNER, LEFT and RIGHT
Aggregate data with SUM, COUNT and GROUP BY
Create nested queries by using the WITH clause

Who is the instructor?

Lachezar Arabadzhiev is a digital markitech with 4+ years of experience in performance analytics and data visualization. Lachezar began his career as a digital marketer at Microsoft, but soon transitioned to the measurement and analytics world, where he has had the opportunity to work with major brands such as Air Canada, RBC, Kimberly-Clark, Mazda and HSBC.

Lachezar has been working with Data Studio and BigQuery since early 2017 and has built a wide variety of visualizations and automation flows. From performance-based dashboards with joined GMP sources (Google Analytics 360, Campaign Manager and Display & Video 360) to audience-driven segmentation views with user-level eCommerce data.

Lachezar is a certified GMP expert and an official speaker at the Canadian Google Data & Analytics Summit, 2018.
Who this course is for:

Digital Marketers
Campaign Managers
Performance Managers
Paid Media Managers
SEO/SEM Specialists
AdOps Specialists
Digital Analysts

Requirements

Understanding of Digital Marketing (Not Required, but Highly Recommended)
Google BigQuery Sandbox (Free and Provided)
Google Data Studio Account (Free and Provided)

Last Updated 8/2020