Discover Classes. Earn Rewards.

Data Analytics Technologies Bootcamp

Master the top data analytic tools - Excel, SQL, and Tableau - in this hands-on training at NYIM Training. Gain advanced skills in data analysis and visualization to present actionable insights. Boost your career in data analytics with industry-standard tools.

  • All levels
  • 18 and older
  • $1,949
  • 185 Madison Ave, New York, NY & Virtually Online

Start Dates (4)

  • $1,949
  • NYIM @ 185 Madison Ave 3rd Floor, New York, NY 10016
20 seats left
Book
Show all 8 sessions
  • Mon, Apr 01 at 10:00am - 5:00pm
  • Tue, Apr 02 at 10:00am - 5:00pm
  • Wed, Apr 03 at 10:00am - 5:00pm
  • Mon, Apr 08 at 10:00am - 5:00pm
  • Tue, Apr 09 at 10:00am - 5:00pm
  • Wed, Apr 10 at 10:00am - 5:00pm
  • Thu, May 09 at 10:00am - 5:00pm
  • Fri, May 10 at 10:00am - 5:00pm
20 seats left
Book
Show all 8 sessions
  • Mon, May 13 at 10:00am - 5:00pm
  • Tue, May 14 at 10:00am - 5:00pm
  • Wed, May 15 at 10:00am - 5:00pm
  • Tue, May 28 at 10:00am - 5:00pm
  • Wed, May 29 at 10:00am - 5:00pm
  • Thu, May 30 at 10:00am - 5:00pm
  • Wed, Jun 05 at 10:00am - 5:00pm
  • Thu, Jun 06 at 10:00am - 5:00pm
20 seats left
Book
Show all 16 sessions
  • Tue, May 14 at 6:00pm - 9:00pm
  • Thu, May 16 at 6:00pm - 9:00pm
  • Tue, May 21 at 6:00pm - 9:00pm
  • Thu, May 23 at 6:00pm - 9:00pm
  • Tue, May 28 at 6:00pm - 9:00pm
  • Thu, May 30 at 6:00pm - 9:00pm
  • Tue, Jun 04 at 6:00pm - 9:00pm
  • Thu, Jun 06 at 6:00pm - 9:00pm
  • Tue, Jun 11 at 6:00pm - 9:00pm
  • Thu, Jun 13 at 6:00pm - 9:00pm
  • Tue, Jun 18 at 6:00pm - 9:00pm
  • Thu, Jun 20 at 6:00pm - 9:00pm
  • Thu, Jul 11 at 6:00pm - 9:00pm
  • Tue, Jul 16 at 6:00pm - 9:00pm
  • Thu, Jul 18 at 6:00pm - 9:00pm
  • Tue, Jul 23 at 6:00pm - 9:00pm
20 seats left
Book
Show all 8 sessions
  • Fri, Jun 21 at 10:00am - 5:00pm
  • Mon, Jun 24 at 10:00am - 5:00pm
  • Thu, Jun 27 at 10:00am - 5:00pm
  • Mon, Jul 29 at 10:00am - 5:00pm
  • Tue, Jul 30 at 10:00am - 5:00pm
  • Wed, Jul 31 at 10:00am - 5:00pm
  • Wed, Aug 07 at 10:00am - 5:00pm
  • Thu, Aug 08 at 10:00am - 5:00pm
Showing 14 of 4

Class Description

Description

What you'll learn in this data analyst training:

Learn industry-standard data analysis and visualization tools in hands-on training. Gain advanced skills in Excel, SQL, & Tableau.

Master the top data analytic tools: Excel, SQL, & Tableau. Organize, analyze, summarize, and visualize your data to present actionable insights.

In this comprehensive and affordable classroom training, you'll work on real-world projects in Excel, SQL, and Tableau.

Learn to use Excel and Tableau for data analysis and visualization, and work with SQL to interact with data stored in databases. Go from beginner to advanced in Excel with our Excel Bootcamp, master SQL for databases with our SQL Bootcamp, and become a power Tableau user in our Tableau Bootcamp.

Curriculum

  • Excel for Business Fundamentals
  • Intermediate Excel for Business
  • Advanced Excel for Business
  • SQL Level I
  • SQL Level II
  • SQL Level III
  • Tableau Level I
  • Tableau Level II

Course Overview

  • Aggregate and summarize your data in Excel with formulas & functions
  • Visualize data in Excel with Pivot Tables
  • Create charts and tables to interpret data in Excel
  • Use SQL to sort, filter and summarize data from larger databases
  • Learn advanced database queries and procedures
  • Manipulate, format and understand data in Tableau
  • Present visualizations and create dashboards and stories

Excel, Tableau, & SQL

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

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

Learn more about Data Analytics Technologies Bootcamp at NYIM Training

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYIM Training (742)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

NYIM Training

For nearly two decades, NYIM has trained thousands of business professionals in the latest computer software programs, including Excel, Financial Modeling, Microsoft Office, Adobe, SQL, AutoCAD, QuickBooks, and many more.

The company is known for its practical and hands-on approach to its instructor-led...

Read more about NYIM Training

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

NYIM Training

NYIM Training

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...