# Data Analytics & AI Certificate

Canonical URL: <https://www.creativelive.com/learning-path/data-analytics-ai>

## Overview

Develop expertise in data analytics and artificial intelligence through comprehensive training in Excel, Python, SQL, and Tableau. This program covers essential skills in data visualization, database querying, machine learning algorithms, and AI-powered app development. Through hands-on projects, you will build a professional portfolio that demonstrates your proficiency in high-demand analytical techniques.

- **Excel and Tableau Mastery:** Learn to analyze and present data with advanced functions, Pivot Tables, and dynamic dashboards.
- **Python for Data and Automation:** Use Python libraries such as Pandas, NumPy, and Matplotlib for data manipulation, visualization, and automated tasks.
- **Machine Learning Techniques:** Implement predictive models, NLP systems, and recommendation engines with Python's scikit-learn and PyTorch.
- **AI Web Application Development:** Build interactive, AI-driven web apps using Flask integrated with OpenAI's API.

## What you'll learn

- Analyze and visualize datasets using Excel, Tableau, and Python libraries like Matplotlib, Seaborn, and Plotly.
- Write SQL queries to filter, join, and summarize data across multiple tables using PostgreSQL.
- Build and evaluate machine learning models with scikit-learn, including regression, classification, and ensemble methods.
- Develop interactive dashboards and visual narratives using Dash and Tableau for clear data communication.
- Create AI-driven web applications with Flask and OpenAI APIs, integrating features like chat assistants and image-based item recognition.
- Automate web scraping and data processing tasks in Python using libraries like Beautiful Soup and Requests.

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

**Skills covered:** Excel, Python, SQL, Tableau, Data Analytics Principles, Machine Learning, Matplotlib, Pandas, NumPy, Data Analytics Portfolio

## Instructors

### Jerron Smith — Program Director & Senior Instructor

Jerron has more than 25 years of experience working with graphics and video and expert-level certifications in Adobe After Effects, Premiere Pro, Photoshop, and Illustrator along with an extensive knowledge of other animation programs like Cinema 4D, Adobe Animate, and 3DS Max. He has authored multiple books and video training series on computer graphics software, such as After Effects, Premiere Pro, Photoshop, Illustrator, and Flash (back when it was a thing). He has taught at the college level for over 20 years at schools such as NYCCT (New York City College of Technology), NYIT (The New York Institute of Technology), and FIT (The Fashion Institute of Technology).

## Pricing

**Tuition:** $6995

Payment options: Student financing available; see the current application terms, pay-as-you-go installments, and GI Bill accepted.