Data Analytics (In Person)

Course I: SQL Beginner Level

When: Sat, Nov 10th 1100a-130p

  • Perform basic queries utilizing different SQL functions and commenting
  • Overview of different data types
  • Utilize conditional operators to filter data

Course II: SQL Intermediate Level Part I

When: Sat, Nov 17th 1100a-200p

  • Perform mathematical operations on multiple fields
  • Aggregate functions
  • Sorting data
  • Order By
  • Converting data types

Course III: SQL Intermediate Level Part II

When: Sat, Dec 1st 1100a-200p

  • Having vs. Where
  • Advanced Mathematical Formulas

Course IV: SQL Inner Joins

When: Sat, Dec 8th 1100a-200p

  • Inner Joins
  • Pivot Table Introduction

Course V: Pivot Table Analysis Part I

When: Sat, Dec 15th 1100a-130p

  • Extract data from SQL to Excel into Pivot Tables
  • Overview of data sourse
  • Basic Pivot Table Navigation
  • Sorting and Filtering

Course VI: Pivot Table Analysis Part II

When: Sat, Dec 29th 1100a-200p

  • Calculated Fields
  • Aggregate functions
  • Layout Preference
  • Basic Analysis

Course VII: Pivot Table Analysis Part III

When: Sat, Jan 5th 1100a-200p

  • Intermediate Analysis

Course VIII: Pivot Table Analysis Part IV

When: Sat, Jan 12th 1100a-200p

  • Intermediate Analysis
  • Power BI Introduction (Importing Data and Navigating Workspace)

Course IX: Power BI Basics and Intermediate

When: Sat, Jan 19th 1100a-200p

  • Creating visualizations
  • Dashboard Creation

Presentations: Sat, Jan 26th 200p-400p

Data Analytics Course Curriculum

Disclaimer: If there are 4 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 and Cancellation Policy: Full refunds will only be provided within 5 days prior to the start of class. If a student has to reschedule a course, and it is outside of the 5 day refund window, there will be no refunds.

*No classes will be held on 11/24 and 12/22 due to the holiday season

$349.00
Processing ...
Data Analytics (Online)

Course I: SQL Beginner Level

When: Wed, Nov 28th 630p-930p

  • Perform basic queries utilizing different SQL functions and commenting
  • Overview of different data types
  • Utilize conditional operators to filter data

Course II: SQL Intermediate Level Part I

When: Wed, Dec 5th 630p-930p

  • Perform mathematical operations on multiple fields
  • Aggregate functions
  • Sorting data
  • Order By
  • Converting data types

Course III: SQL Intermediate Level Part II and Joins

When: Wed, Dec 12th 630p-930p

  • Having vs. Where
  • Advanced Mathematical Formulas
  • Joins

Course IV: Pivot Table Analysis Part I

When: Wed, Dec 19th 630p-930p

  • Extract data from SQL to Excel into Pivot Tables
  • Overview of data sourse
  • Basic Pivot Table Navigation
  • Sorting and Filtering

*Course V: Pivot Table Analysis Part II (Pre-Recorded Due to New Year's Holiday; will not be live)


Course VI: Pivot Table Analysis Part III

When: Wed, Jan 9th 630p-930p

  • Calculated Fields
  • Aggregate functions
  • Layout Preference
  • Basic Analysis

Course VII: Pivot Table Analysis Part III and Power BI

When: Wed, Jan 16th 630p-930p

  • Intermediate Analysis
  • Data Visualization

Data Analytics Course Curriculum

Disclaimer: If there are 5 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 and Cancellation Policy: Full refunds will only be provided within 5 days prior to the start of class. If a student has to reschedule a course, and it is outside of the 5 day refund window, there will be no refunds.

*Class will be held once a week

$199.00
Processing ...