# Data Analytics & AI Certificate

Canonical URL: <https://training-nyc.com/certificates/data-analytics-ai>

## Overview

Thorough training in Excel, Python, SQL, and Tableau builds your expertise in data analytics and artificial intelligence. Essential ground gets covered here, namely how to visualize data, query a database, apply machine learning algorithms, and develop apps powered by AI. Hands-on projects leave you with a professional portfolio that shows your command of analytical techniques employers are looking for.

- **Excel & Tableau Mastery:** Advanced functions, Pivot Tables, and dynamic dashboards become the means by which you work through data and put it in front of an audience.
- **Python for Data & Automation:** Reshaping data, picturing it, and handing repetitive work off to a script are all done through Python libraries, Pandas, NumPy, and Matplotlib among them.
- **Machine Learning Techniques:** Working in Python with scikit-learn and PyTorch, you put predictive models, NLP systems, and recommendation engines into working form.
- **AI Web Application Development:** Flask, with OpenAI's API connected to it, is what you use to produce interactive web apps driven by AI.

## What you'll learn

- Excel, Tableau, and the Python libraries Matplotlib, Seaborn, and Plotly all become ways for you to dig into a dataset and picture it.
- In PostgreSQL, you write the SQL that narrows a result set, joins tables together, and rolls data up across several of them.
- Regression, classification, and ensemble methods in scikit-learn give you models to fit, and you judge how well each one does.
- Dash and Tableau give you the means to put together interactive dashboards and visual stories that get a point across.
- Flask paired with OpenAI APIs becomes the basis for AI-driven web applications, complete with chat assistants and recognition of items from images.
- Beautiful Soup and Requests let you hand the repetitive parts of web scraping and data processing over to Python.

## Curriculum
1. **Excel for Data Analytics**
2. **Data Analytics Foundations**
3. **Python for Data Science Bootcamp**
4. **SQL Bootcamp (PostgreSQL)**
5. **Python for Automation**
6. **Python Data Visualization & Interactive Dashboards**
7. **Python Machine Learning Bootcamp**
8. **Tableau Bootcamp**
9. **Python for AI: Create AI Apps with Flask & OpenAI**
10. **Python Machine Learning Advanced**
11. **Data Science Capstone Projects (Self-Paced)**

## FAQ

### Is this course open to beginners?

Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required.

### Do you offer payment plans or student financing for this course?

This course does not qualify for payment plans or student financing. See our Payment Plan FAQ to find related programs that qualify.

### Can I take this course online (remote learning)?

No upcoming live online dates are currently available. Please contact us about future availability.

### What happens if I need to miss a session?

You have some options: You can watch a recording of the session. We will provide any course materials. Contact us to confirm whether remote attendance is available for your session. You can use your free retake to make up any missed class time.

### What’s included with my tuition?

A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement Expert instructors who are industry professionals and experienced educators that are driven to help you succeed A comprehensive program with 11 in-depth course modules designed to build your skills progressively Top-notch curricula that have been tried and tested over many cohorts and are consistently improved for an optimal learning experience A 1-year free retake policy which allows students to retake any part of the course or program for free to refresh the materials and gain additional practice 30-day access to class recordings to review material at your own pace A certificate of completion to verify your accomplishment Training from an institution licensed by the State of New York, New York State Education Department

### Are there any additional fees or expenses?

There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us. However, if you plan to take the course live online , you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.

### Do you offer any discounts for this course?

This program has a single package price. Additional discounts do not apply.

## Pricing

**Tuition:** $6995
