Data Analytics Weeknight

*All ten course dates are included in the Bootcamp

Course I: Retrieving Data

Thursday, February 7th | 6:30p – 8:30p

  • Overview of relational databases and data flow
  • Database, Schema, and Tables Overview
  • Retrieve Data from a Single Table
  • Conversion and explanation of various data types

Course II: Filtering, Sorting, and Aggregating Data

Tuesday, February 12th | 6:30p – 8:30p

  • Utilize conditional operators to filter data
  • Sorting data
  • Aggregate data using aggregate functions (MIN, MAX, SUM, AVERAGE, COUNT)

Course III: Summarizing the Data

Tuesday, February 19th | 6:30p – 8:30p

  • Summarizing data using GROUP BY function
  • Perform mathematical operations on multiple fields

Course IV: Calculating Intermediate Mathematical Operations and Formulas

Thursday, February 21st | 6:30p – 8:30p

  • Perform mathematical operations on multiple fields
  • Calculate formulas using mathematical operations and aggregate function
  • Filter aggregated data with HAVING statement

Course V: Retrieving Data from Multiple Tables

Tuesday, February 26th | 6:30p – 8:30p

  • Retrieve data from at least 4 tables using Inner Joins

*Excel assessment will be required to be taken by all students to assess skill level within the program. Any students who score less than 70% on the assessment will be required to take a Beginner’s Basics Course prior to the start of the Excel portion of the Data Analytics Bootcamp.

Course VI: Cell Referencing and Vlookup 

Thursday, February 28th | 6:30p – 8:30p

  • Cell References
  • Vlookup

Course VII: Logic Statements

Tuesday, March 5th | 6:30p – 8:30p

  • IF Statements
  • Nested IF Statements
  • Aggregate IF Statements (SUMIF, AVERAGEIF, COUNTIF)

Course VIII: Pivot Tables Part I

Thursday, March 7th | 6:30p – 8:30p

  • Review the navigation of Pivot Tables
  • Change Data Sources
  • Sort and Filter data within Pivot Tables

Course IX: Pivot Tables Part II

Tuesday, March 12th | 6:30p – 8:30p

  • Introduction of Slicers
  • Pivot Table Review

Course X: Power BI Basics

Tuesday, March 14th | 6:30p – 8:30p

  • Different Visualization Options
  • Data Analytical Insights
  • Trend Analysis
  • Dashboard Creation

PC Laptops Required

Disclaimer: If there are 3 or less students enrolled in the course, the course will be cancelled and students will be notified and refunded 24 hours prior to the original start date of the course session.

Refund Policy: No Refunds

*Class will be held once a week

$399.00
Processing ...