The Complete Google BigQuery & Data Analysis Course 2022

Name: The Complete Google BigQuery & Data Analysis Course 2022
Rating: 4.6 (47 reviews)

The Simple Guide to Google BigQuery & Data Analysis: Learn from a Fortune 10 Professional

Created byThe Learning Institute, Experiential Learning

Last updated 1/2022

English

What you'll learn

Knowledge of all the essential SQL commands in BigQuery
Learn sorting and filtering in SQL
Proficiency if GROUPBY, JOINS and subqueries
Hands-on example based exercises to solidify your knowledge

Course content

4 sections • 17 lectures • 4h 7m total length

Introduction & Basics: Data, SQL and Google BigQuery5:03
Discover how data shapes business decisions, from qualitative and quantitative data to data warehouses like Google BigQuery. Learn to use SQL queries to pull, edit, and analyze stored data.
Data Details: Data Types & Conceptualizing Table Structure7:14
How to Structure a Query and Order of Operations5:45
Getting Setup in BigQuery Sandbox15:38

Your First Query: Understanding the GBQ UI, SELECT, *, DISTINCT, Columns, & FRO13:43
The WHERE clause, AND, OR, =, IN() function & Exporting results13:34
Basic Aggregations: COUNT(), SUM(), AVG() & the GROUP BY Clause and Naming15:31
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 Analysis Lesson #1 Part 114:43
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 Lesson #1 Part 211:37

Conceptualizing a Join14:15
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.
JOINS & CONCAT19:09
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.
UNIONS, Subqueries, CASTING, ROUND, & WITH/CTE Statements22:26
Practice Analysis Lesson #3 - Bringing It All Together.25:49

Requirements

Just a PC with a web browser

Description

I'm a Senior Analyst working for a Fortune 10 company, and I made this course to help others discover the power of BigQuery.

Join me in this journey where take your through Google BigQuery and SQL step-by-step teaching you through practical examples and datasets.

Why should you take this course?

I have designed every lecture myself to make it accessible to everyone and have focused on teaching the fundamentals of SQL and Google BigQuery for anyone interested in Data analysis for business.
The perfect introduction: This course covers the basics and intermediate level content for BigQuery, SQL and data analysis for beginners seeking a clear and practical introduction.
Example-based learning. I believe that true education comes from practical application. This course is full of real datasets and dedicated lectures where you can join me in conducting analysis through examples.
Downloadable datasets, and resources on SQL and Google BigQuery.

Why choose my course?

This course provides a hands-on and practical course aimed at beginners. The material can be covered at your own pace and has been designed to be of real use to people starting with BigQuery, SQL and data analysis.

The Most Qualified Instructor?

Why am I qualified to teach BigQuery? I work as a Senior Data Analyst for a Fortune 10 company and use BigQuery in my day-to-day work.

Who is this course for?

Any professional interested in learning, SQL, BigQuery or data analysis.
Our primary focus is for business professional seeking an easy-to-understand course.
Anyone interested in learning SQL through practical examples.

Go ahead and click enroll button, if you don't love the course, a refund is always guaranteed.

- Experiential Learning Team

Who this course is for:

Beginners to Google BigQuery especially business professionals
People looking for a simple yet effective introduction to Google BigQuery

The Complete Google BigQuery & Data Analysis Course 2022

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 34min

Basic Queries5 lectures • 1hr 9min

Arithmetic Operations and Case When Statements4 lectures • 1hr 3min

Joins, Concats, Unions and more4 lectures • 1hr 22min

Requirements

Description

Who this course is for: