Data Analytics is the process of manipulating and analyzing data to understand and uncover insights that can influence business decisions. Learn the essential data analytics tools including Excel, SQL, and Tableau in hands-on classes in NYC.
We provide corporate Data Analytics training to get your team up to speed as quickly as possible. We’ll even customize the training to fit your company’s specific requirements.
Inquire now
Rated the best Data Analytics classes in New York City
I took a SQL level 1 class on a Saturday and it was soo helpful. The instructor was humorous, extremely knowledgeable, and was an efficient communicator. He knew exactly how SQL was utilized in a real-world business aspect and was able to give examples of times you'd need to use certain queries and how they can be used most effectively.
Eric B. attended SQL Level 1
We hired NYIM training to provide Microsoft Excel training for UJA staff and it was the best technical training I have seen. Mourad Kattan is an outstanding facilitator and he packed the session with useful information and tips for everyone who was in the room. Also, additional video provided after the session helped to solidify the learning and review everything independently. Looking forward to bringing NYIM to UJA again in the near future!
Yelena K. attended Excel for Business Bootcamp
I have taken two Excel classes at NYIM and they were both fantastic. Garfield is a really skilled teacher and I learned so much! I plan on taking more classes when I can. Highly recommend these classes!
Sandhya B. attended Intermediate Excel for Business
Just came out of my Excel Business training at NYIM. Garfield, the instructor, is really nice and very helpful. They are very professional and they provide all the necessary tools for the students to acquire all the info they need, and, in case you want to refresh your memory you can always retake the course for free within 6 months. Cool, huh?
Dana D. attended Excel for Business Fundamentals
Overall great experience in taking the Intermediate Excel Class today! Content was well organized and had appropriate progression from easy to more complex examples. Garfield, our instructor, was very knowledgabe, patient, and thorough. He also had a great sense of humor and kept the class interesting, time really flew by! I will be back to take the Advanced class and also the VBA.
Patrick M. attended Intermediate Excel for Business
The class was amazing and the instructor was superb!
Melissa L. attended Intermediate Excel for Business
This was an amazing class and the instructor made you want to learn. If you want to learn in a great environment, this is the class for you.
Husniyyah A. attended Excel for Business Fundamentals
SQL Level 1 is a great course to introduce you to writing SQL queries. Starting with the basics, by the end you will understand complex queries with inner or outer joins. Peter was our instructor and his customized course material is very well laid out with practical examples. You work on a local sample database, so you can type notes and test your queries to better understand the output you get. The facility is neat, the equipment is fairly new and ready to use, and beverages are provided.
Martie B. attended SQL Level 1
I recently started taking classes at NYIM Training, I have found the instructors to be very knowledgeable and professional. NYIM Training offers a number of different courses which includes SQL, Excel, PowerPoint, AutoCAD, VBA, Photoshop, Illustrator, InDesign, and QuickBooks. The price per course is very reasonable and they offer special pricing if you take a series of 3 courses in one particular subject.
I would highly recommend them.
Rob G. attended Excel for Business Fundamentals
The course was very informative and the instructor did an excellent job going over the material. I will be looking to attend the additional courses in the nearby future. Thank you.
Anonymous attended Excel for Business Fundamentals
Took the SQL level 1 course with no prior knowledge. It was extremely helpful and it went a pace slow enough for me to understand, while being fast enough that I did not get bored.
Jack D. attended SQL Level 1
SQL level 1 was a great class to introduce SQL and to practice it. The instructor, Peter, was very informative and made sure we understood the concepts before moving on. He did a great job of testing our knowledge throughout the class.
Great beginners class! The instructor was entertaining as she taught. Learned the fundamentals! I would definitely recommend this course.
Randie S. attended SQL Level 1
The class was very informative, the instructor was very detailed & I highly recommend the course for all SQL beginners.
Kevin M. attended SQL Level 1
I took SQL Levels 1, 2 and 3 with Peter. He is a great instructor who provides practical training you experience with databases. He was very clear with the explanations. Highly recommended!
Naveed K. attended SQL Level 1
I had a great experience in my level 2 Excel for business course. The instructor, Garfield, was very knowledgeable and patient with questions. He taught all the sections effectively and I really feel like I learned a lot from that one day session.
NYIM has a really nice facility with modern computers (Macs too). The fact that they give you the chance to re-take a class free of charge within a year after the first one is amazing. I highly recommend their courses and will definitely be taking another class, or two!
Tessa P. attended Intermediate Excel for Business
Garfield was very knowledgeable and took his time working with my group. Whenever one of us didn't understand he was more than happy to slow down and figure out where we were confused. Definitely recommend this place!
Sanura D. attended Intermediate Excel for Business
Took a retake of Excel class with Garfield. He is the best. He is patient, focused and explains everything in the clearest and easiest to understand manner. Beginners and experts will be equally impressed with his teaching ability. If you want to learn Excel or just refresh, Garfield is your guy!
Stacey B. attended Excel for Business Fundamentals
Had an amazing experience taking Excel for Business Level 2 at NYIM. The excel class helped me get back up to speed on a ton of fundamental techniques and short cuts, and the instructor was awesome. They even gave us videos to look at after we finished the class for some extra help on our own time. The actual location was convenient and comfortable, they gave us coffee tea and chcocolate- an overall great experience. Will definitely be going back for level 3.
Eddie H. attended Intermediate Excel for Business
Garfield and Michael were great, did the bundle, both were very generous with their time and explained information thoroughly.
James B. attended Excel for Business Bootcamp
Great class! The content was well organized and the instructor was excellent. He was engaging, knew the material very well and was able to adjust to the various levels of ability of the students! Would definitely recommend!
Rebecca H. attended Advanced Excel for Business
The instructor Garfield was patient, informative and precise!
Lisa N. attended Intermediate Excel for Business
Garfield is an outstanding teacher who instructs in Excel in a logical, concise & easy to understand manner. He is also kind and affable. The school is run very well by Nick and they offer candy, coffee and hot chocolate! Michael is also a very good instructor & I now know enough Excel to work anywhere -- in just 2 sessions!!
Georgiana E. attended Excel for Business Fundamentals
I took an amazing class with Michael. He is a great instructor and the course curriculum is very hands on. Thank you NYIM!!!
Joe K. attended Excel for Business Fundamentals
Just finished excel level 2 class. Went to review my excel skills before starting new job but ended up learning new tricks and functions also. The lecturer (Garfield) was very calm,kind, and informative. Thank you, Garfield!
Bokyong A. attended Intermediate Excel for Business
One-on-one Excel training with Garfield was amazing. Would highly recommend Garfield and the NYIM for any kind of Excel training or support.
Janet W. attended Excel for Business Fundamentals
I retook this course. Garfield did not teach my first course but he taught my second course. He is a fantastic teacher. He is so clear and methodological. I highly recommend this class.
Dominika J. attended Intermediate Excel for Business
Had a one on one training with Garfield - he was patient, professional, and incredibly knowledgeable. Would highly recommend for anyone looking to expand their excel capabilities in business.
Alexandria A. attended Advanced Excel for Business
Great school and Garfield is my favorite teacher. I've taken 2 excel classes with him and it's been very helpful. He is very clear and explains all the ins and outs.
Emily I. attended Excel for Business Fundamentals
Great Excel Training! Garfield does a great job at instilling actionable tips and shortcuts that can really be used ASAP! Would recommend to anyone looking enhance their skillset!
Aston F. attended Intermediate Excel for Business
I recommend NYIM highly because they are a pleasure to work with. Nick was wonderfully helpful and Michael is a patient excellent teacher. Thanks so much!
Teri B. attended Excel for Business Fundamentals
Thank you Michael for teaching this course!! Your knowledge of the material really help me to feel confident in taking what I've learned in the classroom and applying it to my newly assigned work projects. I would recommend this class to anyone wanting a better understanding of Excel.
Tracy A. attended Intermediate Excel for Business
Great Excel class! I'm a pretty seasoned Excel user, so there were parts that were definitely review, but I still learned a whole lot. Michael kept the pace up, though not too fast, and he wasn't married to his agenda. He was flexible and was willing to answer questions at any time. The course materials were great, too, and there was sufficient time built in for completing exercises. I highly recommend.
Kate S. attended Excel for Business Fundamentals
Fast-paced class, a lot of information in a short amount of time - condensed to most useful tips and tricks. Very glad I was able to participate as I learned a lot more than I already knew. Michael was a great instructor with a very easygoing vibe.
Roksana B. attended Excel for Business Fundamentals
Michael was great with the excel training that was done at my company today. Though I knew basic excel, today I learned new tricks and new functions regarding excel.
Joanna M. attended Excel for Business Fundamentals
This class was very informative. I would highly recommend it for everyone and anyone whether you're highly experienced in excel, or a beginner. Instructor Michael was very helpful, patient, and answered every question with confidence.
Christopher A. attended Excel for Business Fundamentals
Michael Magreta is Excellent! This is my 3rd course at NYIM Training - every class offers all that I needed an much much more!
Susan C. attended Excel for Business Fundamentals
It was a full day from 10am-5, fast-moving and packed with information on all the Excel basics, including on-the-spot exercises. Really useful for skills in managing all kinds of information and projects. I'd highly recommend this course, and would like to take the L2 when I'm ready!
Kathleen H. attended Excel for Business Fundamentals
Excel for Business Level 1: Garfield was a great teacher. He was thorough on each topic. The class moved at a good pace and a lot was covered in the day. I will return for the second class.
Mary Kate M. attended Excel for Business Fundamentals
This course exceeded my expectations.Saba is a great instructor! She answered all my questions and went beyond to link it to real life examples.
Laura H. attended Excel Programming with VBA
Saba made the class non- intimidating and informative due to her casual approach, teaching from the basics forward and her helpfulness with every little question. I did like that the class was small and hands on with computers.
N.B. attended Excel Programming with VBA
Saba really knows her stuff! Lively attitude kept things interesting. She was very interactive and engaging us in the class.
V.B. attended Excel Programming with VBA
I don't even know what else Saba could have done to make the class better - she was so on point and really interesting.
L.P. attended Excel Programming with VBA
Thank you for the session! It was really helpful and I've learned a lot from Joe.
Become an Advanced Microsoft Excel user in just three days. Begin with data entry, charts, and essential shortcuts in Excel Fundamentals. Go to the next level with Pivot Tables and statistical functions in Intermediate Excel. Automate your workflow by recording macros in Advanced Excel. You'll learn everything you need to know to become an Excel pro in 21 hours. This package includes three Excel classes - Fundamentals, Intermediate, and Advanced - at a 15% discount.
Master advanced SQL functions including ‘Case When Then’ statements, stored procedures, and temporary tables. Connect to external data sources like Microsoft Applications applications and manipulate data with constraints, indexes, and triggers. In SQL 3, you’ll gain the skills to begin a career in database management.
This three-day bootcamp guides beginners into confident SQL users that can write queries, manipulate tables and store advanced code. On Day 1, you will define instructions and compose basic queries. Next, you’ll create views, subqueries and conversion functions. By Day 3, you will create your own SQL database, import and export data from Microsoft Office applications and automate workflow with stored procedures. This SQL Bootcamp package includes our Beginner, Intermediate, and Advanced SQL classes at a 15% discount.
Master the core 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 MS Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets while learning tricks to accelerate your workflow.
Learn how SQL is used within relational database management systems. Connect to SQL Server and writer 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.
Go from beginner to experienced professional with Pivot Tables, advanced functions, and combo charts in Intermediate Excel. 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.
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.
Learn the fundamentals of VBA, Excel's programming language, in instructor-led training at NYIM. This project-based VBA course concentrates on the automation of repetitious Excel tasks and reports. Write macros to automate your Excel tasks even if the data is not consistently formatted, create custom Excel applications and environments, and create custom Excel Add-ins to increase the functionality of the program.
In this intermediate SQL training, you will code subqueries to generate query output, manipulate table data, create tables, create views and manipulate data through views, and create indexes on table columns.
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 their data to create their desired visualizations.
In this course, you dive further into tableau tools and customization of your visualizations. This course requires to have completed level I in Tableau.
In this increasingly tech-enabled world, everything from washing machines to doorbells connects to wifi. There has never been a more exciting time to learn about data! According to Forbes, more than 50% of companies are analyzing Big Data (a fancy term for massive datasets).
Data Analytics is the process of manipulating and analyzing data to understand and uncover insights that can influence business decisions. Companies use these insights to target and adjust their efforts to reach their target audience. Customer and social analysis are among the primary goals for data analytics in most companies.
Data Analytics vs. Data Science
Like data analytics, data science is also a hot topic but involves an entirely different set of skills and tools. Data science is the study of data, with the focus of using algorithms, mathematics, and techniques to extract useful data from non-traditional data sources. While data analytics relies on readily available data, data science focuses on how to extract this data into a usable form that can be processed and analyzed with data analytics software.
Data scientists use tools like the coding language R and Hadoop framework to “scrape” or extract raw data from a website. In data science programs, students often learn how to “scrape” public websites with lots of raw data, such as Twitter or Google. Examples may include writing an algorithm to produce all results in a web directory or finding all of the records containing a specific word on a public site.
Another way to look at the difference between data science and data analytics is to view data science as preparing data before analysis, and data analytics as reviewing data after the fact. Data scientists are experts in data extraction, cleaning and preparation while data analysts are experts in uncovering trends and actionable insights. Despite being similar in name, data science and data analytics involve entirely different processes, tools, and functions of data.
Data Analytics Jobs
Data analytics jobs fall into different categories depending on your knowledge of programming and statistics. Most data analytics jobs fall within the business analyst role, in which data professionals work with Excel and Tableau. Some may have additional skill in a programming language or other specialized software.
Most data analytics professionals must incorporate data from a variety of tools to form one coherent story. A campaign targeted to customers including website traffic, social media, and other forms of marketing can form three separate data sources. To determine which strategies are most effective and identify new approaches that can lead to even more customer engagement and sales, data analysts often import data into one program.
Business analysts typically use tools, such as Microsoft Excel or another tool to analyze data and Tableau or another visual tool to communicate actionable insights to decision makers. Statisticians take data analytics a step further by using R, SPSS, or other statistical analysis tools to determine risk or make predictions. Other data analysts work within large databases, such as SQL or Microsoft Access.
Data Analytics Tools
Microsoft Excel
Despite being a popular tool that most individuals have on their personal and business computers, very few people harness the complete power of Microsoft Excel. Microsoft Excel is a data analytics powerhouse that offers support at every stage of the data analytics process from cleaning and analyzing data to performing analysis and displaying results in charts and graphs. Its most advanced users write macros (complex instructions that automate computer tasks) using Visual Basic for Applications (VBA), a coding language used to program Excel.
Microsoft Excel can do the following tasks:
Reformat data
Use formulas to calculate new values from existing data
Forecast financials using equations and functions
Complete math functions and statistical analysis functions like ANOVA and regression
Display results and analysis using pie, line, and bar charts
SQL (whether it’s pronounced ess-que-el or SEQUEL is up for debate) is a coding language used to store, organize, and retrieve data from relational databases. With SQL you can analyze data for an e-commerce store by joining multiple datasets or tables to gain new insights. For example, you can query and merge two datasets, one containing customers and another containing orders to determine all of the customers that bought a specific product and their particular location.
It is important to note that SQL is not a database itself, but rather a command language used to communicate with a relational database, most commonly Microsoft SQL server.
In recent years, programmers have created adaptations of SQL to use with modern object-oriented or non-relational databases. With SQL, you can perform the following tasks:
Create a database
Sort and/or filter data within a database
Query a database to find specific information about a product or user
Join two different datasets to view information that meets specific criteria
Convert output data or export it to external applications
Tableau is a powerful tool that allows you to visualize your data analysis. The benefit of Tableau is that non-technical professionals and decision-makers can immediately notice trends and data insights without pouring over detailed reports or data sets. Tableau is useful in any industry with access to data and is a popular tool in both the public and the private sector.
With Tableau, you can do the following:
Connect raw datasets from almost any program including Microsoft Excel, SQL, Microsoft Access, and SPSS
Use Tableau Prep® to clean and analyze data for further analysis
Analyze trends and stories within your data
Create responsive insights that can be customized by colleagues
Manipulate interactive charts, graphs, and other representations of data
Microsoft Access is a database program that is part of the Microsoft Office Suite. It’s a local application, so it’s not available online with other Office 365 products, and it must be downloaded to a desktop computer. It’s considered a user-friendly alternative to SQL server, particularly for non-technical professionals.
Microsoft Access is an ideal choice for individuals and small teams that need to analyze massive data sets. Excel is limited in its ability to analyze large amounts of data quickly, and access speeds up the process while adding more features including higher data storage capacity and additional security. Use Microsoft Access to do the following:
Create databases and store new data
Analyze large data sets over extended periods (ex., five-year, ten-year analysis)
Easily transfer data between Microsoft applications
Offer an easy-to-use alternative to server-based databases for non-technical professionals
Create and publish PDF reports or export data
SPSS
Statistical Package for Social Science (SPSS) is a software program used to perform complex quantitative statistical analysis. The program includes features to clean, recode, analyze, and visualize data characteristics. Data preparation features like recoding data and transforming variables are standard in SPSS but could take hours in Excel.
An essential feature of SPSS is its ability to determine if a particular finding is statistically significant and applicable to larger populations outside of the sample size.
Users can write scripts to automate data analysis or write code in Python to enhance performance capabilities. SPSS is an excellent tool for the following tasks:
Using advanced data manipulation tools to recode and format data
Conducting complex data analysis including ANOVA, regression and factor analysis
Determining the statistical significance of a given result
Connecting data with other programs
Creating descriptive graphics to visualize data range and outliers
Data Analytics Training & Certifications
If you’re new to data analytics, it’s best to start with MS Excel classes. Beginner, Intermediate, and Advanced courses teach Excel fundamentals from formulas to pivot tables and functions, or if you’re looking to enhance your resume, our Excel certification program includes classes, private training, and the certification exam at one low price. Topical courses are a good fit if you are using Excel for Financial Modeling.
SQL courses teach you everything you need to know about relational databases from data types, how to query and retrieve data to creating custom views, tables, and indexes. Our advanced course and 3-day bootcamp introduce data storage and temporary tables.
When you’re ready to share results and visualize data, Tableau Level 1 introduces data visualization and basic functions while Tableau Level 2 builds upon data visualization map techniques and guides you through creating custom charts.
