Business Analyst Certificate NYC or Online: Become a Business Analyst with Hands-on Training

Master the tools of a business analyst and launch your career as a business analyst by learning Excel, PowerPoint, SQL, & Tableau in hands-on classes.

This program is perfect for professionals looking to start a career as a business analyst. In these hands-on classes, you'll work with the key tools you'll need to succeed as a business analyst and get yourself job-ready. Work on real projects in Excel, PowerPoint, SQL, and Tableau to really gain mastery of the tools. You'll boost your resume with some of the most in-demand skills and be ready to succeed on the job.

You'll learn how to work with data in a variety of formats, generate insights from data, automate work, create amazing visualizations, and wrap it all together in a presentation.

The Business Analyst Certificate is open to beginners and requires no prior Excel, PowerPoint, Tableau, or SQL knowledge.

Learn the Skills Guarantee™

Hands-on training in small groups

Work on projects proven to boost retention
Time-tested curriculum and supporting materials

Refined over many cohorts for an optimal learning experience
Learn from industry experts with teaching experience

Experienced educators who are driven to help you succeed
Retake the course for free within one year

Refresh the materials and gain additional practice

Learn the concepts and skills covered in this true or your tuition is on us. See details and terms & conditions.

Excellent classes and excellent venue! It has just the right level of personal attention and class participation. I would highly recommend NYIM and look forward to taking future classes there. – Hazel S.

Courses in this Package

This is the recommended order, but some courses may be taken in a different order.

Unit 1
7 Hours

Excel for Business Fundamentals

Master the core Microsoft Excel functions in this one-day course. Automate calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets while learning tricks to accelerate your workflow.
Unit 2
7 Hours

Intermediate Excel for Business

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Use tools and formulas to format text. Manipulate data visuals with advanced charting skills. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of intermediate Excel, you'll unlock powerful techniques that will help you complete tasks more quickly.
Unit 3
7 Hours

Advanced Excel for Business

Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with macros. Utilize Excel's most important tools with training in core database functions. If you have a strong working knowledge in Excel and want to save even more time with custom shortcuts and advanced features, this is the perfect course for you.
Unit 4
7 Hours

PowerPoint for Business

In this beginner PowerPoint course, you'll create and run dynamic presentations; add images, shapes, animations and layered objects; create tables and charts; and prepare the slideshow for presentation.
Unit 5
7 Hours

Advanced PowerPoint for Business

In this advanced PowerPoint class, you’ll create a reusable PowerPoint Template, make an easily updatable, engaging, consistent presentation, import charts from Excel, use multimedia and layered objects, and record a slideshow.
Unit 6
7 Hours

Tableau Level I

In this course, you will be introduced to the field of data visualization and the various tools Tableau Public offers. Through concepts and exercises, you will learn to identify datasets to connect to, explore, analyze, filter and structure your data to create your desired visualizations.
Unit 7
7 Hours

Tableau Level II

In this course, you dive further into Tableau tools and customization of your visualizations. You will learn to create a variety of maps to represent your geographic data, and build actions to control your visualizations within your sheets and dashboards. This course requires to have completed level I in Tableau.
Unit 8
8 Hours

SQL Level I

Learn how SQL is used within relational database management systems. Connect to SQL Server and write queries with conditions. Use functions to calculate and format data before it’s presented on screen. In SQL Level 1, you’ll learn everything you need to write SQL queries on your own.
Unit 9
8 Hours

SQL Level II

Master views, subqueries, logic statements, and data conversions in SQL Level 2. Combine advanced SQL functions with fundamentals like inner and outer joins to proof your work. Develop your skills in SQL by writing advanced functions to gain more control in your relational DBMS (Database Management System).

Download Syllabus PDF High-level Overview

Business Analyst Certificate Overview

Excel for Business Fundamentals

Introduction

Data Entry
Interface

Formulas

Autofill
Calculations
True or False
AutoSum Functions
Text Functions
Multi-Input Functions
Absolute Cell References

Formatting

Formatting
Format Painter
Conditional Format

Charts & Tables

Line Chart
Column Chart
Pie Chart
Tables

Workbook Management

Printing
Worksheets
Repeat Action
Shortcuts
5 Fundamental keyboard shortcuts and a review of others previously covered

End of Class Project

Project
Save and Close

Intermediate Excel for Business

Worksheet Management

