Google BigQuery for Marketers and Agencies | F8516039EBE9E50F931A28EA6F1369F9FB7B827E

Google BigQuery for Marketers and Agencies

Name	Google BigQuery for Marketers and Agencies	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.2 GB
Total Files	73
Hash	F8516039EBE9E50F931A28EA6F1369F9FB7B827E

/.../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	107.6 MB
021 Setting up a public Google Analytics 360 dataset in BigQuery.en.srt	7.0 KB
021 Setting up a public Google Analytics 360 dataset in BigQuery.mp4	34.5 MB
022 Understanding website traffic sources and volume (Users, Sessions and Pageviews).en.srt	11.8 KB
022 Understanding website traffic sources and volume (Users, Sessions and Pageviews).mp4	54.0 MB
023 Re-grouping your traffic sources (Default Channel Groupings) with CASE.en.srt	8.1 KB
023 Re-grouping your traffic sources (Default Channel Groupings) with CASE.mp4	40.7 MB
024 Part 1_ Analyzing best-selling products and categories with WHERE and UNNEST.en.srt	9.1 KB
024 Part 1_ Analyzing best-selling products and categories with WHERE and UNNEST.mp4	45.7 MB
025 Part 2_ Analyzing best-selling products and categories with WHERE and UNNEST.en.srt	12.4 KB
025 Part 2_ Analyzing best-selling products and categories with WHERE and UNNEST.mp4	61.7 MB
026 Identifying high-value customers to find CRM matches and activate insights.en.srt	20.0 KB
external-assets-links.txt	0.1 KB
/
TutsNode.com.txt	0.1 KB
[TGx]Downloaded from torrentgalaxy.to .txt	0.6 KB
/.../01 Getting started with Google BigQuery/
001 Welcome to the Course!.en.srt	0.8 KB
001 Welcome to the Course!.mp4	7.6 MB
002 What are Google BigQuery and SQL_.en.srt	2.0 KB
002 What are Google BigQuery and SQL_.mp4	11.2 MB
003 Setting up your BigQuery Sandbox account in Google Cloud Platform (GCP).en.srt	4.4 KB
003 Setting up your BigQuery Sandbox account in Google Cloud Platform (GCP).mp4	20.8 MB
004 Navigating the Google BigQuery interface.en.srt	5.4 KB
004 Navigating the Google BigQuery interface.mp4	23.8 MB
005 Using the BigQuery Solutions Manual.html	1.5 KB
006 Course-Datasets.zip	1.2 MB
006 Downloading the BigQuery course datasets.html	1.4 KB
external-assets-links.txt	0.2 KB
/.../02 Creating and querying tables with SQL in Google BigQuery/
007 chicago-taxi-trips-10000-records-sample.csv	3.1 MB
007 Ingesting a CSV dataset into BigQuery and creating a table.en.srt	9.3 KB
007 Ingesting a CSV dataset into BigQuery and creating a table.mp4	35.0 MB
008 Writing your first query with the SELECT, FROM and LIMIT clauses.en.srt	9.0 KB
008 Writing your first query with the SELECT, FROM and LIMIT clauses.mp4	43.3 MB
009 Aggregating data with SUM, COUNT, GROUP BY and creating aliases with AS.en.srt	8.5 KB
009 Aggregating data with SUM, COUNT, GROUP BY and creating aliases with AS.mp4	43.6 MB
010 Filtering values with WHERE and sorting data with ORDER BY.en.srt	9.0 KB
010 Filtering values with WHERE and sorting data with ORDER BY.mp4	42.4 MB
011 Understanding subqueries by using the WITH clause.en.srt	8.1 KB
011 Understanding subqueries by using the WITH clause.mp4	38.1 MB
012 Exporting your queries and results into a BigQuery table.en.srt	4.6 KB
012 Exporting your queries and results into a BigQuery table.mp4	23.6 MB
/.../03 Exploring semi-structured data with ARRAY_AGG, UNNEST and STRUCT/
013 What is an _Array_ and why does it matter_.en.srt	6.5 KB
013 What is an _Array_ and why does it matter_.mp4	25.3 MB
014 Grouping values together with STRUCT to define array hierarchy.en.srt	10.3 KB
014 Grouping values together with STRUCT to define array hierarchy.mp4	35.8 MB
015 Creating an array in an existing flattened table with ARRAY_AGG.en.srt	12.2 KB
015 Creating an array in an existing flattened table with ARRAY_AGG.mp4	60.2 MB
016 Filtering and unnesting arrays with UNNEST.en.srt	11.3 KB
016 Filtering and unnesting arrays with UNNEST.mp4	47.5 MB
external-assets-links.txt	0.1 KB
/.../04 Combing multiple tables with different JOIN statements/
017 What are the different types of SQL JOINs_.en.srt	4.4 KB
017 What are the different types of SQL JOINs_.mp4	26.0 MB
018 campaign-actual-spend-sample.csv	4.1 KB
018 campaign-planned-spend-sample.csv	2.1 KB
018 Joining tables with a one-to-one relationship (INNER and LEFT JOINs).en.srt	14.0 KB
018 Joining tables with a one-to-one relationship (INNER and LEFT JOINs).mp4	70.7 MB
019 Calculating percentage difference within a JOIN.en.srt	4.6 KB
019 Calculating percentage difference within a JOIN.mp4	25.0 MB
020 creative-impressions-sample.csv	0.7 KB
020 creative-total-conversions-sample.csv	0.7 KB
020 Introducing multiple JOIN keys in many-to-many table relationships.en.srt	10.3 KB
020 Introducing multiple JOIN keys in many-to-many table relationships.mp4	51.9 MB
/.../06 Project 2_ Visualizing BigQuery tables and queries in Google Data Studio/
027 Connecting your BigQuery table to Data Studio.en.srt	16.4 KB
027 Connecting your BigQuery table to Data Studio.mp4	66.4 MB
028 Visualizing your table by using different chart types.en.srt	11.5 KB
028 Visualizing your table by using different chart types.mp4	65.1 MB
029 Writing Custom SQL queries directly in Data Studio.en.srt	12.4 KB
029 Writing Custom SQL queries directly in Data Studio.mp4	63.0 MB
030 Using the Google Data Studio Explorer for generating insights faster.en.srt	4.3 KB
030 Using the Google Data Studio Explorer for generating insights faster.mp4	20.3 MB
external-assets-links.txt	0.2 KB
/07 Conclusion/
031 Next Steps.en.srt	1.5 KB
031 Next Steps.mp4	14.9 MB
external-assets-links.txt	0.1 KB
Total files 73