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?

Reasons to Hire Me


    Tutor in New York City, New York

    Joshi Shivgan

    My training are tailored for senior executive and seasoned professional who want to manage Data Science Teams / Python Developers and want to make a career switch or aiming career enhancements in their current role.

    Join my NYC boot-camp. 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

    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

    Gigi C

    Online Tutor English, French, Math, Science, Homeschool

    Nancy R

    Motivating, creative tutor for your kids who don’t think they will ever ‘get it’?

    Lisa P

    NJIT Math Major with Tutoring Experience

    Jessica S

    Tutor with experience in English, Reading & Spanish teaching in grades K-12

    latifa D

    I am Latifa, a Math and Accounting tutor. I have over 4 years of experience working with students of all levels.

    More in New York City, New York

    Want to connect with Python?

    Similar Profiles Nearby

    Near New York City, New York

    Gigi C

    Online Tutor English, French, Math, Science, Homeschool

    Nancy R

    Motivating, creative tutor for your kids who don’t think they will ever ‘get it’?

    Lisa P

    NJIT Math Major with Tutoring Experience

    Jessica S

    Tutor with experience in English, Reading & Spanish teaching in grades K-12

    latifa D

    I am Latifa, a Math and Accounting tutor. I have over 4 years of experience working with students of all levels.