Level up your SQL, Excel, and Tableau Data Analytics skills in this Intermediate Data Analytics Bootcamp!
This Bootcamp is live and instructor led
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 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
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
- 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
- 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.
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