Business Analyst Classes NYC

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.

In this course for those comfortable with the basics of Excel, participants will learn intermediate-level tools, including PivotTables, splitting and joining text, VLOOKUP, IF Statements, and more. Learn by completing hands-on projects to reinforce concepts. 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 3-day Microsoft Excel Bootcamp consists of three courses and helps students with little to no prior Excel experience go from novice to pro in a couple of days. The first course, Excel for Business Fundamentals, covers the basics, including writing formulas, using absolute references, formatting, common charts and designs, as well as general workbook best practices. The second course, Intermediate Excel for Business, introduces students to more advanced topics, including advanced paste functions, working with text, VLOOKUP, PivotTables, statistical functions, and some advanced charts. The third and final course, Advanced Excel for Business, walks students through some common skills used primarily by more experienced Excel users, including cell management, nested IF statements, What If analysis, advanced analytical tools, INDEX-MATCH, and macros to help automate repetitive tasks. Each course concludes with a final project to help cement the skills students learn in each course.

This 1-day Microsoft Excel course is intended for those who have little to no prior Excel experience looking to build foundational skills working with spreadsheets. This course covers all the basics to make students feel at ease when working with Excel. There are a number of topics covered in this course, including data entry, working with basic formulas, formatting data, an introduction to charts and tables, and workbook management. The course is punctuated by a final project to help review and solidify the major topics covered in the class.

This 1-day Intermediate Microsoft Excel course is designed for individuals with some prior Excel experience but who are looking to add to their Excel toolbelt and continue building their spreadsheet knowledge. There are a number of intermediate topics covered in this course, including learning helpful keyboard shortcuts, working with text, functions (statistical, LOOKUP and logic functions), working with PivotTables, and an introduction to combo charts. The course is punctuated by a final project to help review and solidify the major topics covered throughout the course.

This 1-day Advanced Microsoft Excel course is designed for individuals with a strong grasp on Excel but who are looking to add to their Excel toolbelt and learn advanced functions and features to become an Excel expert. There are several advanced topics covered in this course, including advanced cell management and cell locking, special formatting, advanced functions (like nested ifs), What If analysis, PivotTable calculations and charts, Index-Match, and a Macros primer to help students automate repetitive tasks. The course is punctuated by a final project to help review and solidify the major topics covered throughout the course.

This 24-hour Excel Specialist Certification program will provide students with a hands-on learning experience to ensure they have the skills and confidence to work in spreadsheets like a seasoned professional. This course consists of three sections: Beginner, Intermediate, and Advanced. In the beginner section, students learn the basics of working with spreadsheets and get introduced to formulas, charts, tables, hotkeys, and more. In the intermediate section, students take what they learned in the beginner section but develop those skills and are introduced to new skills, including LOOKUPs, PivotTables, data validation, and more. Finally, in the advanced section, students will build on what they learned in the first two sections while also learning advanced functions, like INDEX-MATCH, working with advanced PivotTable features, and students will learn how macros can help them automate simple tasks. This course also comes with two hours of private training, the Microsoft Excel Specialist Exam, and the course is free to retake to ensure students get the most out of the course.

This certification package will prepare participants for the Excel Expert Certification exam, an official certification from Microsoft. The package includes three Excel courses, four hours of private tutoring, and the certification exam with a free retake. Participants will learn formulas, functions, PivotTables, macros, and more.

In this course, participants will learn the fundamentals of relational databases and begin writing SQL queries to extract data from databases. They will receive essential training in the basics of the three core components of SQL: relational DBMS, SQL, and Microsoft SQL Server. They will work through practical hands-on exercises, writing real SQL code and reinforcing their knowledge of database architecture along the way. 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.

This 3-day SQL Bootcamp consists of three courses (Levels 1-3) and helps students with little to no prior SQL experience go from novice to pro in a couple of days. The first course, SQL Level 1, covers the basics, including an introduction to SQL and relational databases, the graphical user interface (GUI), and some of the coding basics. The second course, SQL Level 2, introduces students to SQL queries and subqueries, using JOINS, math and logic functions, as well as variables and user functions. The third and final course, SQL Level 3, walks students through importing and exporting data, building control structures, temporary tables, and stored procedures. Each course concludes with student labs to help cement the skills students learn in each course.

This 1-day SQL Level 1 course is intended for those who have little to no prior SQL experience looking to learn the basics of relational database management. This course teaches the most important basic concepts to make students feel at ease when working with SQL. There are several topics covered in this course, including a broad introduction to SQL, an overview of the Graphical User Interface (GUI), and a significant focus on code, which teaches students about basic clauses, aggregations, joins, and filters. The course also includes student lab time to review and solidify the major topics covered in the course.

This 1-day SQL course is intended for those with some general SQL experience looking to build up their SQL skills and gain valuable new knowledge about relational database management. This course teaches the many intermediate concepts to increase comfort level when working with SQL. There are several topics covered in this course, including how and when to use various JOINS, how to save queries programmatically, an introduction to subqueries and using subqueries with tables, as well as math functions and other logic statements that are essential for intermediate level SQL users. The course also includes student lab time to help review and solidify the significant topics covered in the course.

This 1-day SQL course is intended for those who are comfortable with SQL and relational databases but who are looking to learn some advanced topics. This course teaches many advanced concepts to increase the students’ comfort level when working with SQL. Advanced topics include how to import and export data and building control structures. This course also includes optional areas of study, including data conversion functions, temporary tables, and working with stored procedures.

In this course, participants will be introduced to the field of data visualization and the various tools Tableau Public offers. They will learn to identify datasets to connect to, explore, analyze, filter and structure data to create desired visualizations. Beginners will learn to understand and manipulate data in Tableau, create their first visualization, distribute and publish their visualization and cover topics such as formatting visualizations, Tableau calculations and creating dashboards and stories. Tuition includes hands-on training, a free retake, and a course manual. The course offers flexible scheduling and is available online or in NYC.

This 2-day comprehensive Tableau course is designed to provide beginners the skills they need to start working in Tableau and creating powerful data visualizations. In the beginner part of the program, students will begin learning the tool's essentials, including data connecting, manipulation, and calculation. Then students will begin to create visualizations from their data with charts, graphs, and dashboards. In the advanced section of the course, participants will learn advanced visualization techniques creating data maps, visualization maps, and custom charts.