Google BigQuery Datasets and Visualizing Insights (training)

Colleagues, the Google BigQuery Datasets and Visualizing Insights program will teach you how to ingest new external datasets into BigQuery and visualize them with Google Data Studio. We will also cover intermediate SQL concepts like multi-table JOINs and UNIONs which will allow you to analyze data across multiple data sources. Even if you have a background in SQL, there are BigQuery specifics (like handling query cache and table wildcards) that may be new to you. Training modules include: 1) Course Introduction - Overview of what you will learn in this course, Recap of Google Analytics ecommerce dataset, 2) Storing and Exporting Data - Create new permanent and temporary tables from your query results, Creating Permanent Tables, Temporary Tables and Query Results, Performance Preview: Query Cache, Creating Logical Views, Lab Intro: Creating Permanent Tables and Access-Controlled Views in BigQuery, Getting Started with Google Cloud and Qwiklabs, 4) Ingesting New Datasets into BigQuery - Load and create new datasets inside BigQuery, IIngesting New Data into BigQuery, Lab Intro: Ingesting New Datasets into BigQuery, Background: Partitioned Tables, 5) Joining and Merging Datasets - Understand the differences between SQL JOINs and UNIONs and when to use each, Introducing JOINs and UNIONs, Use table wildcards for easy merges, Linking data across multiple tables, SQL Join examples, Avoiding Pitfalls when Merging Datasets, Recap of Google Analytics ecommerce dataset, Lab Intro: Unioning and Joining Datasets23s, 6) Data Visualization - Create dashboards and visualizations with Google Data Studio, Overview of Data Visualization principles, Comparing Good and Bad Visualizations, Dimensions, Measures, and Reports, Introducing Google Data Studio, Lab Intro: Explore and Create Reports with Data Studio, and 7) Course Summary.

Enroll today (teams & execs welcome): https://tinyurl.com/yjfb7zta 

Download your free Data Science and AI-ML-DL - Career Transformation Guides.

Recommended Reading: 

1 - Data-Driven Decision-Making  (Audible) (Kindle)

2 - Implementing Data Science Methodology: From Data Wrangling to Data Viz (Audible) (Kindle)

3 - The Upskill Gambit - Discover the 5 Keys to Your Career and Income Security in the Digital Age  (Audible) (Kindle) 

Much career success, Lawrence E. Wilson - AI Academy (share with your team)