Intermediate Data Analytics Online Bootcamp: SQL + Tableau

Level up your SQL, Excel, and Tableau Data Analytics skills in this Intermediate Data Analytics Bootcamp!

This Bootcamp is live and instructor led
Price $299
About the Bootcamp
This Bootcamp is best for those with at least beginner data analytics experience and would like to prep for a role as a senior analyst. We will review intermediate SQL and Tableau concepts and analyze query data within Microsoft Excel pivot tables. Prerequisites: You should have at least beginner level SQL (joins are a must!), Excel, and Tableau (basic charts + graphs) skills. 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 Server for SQL.

Course Schedule
Course Dates: Part 1: May 18th - May 26th; Part 2: June 1st; Part 3: June 7th
Days of the week: Weeknights (Varies - Refer to dates below)
Time (EST): 600p - 900p 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: Join Types

Tuesday, May 18th | 6:00p – 9:00p

  • Overview of various join types
    • Full
    • Inner
    • Left
    • Right

Course 2: Subqueries

Wednesday, May 19th | 6:00p – 9:00p

  • Write queries within a query inside of the select statement
  • Learn how to create a table by writing a query in your From statement

Course 3: Text + Date Functions + Totals 

Tuesday, May 25th | 6:00p – 9:00p

  • Utilization of various text and date functions
    • Text location functions
    • Date interval functions
    • Perform subtotals and grand totals within data

Course 4: Case Statements and IIF Statements

Wednesday, May 26th | 6:00p – 9:00p

  • Write if/then statements based on certain conditions using the CASE function
  • Write if/then statements based on certain conditions using the IIF function

 

Part 2: Analyzing Data in Excel

In the second portion of the Bootcamp, you will analyze data in Excel via pivot tables. We will learn how to create pivot tables and analyze our imported SQL data.

 

Pivot Tables Overview

Tuesday, June 1st | 6:00p - 9:00p

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

 

Part 3: Visualizing Data in Tableau

In the third and final portion of the Bootcamp, you will visualize your data in Tableau using dynamic dashboards and advanced visuals.

 

Advanced Visuals + Dynamic Dashboards

Monday, June 7th | 6:00p - 9:00p

  • Maps
  • Donut Charts
  • Dual Axis
  • Dynamic Dashboards

 

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.

 

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 individual completion and submission of all homework assignments and portfolio by the specified deadline.

Refund Policy: No refunds and/or transfers

 

$299.00