Navigation
Paste Special

Working with Text

Splitting Text
Joining Text
Named Ranges
Data Validation
Sort & Filter
Remove Duplicates

Database Functions

VLOOKUP
HLOOKUP
VLOOKUP - Closet Match

Logical Functions

AND, OR
IF statements

Pivot Tables

Pivot Tables
Pivot Tables & Grouping
Multiple Pivot Tables

Statistical Functions

Ranking
COUNTIFS
SUMIFS

Advanced Charts

Combo Charts

End of Class Project

Project

Advanced Excel for Business

Cell Management

Advanced Cell Locking
Hot Keys
Windows
Cell Auditing

Special Formatting

Date functions
Conditional Formatting-Formulas

Advanced Functions

Nested IF statements
IF statements with AND/OR

What If Analysis

Goal Seek
Data Tables

Advanced Analytical Tools

Data Consolidation
Conditional SumProduct
Pivot Table-Calculations
Pivot Charts

Advanced Database Functions

MATCH function
VLOOKUP-MATCH
INDEX-MATCH
INDEX-Double MATCH

Introduction to Macros

Recording Macros
Relative Macros

End of Class Project

Project

PowerPoint for Business

Introduction

User Interface
File Management

Creating Presentation

Adding Text Using Outline View
Adding Slides

Images

Getting Images
Placing Images
Adjusting/Styling Images

SmartArt

Building Diagrams
Styling Diagrams
Converting Bullet Lists to SmartArt

Shapes

Creating Shapes
Styling Shapes
Adding Text to Shapes
Adjusting Shapes
Text Boxes
Connectors

Layered Objects

Aligning
Distributing
Grouping

Tables

Creating Tables
Designing Tables

Charts

Creating Charts
Designing Charts
Saving Chart Templates

Proofing and Editing

Spell Check
Using Slide Sorter View
Printing

Animation

Slide Transitions
Slide Animations

Running a Presentation

Starting and Stopping a Presentation
Presenting to an Audience
Navigating
Annotating
Using Speaker Notes
Using Presenter View

Advanced PowerPoint for Business

Designing

Slide Masters
Themes and Templates

Collaborating

Using Outlines
Reusing Slides

Commenting

Adding Comments
Replying to Comments

Navigation

Hyperlinks
Action Buttons

Using Multimedia

Video
Audio

Charts from Excel

Paste
Paste Special Paste
Paste Special Paste Link

Tables from Excel

Paste
Paste Special Paste
Paste Special Paste Link

Custom Shows

Building Custom Shows
Running Custom Shows

Recording a Slideshow

Slide Timings
Narration

SQL Level I

Basic Concepts

Microsoft SQL Server
What is SQL?
What are Relational Databases?

The Graphic User Interface

Object Explorer
Query Window
Results Grid
Options

The Code

Basic Clauses
Field and Table Aliases
Creative use of Aliases
Inner Table Joins
Aggregations
Distinct Records
Text Criteria & Operators
Wildcard Filters
Numeric Criteria & Operators

Student Labs

SQL Level II

The Code

Self Joins
Union Joins
Cross Joins

Saving Queries Programmatically

Views
Functions
Stored Procedures
Layered Views
Create Top Value Views

Sub Queries

What is a Sub Query?
Clarity and Transparency
Single Table Sub Query
Multiple Table Sub Query
Exists versus In Operators
Any versus All Operator

Math, Advanced Functions and Logic Statements

Basic Math
Advanced Date and Time Functions
Advanced Text Functions
Case When Then Logic Statements
Variables and User Functions

Student Labs

Creating Views
Sub Queries
Advanced Functions
Logic and Date Functions

Tableau Level I

Understanding Data

What is data
Where to find data
Foundations for building Data Visualizations

Creating Your First visualization

Getting started with Tableau Software
Using Data file formats
Connecting your Data to Tableau
Creating basic charts (line, bar charts, Treemaps)
Using the Show me panel

Tableau Calculations

Overview of SUM, AVR, and Aggregate features
Creating custom calculations and fields
Applying new data calculations to your visualization

Formatting Visualizations

Formatting Tools and Menus
Formatting specific parts of the view
Editing and Formatting Axes

Manipulating Data in Tableau

Cleaning-up the data with the Data Interpreter
Structuring your data
Sorting and filtering Tableau data
Pivoting Tableau data

Advanced Visualization Tools

