Data Analytics Bootcamp (May Saturday Session)

*All course dates are included in the Bootcamp

Course I: Retrieving Data

Saturday, May 18th | 8:00a - 10:00a

  • 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, Jun 1st | 8:00a - 10:00a 

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

Course III: Summarizing the Data

Saturday, Jun 8th | 8:00a - 10:00a

  • Summarizing data using GROUP BY function
  • Overview of previously learned functions
  • Perform mathematical operations on multiple fields

Course IV: Performing Mathematical Operations

Saturday, Jun 15th | 8:00a - 10:00a

  • Calculate formulas using mathematical operations and aggregate function
  • Filter aggregated data with HAVING statement

Course V: Retrieving Data from Multiple Tables

Saturday, Jun 22nd | 8:00a - 10:00a

  • Retrieve data from at least 3 tables using Inner Joins

Course VI: Basic Operations

Saturday, Jun 29th | 8:00a - 10:00a

  • Basic Mathematical Operations
  • Order of Operation
  • Cell References
  • Named Ranges

Course VII: VLOOKUP

Saturday, Jul 6th | 8:00a - 10:00a

  • Cell References
  • Named Ranges
  • VLOOKUP

Course VIII: Aggregate IF Statements

Saturday, Jul 13th | 8:00a - 10:00a

  • SUMIF, AVERAGEIF, and COUNTIF statements

Course IX: Excel Review

Saturday, Jul 20th | 8:00a - 10:00a


Course X: Power BI Basics

Saturday, Jul 27th | 8:00a - 10:00a

  • Different Visualization Options
  • Data Analytical Insights
  • Trend Analysis

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