Google Data Analytics Online Bootcamp: BigQuery+ Google Sheets

Learn how to extract, analyze, and visualize data with the Google Suite - Google BigQuery (SQL) and Google Sheets!

This Bootcamp is live and instructor led
Price $299
What the heck is data analytics?
Think about all of the data that a company collects and has access to. Ever wonder how that data gets used? With the use of SQL, analysts are able to extract this data and analyze it in every way possible. The analysis, derived from data using SQL, can help drive strategic business decisions. To add another layer to the analysis, you can visualize your data with charts and graphs that can explain complex data points in simple data visuals, using tools such as Tableau.
About the Bootcamp
This Bootcamp is best for those with little to no data analytics experience and would like to prep for a role as an entry level or junior analyst using skills from SQL and different data visualization tools (i.e. Tableau, Power BI, Qlikview, etc.). All students will have three hours of prerequisite material provided prior to the start of class to help prep them for the first day of the Bootcamp. In this Bootcamp, we will use Google BigQuery for SQL and Google Sheets as our Excel substitute.

 


Course Schedule
Course Dates: June 21st - July 1st
Days of the week: Weeknight (Monday - Thursday)
Time (EST): 600p - 900p EST

Part 1: Extracting Data via SQL (Google BigQuery)

In the first portion of the Bootcamp, you will utilize SQL to extract data from a database.

Course 1: Extracting, Sorting, and Filtering 

Monday, June 21st | 6:00p - 9:00p

  • Review of databases, data types, and table files
  • Sorting data
  • Retrieve Data from a Single Table

Course 2: Calculating, Aggregating, and Grouping

Tuesday, June 22nd | 6:00p - 9:00p

  • Calculate formulas using mathematical operations and aggregate functions
  • Summarizing data using GROUP BY function

Course 3: Retrieving Data from Multiple Tables 

Wednesday, June 23rd | 6:00p - 9:00p

  • Extract data from multiple tables at once using joins

 

Part 2: Analyzing Data in Google Sheets

In the second portion of the Bootcamp, you will export data from Google BigQuery into Google Sheets. From here, you will create reports and analyze data while utilizing basic to intermediate formulas. 

Course 1: Importing Data and Formatting

Monday, June 28th | 600p - 900p

  • Overview of inherited data
  • Copying/moving worksheets
  • Color
  • Font
  • Border
  • Page Views
  • Learn how to filter and sort data
    • Top/Bottom filtering
    • Text/Number Filters
    • Custom sorting

Course 2: Mathematical Operations + Vlookups

Tuesday, June 29th | 600p - 900p

  • Cell Referencing
  • Basic math operations (sum, average, sumproduct, etc.)
  • Vlookups - Review one of the most popular formulas in Excel!

Course 3: If Statements 

Wednesday, June 30th | 600p - 900p

  • Learn how to write basic if/then statements
  • Learn how to wrap multiple if statements into one

Course 4: Pivot Tables Overview

Thursday, July 1st | 6:00p - 9:00p

  • Building and design of pivot tables
  • Design layouts
  • Data sources and refreshing connection
  • Slicers
  • Filtering + Sorting

 

 

 

 

 

What's Included:

Portfolio

We will create a portfolio of your completed projects and assignments of all coursework from class as well as provide an instruction guide on how to add the portfolio to your LinkedIn account. Portfolios come in great handy when interviewing for roles that require the technical skills in which you will learn in class.

Certificate of Completion

You will receive a certificate of completion upon submission of all homework assignments and portfolio by the specified deadline.

Refund Policy: No Refunds

Click here for the Installment Payment Option

Course materials (including installation guides), access codes, and reminders will be sent 7 days prior to the start of the first course of the Bootcamp.
$299.00