Data Analytics Online Bootcamp: SQL + Excel + Tableau

Learn how to extract, analyze, and visualize data with our Beginner Data Analytics Bootcamp!

All Bootcamps are held online due to COVID-19
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 Oracle MySQL  for SQL, Microsoft Excel, and Tableau for our data visualization tool.

Course Schedule
Course Dates: February 15th - March 11th
Days of the week: Weeknight (Monday - Thursday)
Time (EST): 630p - 730p EST

Part 1: Extracting Data via SQL

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

Course 1: Database and Table Review

Monday, February 15th | 630p - 730p

  • Review of databases, data types, and table files

Course 2: Sorting Data

Tuesday, February 16th | 630p - 730p

  • Sorting data
  • Retrieve Data from a Single Table

Course 3: Filtering Data

Wednesday, February 17th | 630p - 730p

  • Utilize conditional operators to filter data using WHERE

Course 4: Recap, Calculations, and Aggregations

Thursday, February 18th | 630p - 730p

  • Calculate formulas using mathematical operations and aggregate functions
  • More data filtering

Course 5: Summarizing Data

Monday, February 22nd | 630p - 730p

  • Summarizing data using GROUP BY function

Course 6: Retrieving Data from Multiple Tables (Part 1)

Tuesday, February 23rd | 630p - 730p

  • Extract data from multiple tables at once using joins

Course 7: Retrieving Data from Multiple Tables (Part 2)*

Wednesday, February 24th | 630p - 730p

  • Extract data from multiple tables at once using joins

Part 2: Analyzing Data in Excel

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

Course 1: Importing Data + Basic Math Operations

Monday, March 1st | 630p - 730p

  • Import data from SQL into Excel
  • Cell Referencing
  • Basic math operations (sum, average, sumproduct, etc.)
  • Sorting/Filtering

Course 2: VLOOKUP

Tuesday, March 2nd | 630p - 730p

  • Review one of the most popular formulas in Excel!

Course 3: If Statements (Part 1)

Wednesday, March 3rd | 630p - 730p

  • Learn how to write basic if/then statements

Course 4: If Statements (Part 2)

Thursday, March 4th | 630p - 730p

  • Learn how to wrap multiple if statements into one
  • Perform nested if statements
    • Combining multiple formulas/functions in if statements

Part 3: Visualizing Data in Tableau

In the third and final portion of the Bootcamp, you will visualize data in Tableau. Tableau brings your data to life with dynamic charts and graphs that can be used to visually tell a story.

 

Course 1: Data Visualization Introduction

Monday, March 8th | 630p - 730p


Course 2: Connecting and Importing Data

Tuesday, March 9th | 630p - 730p

  • Understand Tableau and its components
  • Import multiple data sets via Excel and text files
  • Creation of visualizations using different charts and graphs

Course 3: Filtering and Sorting

Wednesday, March 10th | 630p - 730p

  • Filter data in visualizations
    • Top/bottom
    • Advanced filtering
    • Pages

Course 4: More Filtering + Formatting

Thursday, March 11th | 630p - 730p

  • Review of more filtering and formatting exercises

 

 

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

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