Using Filters
Using the Detail panel
Using the Size panels
Customizing filters
Using and Customizing tooltips
Formatting your data with colors

Creating Dashboards & Stories

Using Storytelling
Creating your first dashboard and Story
Design for different displays
Adding interactivity to your Dashboard

Distributing & Publishing Your Visualization

Tableau file types
Publishing to Tableau Online
Sharing your visualization
Printing and exporting

Tableau Level II

Intro to Data Maps

Concepts of mapping data
Requirements in mapping data
Formatting geographic data for Tableau
Using Polygon data
Using background images
Using Mapbox maps
Customizing maps layers and map options

Creating Visualization Maps

Creating Choropleth maps
Creating Proportional Symbol maps
Tracking data over time using maps
Creating Spider maps
Creating Heat maps
Density Maps
Distributing and Publishing your map Visualization

Creating custom charts

Cyclical data and circular area chart
Dual Axis Charts
Dual Axis (Layered) Maps
Alluvial Diagram
Ranking Chart
Sheet swapping and dynamic dashboards

Schedule & Enrollment: Business Analyst Certificate

$2,413 $1,995
65 Hours
NYC or Live Online
Free retake
Setup assistance
Expert instructors
Small classes

Policies

Course times are listed in Eastern Time.

Custom Schedule

Enroll
October 6–25 Show package courses

Enroll
- SQL Level I
  
  Oct 6, Wednesday, 9:30am–5:15pm
- SQL Level II
  
  Oct 7, Thursday, 9:30am–5:15pm
- Tableau Level I
  
  Oct 12, Tuesday, 10am–5pm
- Tableau Level II
  
  Oct 15, Friday, 10am–5pm
- PowerPoint for Business
  
  Oct 19, Tuesday, 10am–5pm
- Advanced PowerPoint for Business
  
  Oct 20, Wednesday, 10am–5pm
- Excel for Business Fundamentals
  
  Oct 21, Thursday, 10am–5pm
- Intermediate Excel for Business
  
  Oct 22, Friday, 10am–5pm
- Advanced Excel for Business
  
  Oct 25, Monday, 10am–5pm
October 19–November 18 Show package courses

Enroll
- PowerPoint for Business
  
  Oct 19, Tuesday, 10am–5pm
- Advanced PowerPoint for Business
  
  Oct 20, Wednesday, 10am–5pm
- Excel for Business Fundamentals
  
  Oct 21, Thursday, 10am–5pm
- Intermediate Excel for Business
  
  Oct 22, Friday, 10am–5pm
- Advanced Excel for Business
  
  Oct 25, Monday, 10am–5pm
- SQL Level I
  
  Nov 9, Tuesday, 9:30am–5:15pm
- SQL Level II
  
  Nov 10, Wednesday, 9:30am–5:15pm
- Tableau Level I
  
  Nov 16, Tuesday, 10am–5pm
- Tableau Level II
  
  Nov 18, Thursday, 10am–5pm
November 9–December 16 Show package courses

Enroll
- SQL Level I
  
  Nov 9, Tuesday, 9:30am–5:15pm
- SQL Level II
  
  Nov 10, Wednesday, 9:30am–5:15pm
- Tableau Level I
  
  Nov 16, Tuesday, 10am–5pm
- Tableau Level II
  
  Nov 18, Thursday, 10am–5pm
- Excel for Business Fundamentals
  
  Dec 10, Friday, 10am–5pm
- Intermediate Excel for Business
  
  Dec 13, Monday, 10am–5pm
- Advanced Excel for Business
  
  Dec 14, Tuesday, 10am–5pm
- PowerPoint for Business
  
  Dec 15, Wednesday, 10am–5pm
- Advanced PowerPoint for Business
  
  Dec 16, Thursday, 10am–5pm

This Course is Available Live Online

You can attend this training live online at the scheduled time the course is offered (New York, Eastern Time) through screen-sharing software Zoom (free for you).
Our live online training is interactive and hands-on, just like our in-person classes. There are no extra fees and we’ll work with you to ensure your setup is perfect

Classes are activity-based and taught by a live instructor.
You can hear the instruction, ask questions, and share your screen—all in real-time.
Retake the course for free (in-person or live online) within one year.

See What Students Are Saying About Live Online

