Business Analyst Classes Irvine, CA

In this comprehensive Excel bootcamp, participants learn beginner to advanced Excel techniques, including formulas & functions, VLOOKUP, macros, and more. Students learn how to work more efficiently, summarize, and analyze data with tables, charts, and PivotTables. By the end of this hands-on course, participants will be ready to use Excel for everyday business tasks. The course has flexible scheduling options and is available live online or in NYC. Tuition includes hands-on training, a free retake, course manual, and supporting video tutorials.

In this 3-day bootcamp, beginners will be transformed into confident SQL users who can write queries, manipulate tables, and store advanced code. Participants will start by learning about relational databases and SQL fundamentals and will conclude the program having mastered complex retrieval tasks and storing complex code. Topics include composing queries, creating your SQL databases, automating workflow with stored procedures, and step-by-step exercises that will provide an efficient and thorough approach to mastering SQL. Tuition includes hands-on training, a free retake, and a course manual. The course has flexible scheduling options and is available online and in NYC.

In this 18-hour SQL Bootcamp open to beginners, participants will discover the essentials of databases and how to write SQL code to retrieve and analyze data. Through hands-on exercises, participants learn everything from data types to basic queries and advanced topics, including aggregating and joining. Topics include SQL GUI basics, fundamental to advanced querying, table creation, joins, views, functions, and external data connections. The course is taught using PostgreSQL and applies to other relational databases, including SQL Server and MySQL. Participants can retake the course for free within one year.

In this comprehensive 2-day course, participants can become an advanced Tableau user able to work with data to create visualizations and use the various tools Tableau Public has to offer. They will learn to identify datasets to create desired visualizations and then master the Tableau tools on a deeper level to customize their visualizations. By the end of this course, participants will have learned to create maps to represent geographical data, and build actions to control visualizations within sheets and dashboards. Tuition includes hands-on training, a free retake, and a course manual. The course offers flexible scheduling and is available online or in NYC.

Get started with Microsoft Excel in this beginner-friendly course. Learn calculations, basic formulas and functions, tables, charts, and tips for efficiency with hands-on exercises. By the end of this course, you'll build a strong foundation for using Excel as a vital tool in your daily workflow. The course has flexible scheduling options and is available live online or in NYC. Tuition includes hands-on training, a free retake, course manual, and supporting video tutorials.

This introductory Excel course is meant to get new users up and running with the fundamentals of Excel. Students will learn to perform basic calculations, navigate the workbook, and more as they get comfortable with Excel. This program includes free repeats within six months and courseware you can keep for reference later.

This 2-day advanced Excel course builds off the intermediate course to teach users more advanced skills in Excel. Students will learn to work across multiple sheets and workbooks create sparklines and trendlines, consolidate data, use lookup functions, automate workflows with macros, and forecast data. This program includes free repeats within six months and courseware you can keep for reference later.

This 1-day course in Excel Data Analysis with PivotTables is designed to get students started working with PivotTables and PivotCharts. Students will learn how to analyze data from multiple sources and represent that data with PivotTables. This program includes free repeats within six months and courseware you can keep for reference later.

This introduction to SQL gives students basic and intermediate skills in SQL. Students will learn how to use basic SQL security protocols, so database users have added peace of mind. These protocols include assigning roles to individual users, restricting access, configuring SQL security permissions, encrypting data, and creating audit trails. This program includes free repeats within six months and courseware you can keep for reference later.

This course teaches basic and intermediate skills in Microsoft Power BI. BI allows users to transform and combine data from numerous sources. Students will explore concepts like database connection, loading, and grouping, data merges, query syntax, and visualizations. This program includes free repeats within six months and courseware you can keep for reference later.