Description: Learn how to use AI tools to write, optimize, and troubleshoot SQL queries.
Prerequisites Knowledge: Prior SQL knowledge of SELECT, FROM, WHERE, ORDER BY, Dates, Group By, Aggregate Functions, and JOINS.
DATE: Monday, June 16th
TIME: 6:15p – 9:45p EST
DURATION: 3.5 Hours
SETTING: Virtual ONLY
Description: Learn how to use Pivot Tables in Excel to quickly summarize, organize, and explore your data.
DATES: Mondays through Wednesdays starting June 2nd through June 11th
TIMES: Varies
DURATION: 10 Hours | 6 classes in total
SETTING: Virtual ONLY
Description: Learn the basics of SQL by extracting, sorting, filtering, and calculating data from a database in this beginner-friendly boot camp.
Prerequisites Knowledge: None
DATES: Saturdays and Mondays | Starting June 21st through July 12th
TIMES: 8:45a – 10:45a EST (Saturdays with the exception of Saturday, July 12th: Class will take place from 11:15a – 1:15p) |
8:00p – 9:30p EST (Mondays)
DURATION: 12 Hours | 3 classes and 3 review sessions (6 classes in total)
SETTING: In-Person ONLY
Description: Learn the basics of SQL by extracting, sorting, filtering, and calculating data from a database in this beginner-friendly boot camp.
Prerequisites Knowledge: None
DATES: Saturdays and Wednesdays | Starting June 21st through July 12th
TIMES: 11:15a – 1:15p EST (Saturdays) | 8:00p – 9:30p EST (Wednesdays)
DURATION: 12 Hours | 3 classes and 3 review sessions (6 classes in total)
SETTING: In-Person or Virtual ONLY
Description: Learn how to use Power Query in Excel to clean, transform, and automate your data preparation process.
DATES: Sunday, June 29th 9:00a – 12:00p and Tuesday, July 1st and Wednesday, July 2nd 8:00p – 9:30p
DURATION: 6 Hours | 3 classes in total
SETTING: Virtual ONLY
Description: Learn how to create impactful and dynamic visuals in Power BI to build engaging and informative dashboards.
Prerequisites Knowledge: None
DATE: Sunday, July 6th
TIMES: 9:00a – 2:00p EST
DURATION: 5 Hours
SETTING: Virtual ONLY
Description: Learn how to extract data in SQL using GROUP BY, aggregate functions, and various date functions for effective data organization and reporting.
Description: Learn how to update and schedule data refreshes in Power BI and troubleshoot common data refresh errors to keep your dashboards accurate and up to date.
DATES: Thursday, July 24th 6:00p – 9:00p and Sunday, July 27th 9:00a – 12:00p
DURATION: 6 Hours | 2 classes in total
SETTING: Virtual
Description: Learn how to extract data from multiple tables in SQL using LEFT, RIGHT, INNER, and FULL joins.
DATES: Mondays through Wednesdays starting July 28th through August 6th
TIMES: 8:00p – 10:00p EST
DURATION: 12 Hours | 6 classes in total
SETTING: Virtual