Excel VBA Python SQL Statistics Classes Python Data Science Machine Learning Bootcamp NYC New York : Data Analytics 101 Bootcamp Excel, VBA, SQL & Python

Friday, March 22, 2019

Data Analytics 101 Bootcamp Excel, VBA, SQL & Python

Data Analytics 101 Bootcamp

5 hour Course in Queens Jackson Heights

This one day Bootcamp will cover the below topics:

Data Analytics in Excel: Vlookup, Match, Index, Offset
Advanced Formulas in Excel for Analytics
Data Cleaning in Excel using left right len trim
VBA for Data Analytics Course - Loop through spreadsheets range
Looping in VBA using For, while and Case
SQL Relational Database Concepts - Primary Key / Foreign Key Foreign Key Primary Key Normalization to move your excel data to SQL
Calculations and Analytics in PYTHON
Loops and Functions (for, while)Python for Joins, Group by, Filters

After this session you will be able to:

Automate Excel using VBA, SQL and Python
Understand Charting capabilities of SQL and Python
Get introduced to coding in VBA SQL and Python for Data Analytics

Our instructor has taken several sessions in NYC on Data Analytics and will explain you all concepts in a very eloquent manner.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

New York Python SQL Bootcamp Coding Classes (Affordable & Cost-effective Machine Learning)

The most affordable and cost effective Machine Learning and Artificial Intelligence Bootcamp! Support available from 9 am - 9 pm in campus. Spend 100 hours with the chief instructor in class (no remote or online sessions)! Lowest per hour rate in NYC!

We use MS Azure Noteboooks, AWS Sagemaker, Github, Slack along with games and quizzes to make learning fun.

New York Python SQL Bootcamp Coding Classes (Affordable & Cost-effective Machine Learning). Best Free classes in NYC. SQL 101 & Python 101 Classes. Big Data Science Classes for beginners interested in Analytics & Data Science. Weekend part time and full time classes in Manhattan & Queens. 1 on 1 Tutoring also available. Free weekend 2hrs class. Small group courses (2-3 attendees), free takes and 1 on 1 : Python 101, Python Data Science Immersive Python for Data Analytics. VBA Macros Immersive. SQL 1 day Class.

Project and Portfolio Oriented on weekends and also free evening classes in NYC. Upload your portfolio to get better job. Best Python Class in NYC. FREE RETAKES.

Python 101 and Object Oriented Python Advanced Python 102 SQL Basics
Machine Learning 101 Class Fundamentals Scikit Learn
EDA Charting using Matplot, Seabourne and Pyplot Python Analytics 101
Python Pandas for Analytics (SQL and Excel equivalence) 101
Regression and Logistic Regression - Python and the Math Behind 101
SV, Stochastic Gradient Descent, Naive Bayes Classification
Decision Trees and Random Forest Ensemble Models Class 101
Unsupervised Learning Clustering K-means Neural Network Class 101
Dimension Reduction using PCA, Lasso and Ridge Class 101
Big Data Hadoop Spark Mapreduce Class 101
Natural Language Processing Class 101
Web Scraping Python Class using beautifulsoup and selenium web driver 101
Tensor Flow and Keras Neural Network Class 101
Django 101, Flask Python for Web Development Class 101