What we're about

Learn Investment Finance for Design, Fashion, marketing, HR

If you want to learn Basics of Finance & Investing this meetup is for you.

We talk about crypto investing, other financial topics in this group for complete newbies.

Discuss markets and investments that you can do for your portfolio including equity, real estate and crypto.

Upcoming events (4+)

VBA Macros for MS Excel Data Analytics (6 hour) $325 Online Event

A comprehensive VBA Macros for MS Excel Data Analytics crafted by experts....

*With Changing scenario, the event is rescheduled as an ONLINE event.

Contact Details
[masked]
Shivgan Joshi -[masked]
Dr. Vora - +1 (312)[masked]

Please mail or call to verify that you are attending or for any details/queries.

Weblinks:
http://learnprogrammingnyc.com/
http://qcfinanceconsultingnyc.site/
http://python247help.site/

---------------------------------------------------------------------------------------
This program aims to provide its students an international, wide-spectrum qualification for job-readiness and seamless absorption in VBA Macros for MS Excel Data Analytics job roles.

About this Event
1. Duration: 6 hours online
2. VBA Macros for MS Excel Data Analytics for Non Programmers
3. This Online workshop is for all those who want to know more about VBA Macros for MS Excel Data Analytics and tools used in Data Analysis.
4. Instructor: Shivgan Joshi / Ankit Vora
(Instructor has taken several sessions in NYC and will explain you all concepts in a very eloquent manner.)

Instructors:
Shivgan Joshi – Python Data Science Instructor
Ankit Vora, PhD
(Instructor has taken several sessions in NYC and will explain you all concepts in a very eloquent manner.)

1. For Non Coders and Non Programming Audience
2. No Programming Experience Required

Increase your daily productivity by learning VBA (Visual Basic for Applications). Create custom buttons and automate repetitive tasks. Learn how to write code to develop new macros and update existing macros to improve their functionality. Master the VBA programming language to accelerate your workflow and reduce your daily workload by several hours.

In this practical, instructor-led VBA training bootcamp, you will work on real-world applications of Macros and Excel programming with hands-on exercises.

Course Content -
Advanced Excel -
1. Introduction, Referencing, shortcuts, dragging, if command, locking, sum product, Vlookup, Hlookup, Index Match, Offset, find dependable, Address and indirect
2. Correlation, Regression, Linear modeling, Goal seek, Optimization, Internal Rate of Return, Linest command, Graphing, conditional formatting, pivot tables
3. Monte Carlo Intro, Min, Max, Bin, histograms, rank, spearman correlation, frequency, Error Handling, CountIFs, ISSomething, Cal modes
4. Data Tables: Sensitivity, 2 way and 3 way data table, vlookups with data tables, monte carlo using Data tables
5. Complex Examples of mixing all commands, matrix multiplication, array formulas (Ctr Shift Enter), handling big files

VBA
1. Recording and Running Macros, Visual Basic Grammar, Writing Your Own Macros
2. Referencing Cells and Ranges, Decisions.
3. Repeating Actions – Loops, Passing Information and Determining the Extent of Data, Working with Pivot Tables
4. Error Handling & Custom Dialog Boxes and Custom FunctionModerator.

Our training theme is centered around projects, for example, your portfolio or even themes you are doing at work.

Instructor: Ankit Vora, PhD/ Shivgan Joshi/ Ankur Patel
Ankit Vora, PhD
Ankit Vora is a research scientist and a co-founder of a startup situated in the city of New York As Python is gaining momentum and becoming popular
https://www.linkedin.com/in/drankitvora
https://scholar.google.com/citations?user=8rrNVZwAAAAJ&hl=en

Shivgan Joshi
Shivgan Joshi is an executive trainer and talent acquisition consultant at QcFinance and has worked in the field of data science. At QcFinance, Joshi developed Python, R, SQL, MatLab, VBA, and BAT courses focused on all aspects of finance, including trading and modeling of quantitative portfolios.
https://www.udemy.com/user/shivganjoshi2/
https://www.linkedin.com/in/shivganjoshi/
https://github.com/shivgan3

