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.
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