Description: Learn how to extract data in SQL using GROUP BY, aggregate functions, and various date functions for effective data organization and reporting.
Prerequisites Knowledge: Prior SQL knowledge of SELECT, FROM, WHERE, ORDER BY, and LIMIT.
NOTE: Register for our SQL Beginner Boot Camp HERE if your current SQL knowledge doesn’t satisfy the prerequisites topics.
Power BI Workshop: How to Update New Data and Troubleshoot Data Errors
Price: $199
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.
Prerequisites Knowledge: Prior knowledge of knowing how to create visualizations in Power BI and a Power BI Pro account for $10 (registration details will be provided prior to the workshop).
NOTE: Register for our Power BI Visualizations Workshop HERE if your current Power BI visualizations knowledge doesn’t satisfy the prerequisites topics.
DATES: Thursday, July 24th 6:00p – 9:00p and Sunday, July 27th 9:00a – 12:00p
Description: Learn how to extract data from multiple tables in SQL using LEFT, RIGHT, INNER, and FULL joins.
Prerequisites Knowledge: Prior SQL knowledge of SELECT, FROM, WHERE, ORDER BY, Dates, GROUP BY, and Aggregate Functions.
NOTE: Register for our SQL Beginner Boot Camp HERE and/or our SQL Intermediate Boot Camp HERE if your current SQL knowledge doesn’t satisfy the prerequisites topics.
DATES: Mondays through Wednesdays starting July 28th through August 6th