We also offer affordable courses on
1. Python programming,
2. Data Science and Analysis,
3. Machine Learning,
4. Blockchain technologies, and
5. VBA

Shivgan Joshi[masked]https://github.com/shivgan3

Bigdata Analytics 101 (Intro to Hadoop & Pypark) 3 hour ($99)- Online Event

A comprehensive Big Data Hadoop bootcamp crafted by experts....

*With Changing scenario, the event is rescheduled as an ONLINE event.

Contact Details
[masked]
Shivgan Joshi -[masked]
Dr. Vora - +1 (312)[masked]

Please mail or call to verify that you are attending or for any details/queries.

Weblinks:
http://learnprogrammingnyc.com/
http://qcfinanceconsultingnyc.site/
http://python247help.site/

---------------------------------------------------------------------------------------
This program aims to provide its students an international, wide-spectrum qualification for job-readiness and seamless absorption in Big Data job roles.

About Event -
1. Duration: 3 hours online
2. Big Data Hadoop Bootcamp for Non Programmers
3. This Online workshop is for all those who want to know more about Big Data and tools used in Big data.
4. Instructor: Shivgan Joshi / Ankit Vora
(Instructor has taken several sessions in NYC and will explain you all concepts in a very eloquent manner.)

It doesn’t matter if you’ve had no programming experience whatsoever. This course starts programming from scratch, showing you everything from how to set up to how to use list comprehensions, and helping you build a solid foundation for programming in Hadoop and Pyspark.

The best part of the course is that every new concept is taught with source code slides and practice problems for you to work through.

This learn-by-doing approach is great for beginners who can quickly learn both Programming and Bigdata by following this course.

------------------------------------------------------------------------

What You’ll Learn:

Big Data
Hadoop ecosystem
HDFS – Hadoop Distributed File System
PySpark
MapReduce

Part 1(1 hours)
Oracle virtual Box
Ubuntu Basics
Terminal Commands
Nano gedit editor
Environment Variables

Part 2 (2 hours)
Hadoop install and MapReduce
Introduction: MapReduce
Overview of BigData and the Hadoop ecosystem
HDFS – Hadoop Distributed File System examples
The concept of MapReduce
MapReduce Eg in Java

Part 3(2 hr) online
Learn about different tool and Install-
Hive
Spark
Scala
Python Hadoop Streaming
Pig

Prerequisite*:

1. You need a Windows or Ubuntu computer with 8 GB Ram, and 200 GB space.
2. *Macs not supported, although, there are extra laptops that could be provided for installation upon advance request (week before).

Agenda:
Installing Ubuntu, Hadoop, Python, SQL. understanding map reduce and various tools.
-------------------------------------------------------------------------

Bigdata Pyspark 101 Pre Course for the Data Science Boot camp

Class notes: https://docs.google.com/presentation/d/1UHKVynVNaLDbMAFxQcu2LEC46BGDIZFj1TBKYdx8WuA/edit?usp=sharing

Class Quiz:
https://docs.google.com/document/d/1-5kkaP3l4WOw1V8RuChQYgm6184ygjKFMhiJrn1NGyE/edit?usp=sharing

---------------------------------------------------------------------------

Instructor:

Ankit Vora, PhD
Ankit Vora is a research scientist and a co-founder of a startup situated in the city of New York As Python is gaining momentum and becoming popular, it is finding applications in the high demand fields such as data science, machine learning, artificial intelligence, big data, etc.
https://www.linkedin.com/in/drankitvora
https://scholar.google.com/citations?user=8rrNVZwAAAAJ&hl=en

Shivgan Joshi
Shivgan Joshi is an executive trainer and talent acquisition consultant at QcFinance and has worked in the field of data science across disciplines i. Previously, Joshi served as data science manager for BaiNYC and co-founder of QcFinance. At QcFinance, Joshi developed Python, R, SQL, MatLab, VBA, and BAT courses focused on all aspects of finance, including trading and modeling of quantitative portfolios.
https://www.udemy.com/user/shivganjoshi2/
https://github.com/shivgan3

