Course I: Retrieving Data

Thursday, January 3rd | 6:30p – 9: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

Tuesday, January 8th | 6:30p – 9:00p

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

Course III: Summarizing the Data

Thursday, January 10th | 6:30p – 9:00p

  • Summarizing data using GROUP BY function
  • Perform mathematical operations on multiple fields
  • Calculate formulas using mathematical operations and aggregate function
  • Filter aggregated data with HAVING statement

Course IV: Retrieving Data from Multiple Tables

Tuesday, January 15th | 6:30p – 9: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 V: Pivot Tables Part I 

Thursday, January 17th | 6:30p – 9:00p

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

Course VI: Pivot Tables Part II

Tuesday, January 22nd | 6:30p – 9:00p

  • Introduction of Slicers
  • Pivot Table Review
  • Data Analysis

Course VII: Power BI Basics

Tuesday, January 29th | 6:30p – 9:00p

  • Different Visualization Options
  • Data Analytical Insights
  • Trend Analysis
  • Dashboard Creation