Business Analyst Classes Stamford, CT

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 1-day course gives a foundational understanding of Microsoft Excel. Students with novice computer skills will learn how to manipulate and organize data using Excel spreadsheets. They will also learn how to navigate the Excel interface, create, manage and save workbooks, and perform calculations. This program is available both face-to-face and with live online instruction.

In this 1-day course, students will learn how to use some of the more advanced features of Microsoft Excel. With online and in-person options, students will learn how to work with functions, lists, tables, conditional formatting, charts, and PivotTables. After completing this course, students will be able to leverage Excel’s capabilities to analyze and present data.

In this 1-day course, experienced users of Microsoft Excel can gain advanced skills. Students will learn how to work with multiple worksheets, use lookup functions, create and deploy macros, and use the goal seek feature. Completion of the program ensures that students can use Excel to forecast data and create sparklines.

This course in Microsoft Excel for Office 365 is designed to teach foundational skills in the use of this software. Students will learn the basic functions of Excel, as well as how to create workbooks, insert formulas, format text and numbers, and print workbooks. Graduates of this program will be prepared to sit for the Excel Associate certification exam.

This course teaches the fundamentals of SQL querying. This 1-day program teaches students how to execute a simple query, perform a conditional search, work with functions, and organize data. Further, students will learn how to retrieve data from multiple sources and export query results via a text or XML file.

This 1-day course builds on the fundamentals of SQL querying. This intermediate program teaches advanced querying techniques. The coursework will cover the use of subqueries to perform advanced querying, manipulating table data and table structure. Students will learn how to work with views, index data and manage transactions.

This 3-day introductory course teaches the basics of SQL databases. Through the use of labs and lectures, students will learn the fundamentals of data modeling, the use of relational databases, and the normalization of raw data. Students will also learn how to design relationships, evaluate query performance, and use stored procedures.

Designed for professionals already using data-management tools, this 2-day course introduces basic functions in Tableau. After exploring the fundamentals, students will learn how to connect to, prepare, and explore data, manage and sort data in fields, and apply advanced worksheet filters. Completion of this course will prepare students to create advanced visualizations, maps, and stories.

This intermediate course in Tableau Desktop teaches advanced skills with this data visualization software. This course teaches students how to blend data in order to visualize relationships, clean and organize PDF data, and troubleshoot joins. Students will learn how to manipulate data and use advanced calculations to create data visualizations.

This course teaches the fundamentals of Microsoft Office PowerPoint. Students will begin with an introduction to the user interface and navigation. They will then learn how to develop presentations, format characters, inserts, shapes, and SmartArt, and insert icons and 3D models. The course concludes with a lesson on how to deliver a finished presentation.

This course teaches intermediate skills in Microsoft Office PowerPoint. Intended for novice users who want to learn more about the application’s more advanced features, this program teaches students how to create custom design templates using slide masters and slide layouts. In addition, students gain experience using ink to hand draw elements, building advanced transitions and animations, and adding audio and video elements. Finally, students learn how to set up their slideshow and present it.