We also offer affordable courses on
1. Python programming,
2. Data Science and Analysis,
3. Machine Learning,
4. Blockchain technologies, and
5. VBA

PYTHON PROGRAMMING DATA ANALYTICS Day 1/5 ($1800- Online Event)

*With Changing scenario, the event is rescheduled as an ONLINE event.

Contact Details
[masked]
Shivgan Joshi -[masked]
Dr. Vora - +1 (312)[masked]

Please mail or call to verify that you are attending or for any details/queries.

Weblinks:
http://learnprogrammingnyc.com/
http://qcfinanceconsultingnyc.site/
http://python247help.site/

Day 1 - Introduction to Python

Our data analytics classes are taught by top instructors using our proprietary curriculum.
(Instructor has taken several sessions in NYC and will explain you all concepts in a very eloquent manner.)

PRICING:
1) Course price $1800.
2) 5 Day Course (Monday - Friday)
3) Total hours onsite 36
4) Online classes / support 24 hours
5) Total class hours 60
6) 2/3 hours per session
7) Venue: Manhattan / Queens (*Currently Online )
8) Timings: Flexible
9) Mode: 1 on 1

EXECUTIVE TRAINING: Hourly Consultation post 36 hours: $50

QcFinance EXECUTIVE TRAINING:
A non-traditional approach towards training individuals for self-enrichment, skill development, and enhancement, new skill adaptation, career progression, and workforce development, for managing, and operating ever-evolving technology with new tools, techniques, and methodology.

QcFinance EXECUTIVE TRAINING OFFERS:
“The best training program in the world is worthless without the will to execute it properly, consistently and with intensity.” That is the fact. Until it is executed properly, it is utterly worthless. Our executive training program distills a couple of years of our learning into focused and practical executive education. Moreover, we can say forcefully that it helps train as well as equipping people to face real-life business situations.

DATA ANALYTICS COURSE DELIVERABLES:

Day 1 - Introduction to Python

1.1 Introduction to Python Foundations of programming:

1.2 Print Hello World Azure Notebooks & Anaconda Book - Colab Googe -
Bash mode

1.3 Functions (Arguments and Return)

1.4 Python built-in Data types Concept of mutability and theory of
different Data structures

1.5 Control flow statements: If, Elif and Else Definite and Indefinite loops
(For and While loops)

1.6 Writing user-defined functions in Python

Day 2 - Python Functions, Loops, Data Structure File Handling

Day 3 - Pandas, Numpy, Data Wrangling,Plotting

Day 4 - Pandas Advance, OOP, Web Scraping , Data Wrangling,
Functional Programming

Day 5 - JSON, Finance,Time Series, Data Visualization, Django

Day 6 - Performance Python, Github, PySpark, Bigdata

YOU WILL LEARN:

1. Write Python code to automate tedious task and use the library of
codes we provide.

2. Create Python-based scripts to automate mundane task, re-structure
render data from SQL Mongo and APIs

3. Interact with RESTful APIs using Python Requests and JSON parsing
techniques

4. Write SQL commands to perform Query as well as change data on
SQL server / PostgreSQL

5. Scrape information from web pages

6. Create charts using Python Plotly, Seaborn

7. Use SQL and Mongo techniques to merge data and create a single
data frame for analysis and charting

8. Convert your Excel VBA code in Python

Instructors:
Shivgan Joshi – Python Data Science Instructor

Shivgan Joshi is an executive trainer and talent acquisition consultant at QcFinance and has worked in the field of data science across disciplines, including engineering, investment banking, and technology.
He is passionate about elevating businesses through the implementation of data science and data analytics. He has delivered online, live, and interactive training sessions to students and executives around the globe.
https://www.udemy.com/user/shivganjoshi2/
https://www.linkedin.com/in/shivganjoshi/
https://github.com/shivgan3
https://notebooks.azure.com/shivgan3/libraries

Other courses:
Python programming,
Data Science and Analysis,
Machine Learning,
Blockchain technologies, and
VBA.

Shivgan Joshi[masked]https://github.com/shivgan3

