Google BigQuery for Marketers and Agencies

1. [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.mp4102.6MB
2. [TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/001 Welcome to the Course!.mp47.25MB
3. [TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/002 What are Google BigQuery and SQL_.mp410.72MB
4. [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).mp419.85MB
5. [TutsNode.com] - Google BigQuery for Marketers and Agencies/01 Getting started with Google BigQuery/004 Navigating the Google BigQuery interface.mp422.74MB
6. [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.mp433.34MB
7. [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.mp441.28MB
8. [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.mp441.62MB
9. [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.mp440.44MB
10. [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.mp436.35MB
11. [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.mp422.54MB
12. [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_.mp424.11MB
13. [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.mp434.12MB
14. [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.mp457.41MB
15. [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.mp445.31MB
16. [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_.mp424.84MB
17. [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).mp467.42MB
18. [TutsNode.com] - Google BigQuery for Marketers and Agencies/04 Combing multiple tables with different JOIN statements/019 Calculating percentage difference within a JOIN.mp423.83MB
19. [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.mp449.53MB
20. [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.mp432.88MB
21. [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).mp451.46MB
22. [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.mp438.86MB
23. [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.mp443.56MB
24. [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.mp458.82MB
25. [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.mp463.32MB
26. [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.mp462.11MB
27. [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.mp460.05MB
28. [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.mp419.39MB
29. [TutsNode.com] - Google BigQuery for Marketers and Agencies/07 Conclusion/031 Next Steps.mp414.18MB