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
$399.00
Processing ...
Out of stock