Python SQL VBA Class Bootcamp S

Data Science Bootcamp Class SQL VBA Python Blockchain in New York

New York City, New York
Last seen over a week ago

6 years experience

Pay negotiable

Want to connect with Python?

Tutor in New York City, New York

BAINYC[dot]COM
Join my NYC boot-camp: BootcampNYC[dot]QcFinance[dot]in. 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.

Tutoring Data Science at Bootcamp on Python / R, Data Analytics by Shivgan Joshi. Creating the most innovative Bootcamp in New York / Manhattan.

Developed various passive course for bootcamps in Data Analytics and have connections and linkages to a good network (with tutors) in USA and India for best outcome to global learners. Our training theme is centered around projects, for example, your portfolio or even themes you are doing at work. This is very different from the repetitive courses given by other tutors with a fixed syllabus. The outcome of such engagement is a product you can use.

I connect you to the right tutors in NYC, just after you job for an hour, with the right content (so that your exhausted mind can grasp stuff), supported by an offshore team.

I am an Electrical Engineering graduate, GAARP-FRM certified, PG Dip in Fin analysis and Risk Management, PG Diploma in IT, cleared CFA L1, International - MBA (15-16).

Courses that I learned during schooling (in 2011) include Financial Modeling using Excel, CFA L1 and L2, VBA for Financial Modeling, Excel for Equity modeling, Excel for Risk Management, other subjects.

In engineering I did my thesis on "Risk modeling on MATLAB for design". I have learned most of the things with my experience during jobs with Bank and during tutoring for different companies. I posses good balance of academics, profession and modeling and a very chilled and easy going person.
EXPERIENCE
I have experience of tutoring Analytics using SQL, Excel, VBA, Python, R and matlab for Financial, risk, trading, and other applications. matlab for Finance has been by flagship course with the last organization.

Earlier in my career I have worked and also developed several passive recorded courses in analytics.
I have developed courses on Excel optimization to make Excel programming more robust and make excel do the best for you.


Machine Learning vs Statistical Modeling & Supervised vs Unsupervised Learning
Machine Learning Languages, Types, and Examples
Machine Learning vs Statistical Modelling
Supervised vs Unsupervised Learning
Supervised Learning Classification
Unsupervised Learning

AUDIENCE: DATA ANALYSTS OR BUSINESS INTELLIGENCE ANALYSTS (Python)
Data Science Course Curriculum

This course provides data professional with the skills required to solve problems using Python SQL NoSQL and Big Data that involve large data sets such as predicting user behavior on their website, making decisions, or the best way to classify content. Individuals learn how to build the code necessary to be able to make predictions and create models. And is made exclusively for non programmers.
Pre-Work

Introduction to Python

Pillars of programming: Python built-in Data types
Concept of mutability and behavior of different Data structures
Control flow statements: If, Elif and Else
Definite and Indefinite loops: For and While loops
Writing user-defined functions in Python
Read and write Text and CSV files with python
List comprehensions and Lambda
Functional programming and Object Oriented programming in Python
How to start using Python
Parsing information with Python
Practice Python to solve the real-world tasks

Small group courses:

Python 101 $49
3 hours
Print Hello World Azure Notebooks & Anaconda Book and Content Functions (Arguments and Return) Loops (For While) If else List/Dictionary

Intro to Python (Intermediate) $174
9 hours in total, 3 sessions/days of 3 hrs
Print Hello World Azure Notebooks & Anaconda Book and Content Functions (Arguments and Return) Loops (For While) If else List/Dictionary
Nested Loops with if else List/Dictionary (JSON) Class Lambda Functions List Comprehension


Python Immersive $499
35 hours in total, 5 sessions/days of 7 hours each

Print Hello World Azure Notebooks & Anaconda Book and Content Functions (Arguments and Return) Loops (For While) If else List/Dictionary
Nested Loops with if else List/Dictionary (JSON) Class Lambda Functions List Comprehension
File Handling Web Scraping Exception handling SQLite Python
Capstone Project for Github Portfolio


Python for Data Science $499
35 hours in total 5 sessions/days of 7 hours each
Print Hello World Azure Notebooks & Anaconda Book and Content Functions (Arguments and Return) Loops (For While) If else List/Dictionary
Nested Loops with if else List/Dictionary (JSON) Class Lambda Functions List Comprehension
Pandas Plotting Time Series Data Cleaning
Capstone Project for Github Portfolio

Excel VBA 101 / SQL 101 $49
3 hrs / 1 Session / Days
$49

Introduction to Excel VBA / Introduction to SQL (Intermediate) $174
9 hours, 3 sessions / days

Excel VBA Immersive / SQL Immersive (Advanced) $499
35 Total hours, 5 Sessions / Days

Also available* at:
Practical Programming
Address: 115 W 30th St 5th fl, New York, NY 10001
Email me for prices.

Five year of Tutoring experience with various organizations.
Have learned who learned Analytics from various banks and companies.
My online courses on Wiziq had several hundred registrants.
My extensive experience from banks and tutoring helps me to tutor programming in a very relaxing and exciting manner.
VBA Python R Excel SAS SQL using learning from both worlds.
Quant Finance, CFA Quant, FRM Qannt courses taught with the help of Excel.
Have a satellite team based out of India to support your questions that I might not be able to answer.

Subject areas I teach at the bootcamp includes: Quantitative Methods for GRE / SAT / GMAT, CFA L1, FRM L1, matlab/R/SPSS for Quant, Excel-VBA Programming, Quantitiative and Analytics Excel programming & VBA programming.

Sub topics:

Basics of Excel: Vlookups, Hlookups, Index Match, Dependents, Data tables (1 way and 2 ways), Pivots, Charting, Filters, SQL integration, VBA coding, Address and indirect, Offset, Array functions, etc.

Applications: Regression, Histograms, Monte carlo simulation, rank correlation, dashboards, more.
Automation using VBA: Loops (for, do while, case), Recorder, Arrays and Matrices, if else, indexing, etc.


Experience

University/College

University/College


Graduate

Graduate


Want to connect with Python?


Services

Math

Math


Science

Science


Computers

Computers



Training

I have been trained as:

Certified teacher


Recommendations

Richa Joshi

I recommend Python SQL VBA Class Bootcamp S as a tutor

Richa Joshi

I recommend Python SQL VBA Class Bootcamp S as a tutor


Share This Profile


Similar Profiles Nearby

Near New York City, New York

Madhuri T

Good biology and math, pharmacy basics tutor available

Muh M

A teacher who can make SHSAT Math and Regents Earth Science interesting and enjoyable!

Linda T

Experienced Tutor All Abilities K 6

Latchezar B

Experienced Math and Physics Tutor

Chris F

Certified Teacher, Tutor and Coach

More in New York City, New York

Want to connect with Python?

Similar Profiles Nearby

Near New York City, New York

Madhuri T

Good biology and math, pharmacy basics tutor available

Muh M

A teacher who can make SHSAT Math and Regents Earth Science interesting and enjoyable!

Linda T

Experienced Tutor All Abilities K 6

Latchezar B

Experienced Math and Physics Tutor

Chris F

Certified Teacher, Tutor and Coach