“Overall experience on Zoom was maybe even better than in IRL classroom because the instruction takes place right on your own screen, with less distraction. Great overall experience.”
“Given the fact that we had to do this entire class remotely due to Covid-19, I didn’t have very high expectations it would run so smoothly. However, I don’t think it could’ve gone any better. Not only do I feel very comfortable with the program now, but I’m actually excited to use it!”
“This was the first online class I’ve taken with ND and it was a great experience. Looking forward to the other classes I’ve signed up for!”

Learn more about how our live online training works

Online Training Demo

1-Minute Overview

Frequently Asked Questions

Does this course require any prior knowledge or experience?

Students must be comfortable using a computer. No other prior knowledge is required.
Do you offer any discounts for this course?

Discounts

This program is a discounted package of classes that is 15–25% off the individual class prices.
Do you offer payment plans or student financing for this course?

This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
Can I take this course online (remote learning)?
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).

How does attending “live online” work?
- Students can attend this training remotely through screen sharing software (we use Zoom).
- Participants can hear the instruction, ask questions, and even share their screen with the instructor.
- For audio you can use your computer’s microphone/speakers or call a phone number that we’ll provide.
- Classes are activity-based and taught by a live instructor, so we strongly encourage students who are local to the area to attend in person!
- You will need your own computer and copy of any required software. If you don’t have the software, you can usually do a free trial or purchase your own license. If you need assistance, contact us at contact@nyimtraining.com

Corporate & Onsite Data Analytics Training

Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.

Private Training

Available onsite at your location
Modern computer labs available at our offices
Customize or choose from our existing courses
Free instructor consultations to finalize content

Group Class Vouchers

Send employees to our group classes
Extensive offerings and flexible scheduling
Simple billing and logistics
Computers and training resources provided

Core Skills for a Business Analyst

Excel for Business Bootcamp

In this part of the program, you'll build your foundational analytics skills with the most commonly used analytics tool, Microsoft Excel. You'll go from a beginner to a master of Excel in just 3 days in this intensive Bootcamp. You'll learn to do things you didn't even know were possible in Excel and become a powerful and efficient Excel user. You'll learn to manipulate data, create charts, make Pivot Tables, automate workflows, and a whole lot more in Excel.

Enter, clean, and format data in Excel
Create charts and tables from datasets
Work with text functions to split, join, and do more with text
Learn database functions like VLOOKUP, HLOOKUP, and INDEX-MATCH
Analyze data using Pivot Tables and advanced charts
Perform what-if analyses and use goal seek to find the desired outcome
Learn advanced functions and Excel tricks to speed up your work
Automate workflows with macros

PowerPoint for Business

Another key skill for a business analyst is being to build professional presentations in PowerPoint. You'll learn beginner to advanced techniques in PowerPoint, from the basics of adding content to slides to creating reusable templates and import data from Excel. Combine your analytics skills with presentation skills to make data-driven insights and share them with decision-makers in powerful presentations.

Create presentations in PowerPoint
Add images, shapes, animation and more to your slides
Import data from Excel
Create charts and tables
Learn advanced PowerPoint design tools
Create reusable templates
Leverage Slide Masters, Themes, and Templates

Tableau Bootcamp

Master Tableau in just 2 days in this hands-on training to perform analysis and create amazing visualizations in Tableau. Tableau is a commonly used data visualization tool that allows users to connect to datasets, manipulate data, and easily create advanced visualizations beyond Excel. You'll learn to connect to data, analyze it, and create a variety of visualizations in Tableau.

Import data into Tableau
Manipulate data and perform calculations
Sort, filter, and pivot your data
Create visualizations and dashboards
Share and publish your visualization
Create data maps and custom charts in Tableau

SQL Level 1 & 2

Learn SQL, the most commonly used language for interacting with databases. Understand the fundamentals of relational databases and start querying data from databases. Then, you'll move to more advanced querying techniques so you can easily pull, manipulate, and combine data from multiple databases. SQL is a relatively easy-to-learn language that enables you to work with databases and is crucial for a business analyst.

Understand relational databases
Start querying in SQL
Join and aggregate data
Work across multiple tables with joins
Write subqueries for simpler code
Advanced functions, math, and logic with SQL

Free Resources

showing 4 of 4 resources

Learn the Skills Guarantee™

Hands-on training in small groups

Time-tested curriculum and supporting materials

Learn from industry experts with teaching experience

Retake the course for free within one year