The Complete Google BigQuery & Data Analysis Course 2022

Learn to write your first Google BigQuery queries using the GBQ UI, select *, distinct, columns, and from a chosen table.

Master the where clause in BigQuery using =, and, or, and in() for multi-value filters, and export results to csv for Excel or Tableau.

Explore simple aggregate functions in Google BigQuery, including sum, count, and average, with group by and naming outputs to analyze sales by state and by distinct cities.

Practice data analysis in Google BigQuery by writing queries to inspect retail data, identify top stores by sales amount and units, and count distinct states, cities, and stores per district.

Practice analysis with Google BigQuery to inspect and transform data, answer sales questions by city and state, and compare last year totals to inform decisions.

Learn to use arithmetic operators in Google BigQuery to sum, subtract, and compare this year's versus last year's sales, creating new columns and filtering results.

Apply case when statements in BigQuery to create boolean indicators, multi-criteria filters, and categorized buckets, using between, else, and group by to analyze yearly sales and count stores.

Guide learners through a BigQuery data analysis project to compare this year's and last year's sales amount by state and District A.

Explore BigQuery data analysis techniques to analyze store sales, using min, max, and average of combined yearly sales and having filters for year over year growth.

Explore how joins combine rows from two tables using a common column, and learn left, inner, right, outer, and full outer joins with practical city-based examples.

Learn to use left joins in Google BigQuery to merge this year’s sales transactions with store geography, using concatenate to form city_state and count distinct transactions.

Learn to combine data with unions, build subqueries, and use with statements (cte) to create temporary tables, plus cast and round for numeric formatting.

Analyze sales data in Google BigQuery to compute gross margin amount and margin percent by item. Identify the city that sold the most brown shoes over the last two years.