Data Analytics Weekend - Saturdays

*All ten course dates are included in the Bootcamp

Course I: Retrieving Data

Saturday, February 9th | 10:30a – 12: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

Saturday, February 16th | 10:30a – 12:30p

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

Course III: Summarizing the Data

Saturday, February 23rd | 10:30a – 12:30p

  • Summarizing data using GROUP BY function
  • Overview of previously learned functions

Course IV: Calculating Mathematical Operations and Formulas

Saturday, March 2nd | 10:30a – 12: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

Saturday, March 9th | 10:30a – 12: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 

Saturday, March 16th | 10:30a – 12:30p

  • Cell References
  • Vlookup

Course VII: Logic Statements

Saturday, March 23rd | 10:30a – 12:30p

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

Course VIII: Pivot Tables Part I

Saturday, March 30th | 10:30a – 12:30p

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

Course IX: Pivot Tables Part II

Saturday, April 6th | 10:30a – 12:30p

  • Introduction of Slicers
  • Pivot Table Review

Course X: Power BI Basics

Saturday, April 13th | 10:30a – 12: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 ...