Data Analytics Weekend - Sundays

*All ten course dates are included in the Bootcamp

Course I: Retrieving Data

Sunday, February 10th | 2:00p – 4:00p

  • 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

Sunday, February 17th | 2:00p – 4:00p

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

Course III: Summarizing the Data

Sunday, February 24th | 2:00p – 4:00p

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

Course IV: Calculating Mathematical Operations and Formulas

Sunday, March 3rd | 2:00p – 4:00p

  • 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

Sunday, March 10th | 2:00p – 4:00p

  • 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 

Sunday, March 17th | 2:00p – 4:00p

  • Cell References
  • Vlookup

Course VII: Logic Statements

Sunday, March 24th | 2:00p – 4:00p

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

Course VIII: Pivot Tables Part I

Sunday, March 31st | 2:00p – 4:00p

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

Course IX: Pivot Tables Part II

Sunday, April 7th | 2:00p – 4:00p

  • Introduction of Slicers
  • Pivot Table Review

Course X: Power BI Basics

Sunday, April 14th | 2:00p – 4:00p

  • 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