PYTHON PROGRAMMING DATA ANALYTICS Day 1/5 ($1800- Online Event)

PYTHON PROGRAMMING DATA ANALYTICS Day 1/5 ($1800- Online Event)

*With Changing scenario, the event is rescheduled as an ONLINE event.

Contact Details
[masked]
Shivgan Joshi -[masked]
Dr. Vora - +1 (312)[masked]

Please mail or call to verify that you are attending or for any details/queries.

Weblinks:
http://learnprogrammingnyc.com/
http://qcfinanceconsultingnyc.site/
http://python247help.site/

Day 1 - Introduction to Python

Our data analytics classes are taught by top instructors using our proprietary curriculum.
(Instructor has taken several sessions in NYC and will explain you all concepts in a very eloquent manner.)

PRICING:
1) Course price $1800.
2) 5 Day Course (Monday - Friday)
3) Total hours onsite 36
4) Online classes / support 24 hours
5) Total class hours 60
6) 2/3 hours per session
7) Venue: Manhattan / Queens (*Currently Online )
8) Timings: Flexible
9) Mode: 1 on 1

EXECUTIVE TRAINING: Hourly Consultation post 36 hours: $50

QcFinance EXECUTIVE TRAINING:
A non-traditional approach towards training individuals for self-enrichment, skill development, and enhancement, new skill adaptation, career progression, and workforce development, for managing, and operating ever-evolving technology with new tools, techniques, and methodology.

QcFinance EXECUTIVE TRAINING OFFERS:
“The best training program in the world is worthless without the will to execute it properly, consistently and with intensity.” That is the fact. Until it is executed properly, it is utterly worthless. Our executive training program distills a couple of years of our learning into focused and practical executive education. Moreover, we can say forcefully that it helps train as well as equipping people to face real-life business situations.

DATA ANALYTICS COURSE DELIVERABLES:

Day 1 - Introduction to Python

1.1 Introduction to Python Foundations of programming:

1.2 Print Hello World Azure Notebooks & Anaconda Book - Colab Googe -
Bash mode

1.3 Functions (Arguments and Return)

1.4 Python built-in Data types Concept of mutability and theory of
different Data structures

1.5 Control flow statements: If, Elif and Else Definite and Indefinite loops
(For and While loops)

1.6 Writing user-defined functions in Python

Day 2 - Python Functions, Loops, Data Structure File Handling

Day 3 - Pandas, Numpy, Data Wrangling,Plotting

Day 4 - Pandas Advance, OOP, Web Scraping , Data Wrangling,
Functional Programming

Day 5 - JSON, Finance,Time Series, Data Visualization, Django

Day 6 - Performance Python, Github, PySpark, Bigdata

YOU WILL LEARN:

1. Write Python code to automate tedious task and use the library of
codes we provide.

2. Create Python-based scripts to automate mundane task, re-structure
render data from SQL Mongo and APIs

3. Interact with RESTful APIs using Python Requests and JSON parsing
techniques

4. Write SQL commands to perform Query as well as change data on
SQL server / PostgreSQL

5. Scrape information from web pages

6. Create charts using Python Plotly, Seaborn

7. Use SQL and Mongo techniques to merge data and create a single
data frame for analysis and charting

8. Convert your Excel VBA code in Python

Instructors:
Shivgan Joshi – Python Data Science Instructor

Shivgan Joshi is an executive trainer and talent acquisition consultant at QcFinance and has worked in the field of data science across disciplines, including engineering, investment banking, and technology.
He is passionate about elevating businesses through the implementation of data science and data analytics. He has delivered online, live, and interactive training sessions to students and executives around the globe.
https://www.udemy.com/user/shivganjoshi2/
https://www.linkedin.com/in/shivganjoshi/
https://github.com/shivgan3
https://notebooks.azure.com/shivgan3/libraries

Other courses:
Python programming,
Data Science and Analysis,
Machine Learning,
Blockchain technologies, and
VBA.

Shivgan Joshi[masked]https://github.com/shivgan3

Past events (1,017)

Photos (32)