Data Analytics Bootcamp Add On

In this Bootcamp, you will learn more than just the usage of SQL, Excel, and Tableau. We will do deep dive data analysis and data modeling as well.

monitor, Magnifier, symbols, symbol, Data, Analysis, Data ...
File:Icon-round-Question mark.svgWhat 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.
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. 
File:Icon-round-Question mark.svgHow Does This Bootcamp Differ from taking the Excel, Tableau, and/or SQL Bootcamp individually?
In this Bootcamp, we perform data modeling and deep dive data analysis. Whereas, if you take the Bootcamp separately, we do not create data modeling connections and perform deep dive analysis. The individual Bootcamps focus on the learning and usage of the technology, while this Bootcamp focuses on not only the learning and usage, but heavy duty analysis and data modeling.

In the first portion of the Bootcamp, you will utilize SQL to extract data from a database.
*All class times are in EST

 

Course 1: Database and Table Review

Monday, July 20th | 5:00p – 6:00p

  • Review of databases, data types, and table files

Course 2: Sorting Data

Tuesday, July 21st | 5:00p – 6:00p

  • Sorting data
  • Retrieve Data from a Single Table

Course 3: Filtering Data

Wednesday, July 22nd | 5:00p – 6:00p

  • Utilize conditional operators to filter data using WHERE

Course 4: Recap, Calculations, and Aggregations

Monday, July 27th | 5:00p – 6:00p

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

Course 5: Summarizing Data

Tuesday, July 28th | 5:00p – 6:00p

  • Summarizing data using GROUP BY function

Course 6: GROUP BY Review

Wednesday, July 29th | 5:00p – 6:00p

  • Review of more GROUP BY exercises

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

Monday, August 3rd | 5:00p – 6:30p

  • Extract data from multiple tables at once using joins

Course 8: Retrieving Data from Multiple Tables (Part 2)

Tuesday, August 4th | 5:00p – 6:00p

  • Overview of previously discussed joins topics
*30 minutes added to the class time

excel icon

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 and pivot tables. 

Course 1: Importing Data

Wednesday, August 5th | 5:00p – 6:00p

  • Import data from SQL into Excel

Course 2: Basic Math Operations

Monday, August 10th | 5:00p – 6:00p

  • Cell Referencing
  • Basic math operations (sum, average, sumproduct, etc.)
  • Sorting/Filtering

Course 3: VLOOKUP

Tuesday, August 11th | 5:00p – 6:00p

  • Review one of the most popular formulas in Excel!

Course 4: Index + Match

Wednesday, August 12th | 5:00p – 6:00p

  • Learn one of the most powerful formulas in Excel, Vlookup's "cousin", Index + Match

Course 5: If Statements (Part 1)

Monday, August 17th | 5:00p – 6:00p

  • Learn how to write basic if/then statements

Course 6: If Statements (Part 2)

Tuesday, August 18th | 5:00p – 6:00p

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

Course 7: Pivot Tables (Part 1)

Wednesday, August 19th | 5:00p – 6:00p

  • Building and design of pivot tables
  • Design layouts
  • Data sources and refreshing connections

Course 8: Pivot Tables (Part 2)

Monday, August 24th | 5:00p – 6:00p

  • More building and design of pivot tables

Course 9: Pivot Tables (Part 3)

Tuesday, August 25th | 5:00p – 6:00p

  • Slicers
  • Design/layout

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: Connecting and Importing Data

Wednesday, August 26th | 5:00p – 6:00p

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

Course 2: Filtering and Sorting

Tuesday, September 1st | 5:00p – 6:00p

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

Course 3: More Filtering + Formatting

Wednesday, September 3rd | 5:00p – 6:00p

  • Review of more filtering and formatting exercises

 

 

 

What's Included:

Image result for briefcase clipart black and white

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

 

$99.00