Data Analytics Weeknight Bootcamp - March

*All course dates are included in the Bootcamp

Course I: Retrieving Data

Tuesday, March 19th | 6:30p – 8: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

Thursday, March 21st | 6:30p – 8:30p

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

Course III: Summarizing the Data

Tuesday, March 26th | 6:30p – 8:30p

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

Course IV: Calculating Mathematical Operations and Formulas

Thursday, March 28th | 6:30p – 8: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

Tuesday, April 2nd | 6:30p – 8: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: Pivot Tables Part I

Thursday, April 4th | 6:30p – 8:30p

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

Course VII: Pivot Tables Part II

Tuesday, April 9th | 6:30p – 8:30p

  • Introduction of Slicers
  • Pivot Table Review
  • Analysis Deep Dive Part I

Course VIII: Pivot Tables Part III

Thursday, April 11th | 6:30p – 8:30p

  • Pivot Table Review
  • Analysis Deep Dive Part II

Course IX: Power BI Basics

Tuesday, April 16th | 6:30p – 8: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

Processing ...