Friday, July 21, 2017

Web Scraping and Content Mining

DESCRIPTION
Web Scraping and Content Mining
Most interesting course in NYC.
2 sessions workshop
Web Scraping is a method for extracting textual characters from websites so that they could be analyzed. Web scraping is sort of content mining, which means that you collect useful information from websites, including quotes, prices, news company info, etc.This method for gathering data is direct, either through looking at websites' html code or visual abstraction techniques using Python programming language.
We start workshop by exploring different methods to gather data from Web. We go through the whole process of gathering, storing and analyzing data. For our examples we use real-life financial quotes and Annual reports 10-K. During the course we learn how to use numerous Python libraries - Urllib, Requests, Wget, BeautifulSoup 4.0, SSL, PDFminer3k, Twitter and others.
Also, we learn to constract Regular expressions patterns to find targeted information on Web pages. As a part of content mining, we build Twitter application to search and analyze the trends.
The price is for two classes:
You will Learn:
BeautifulSoup Python Library
How to use Urllib and Requests
Regular Expressions patterns
Read and analyze PDF files
Store Data with CSV files and SQL Database
Create Twitter app
Build Custom Google Search Engine

Sunday, July 16, 2017

Craiglist Adds: Data Science Bootcamp

Financial Modeling Tutor $25/hr (Midtown)




I am a former investment fund analyst and experienced in investment banking. 



Offering lessongs on excel, especially build models for companies.

Very affordable rate of $25, and you will be given all the skills needed to land a job at a hedge fund, investment bank, or private equity firm.

Valuation Methods for Companies, putting together models, write-ups, and presentations.

This is a very limited service and is temporarily offered for this month while I am vacation and interested to share what I learned.

Take advantage while you can, hours are limited, availability also at 6 pm - just after your office.

Feel free to contact me if you are interested in learning how to be an finance/excel expert! Thank you!    


Google Sheets and App Script (JavaScript) tutor $25/hr (Manhattan)

Hi,
I am a tutor for Google App script (Java script) used for automation in Google sheets. If your company is using google sheet learning automation will help you to progress. Also, important for business students.
Charge $25/hour.
Location: All in NYC area.
Please get in touch

.    

GRE / GMAT Quant / Quantitative/ Math Tutor $25/hr

GRE / GMAT Quant Tutor
Experience in tutoring, videos online and good references.
Price $25 per hour
5 years of exp in quantitative GRE GMAT tutoring
From the author of FreeGREGMATClass dot com
Check out the youtube videos contributed by students and tutors for FGGC
First session of 30 minutes is free.   



Quantitative Math Excel VBA $25/hr (New York)

Tutoring Data Science has been my hobby and recreational activity. Many tutoring projects are volunteering and networking oriented (getting new insight). I do it so that I can revise what I do at school and at work. I am an Electrical Engineering graduate, GAARP-FRM certified, PG Dip in Fin analysis and Risk Management, cleared CFA L1, International - MBA (15-16).

I have extensive teaching experience with students of various profiles and backgrounds where I have learned and enhanced my skills and also helped learners. I am also an extremely friendly person. I have taken many online classes as tutor on qcfinance.in

QcFinance.in has tutors available for meetups (mix of onsite at home & online through Wiziq/Skype/Adobe-connect & custom videos support emailed to you for your doubts on holidays)

Subject areas teach 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.

Website: www.qcfinance.in

Playlist of sample quant videos: https://www.youtube.com/playlist?list=PL_-KSXJS5pxOiLjAoe5uAHPAsv-UhIM7i

Keywords: Quant Trainer, Tutor, Trainer, Teacher, Home tuition, GRE, GMAT, Quant, Programming, CFA Level 1, FRM Part 1, Mathematics Tutor, Maths, Onsite.
Keywords: Trainer, Tutor, Home tuition, Excel, VBA, Onsite, trainer, help assignment, video solutions, In Person, 1 on 1, Home Tutor. 

Office Automation on Excel VBA Python SQL R (new york)

We provide official automation services on Excel VBA Python SQL R. 

Automation is the next biggest revolution, legacy methods if not replaced by automation will reduce the productivity of the firm which might even lead to extinction.

Our can reduce a lot of manual work and use lot of Excel Analytics features, our clients have reduced work by upto 50-70% which helped me focus on their product and other value addition to their core business.

Get more hours from your employees and more robust analytical framework!

Please contact me for more details about various processes that we can automate.    


Statistics, Data Science, Machine Learning, Statistical Computing, R   


Tutoring for statistics, machine learning, and data science. The focus includes statistical theory as well as its application, building models. That includes the following: 
•Theory Courses: Probability, Statistical Inference, Bayesian Statistics, Decision Theory, Point Estimation, High-Dimensional Inference, Time Series, and other MS/Ph.D. courses

•Machine Learning: Ridge Regression, LASSO, Basis Pursuit, Supervised/Unsupervised Learning, Neural Network, Statistical Learning Theory 

•Social Science: Causal Inference, Hierarchical Model, Multiple Imputation, Matching

•Statistical computing: R programming, Matlab, STATA, Python, Java, C

Monday, July 3, 2017

Analytics course New York

PROJECTS
FINAL PROJECT For the Analytics final project, you will collect, clean and
analyze a data set to solve a real world problem. From this
data, you will segment the data set and perform analysis.
Following your analysis, you will create both a dashboard and
presentation.
In order for your project to be considered a success, you will
complete the following steps
‣ Identify a problem
‣ Obtain the data
‣ Understand the data
‣ Prepare, clean and format the data
‣ Analyze the data
‣ Create a dashboard to display insights both numerically and
graphically.
‣ Present high level insights and the resulting actions to key
stakeholders.
As you complete elements of your final project, you will be
required to present materials and receive feedback from your
instructional team and classmates as well industry experts.
Our instructors are on hand to validate the feasibility and
manage the scope of your project.
6
Data Analytics
Units

UNITS
UNIT 1: DATA IN EXCEL ‣ The Value of Data Lesson 1
‣ Prepare Data in Excel Lesson 2
‣ Clean Data in Excel Lesson 3
‣ Dynamic Data Referencing Lesson 4
‣ Dynamic Data Aggregation Lesson 5
‣ Conditional Formatting and Aggregation Lesson 6
‣ The Value of Databases Lesson 7
‣ Query Large Databases Lesson 8
‣ Data Aggregation in SQL Lesson 9
‣ More Data Aggregation in SQL Lesson 10
‣ Efficient and Dynamic Queries Lesson 11
‣ Present Analysis Results Lesson 12
‣ Statistics to Validate Analysis Lesson 13
‣ Predictive Analysis Lesson 14
‣ Dashboard Design Lesson 15
‣ Track Metrics with Dashboards Lesson 16
‣ Effective Presentations with Data Lesson 17
‣ Flexible Session Lesson 18
‣ Flexible Session Lesson 19
‣ Final Project Presentation Lesson 20
UNIT 2: DATA IN SQL

UNIT 2: COMMUNICATION AND
DASHBOARD DESIGN
1 THE VALUE OF DATA
‣ Explain the value of data.
‣ Describe the analytics workflow
‣ Use mean, median, mode to describe data and find outliers
2 PREPARE DATA IN EXCEL
‣ Describe best practices in data cleaning and collection to
ensure the best results from data analysis
‣ Use complex nested logical functions [IF, OR, and AND] to
further manipulate data sets
‣ Manipulate data formats to gain insights on how to analyze
data
3 CLEAN DATA IN EXCEL
‣ Clean a large messy datasets by removing duplicate rows
and performing text manipulations
‣ Transform and rearrange columns and rows to structure
data for analysis
‣ Manipulate data formats to gain insights on how to analyze
data
4 DYNAMIC DATA REFERENCING
‣ Use data functions [VLOOKUP and HLOOKUP] to
manipulate data sets
‣ Use data functions [INDEX and MATCH] to look up values
in other tables
‣ Reconcile data values by joining and matching
5 DYNAMIC DATA AGGREGATION
‣ Summarize data using the pivot tables
‣ Use excel aggregation commands [‘Min’, ‘Max’, ‘Sum’,
‘Average’, ‘Count’, ‘Frequency’ to accomplish “count
distinct” ] and their conditional variants [‘COUNTIF’,
‘COUNTUNIQUE’, ‘COUNTA’, ‘COUNTIFS’,
‘COUNTBLANKS’] to summarize data sets
6 CONDITIONAL FORMATTING AND AGGREGATION
‣ Derive insights from data by highlight cells based on
conditionals
‣ Describe color theory and how it applies to data visualization
7
Data Analytics
Units Continued

DATA IN EXCEL 1
8
Data Analytics
Units Continued
GA.CO/AN
7 THE VALUE OF DATABASES AND SQL
‣ Use database schema to design appropriate queries
‣ Explain differences between relational databases (tabular
data storage) and document-based databases(key-value
pairs)
‣ Collect data using standard sql commands [Select, From,
Create, Update, Delete, Truncate, Drop]
8 QUERY LARGE DATABASES
‣ - Use advanced SQL commands [where, groupby, having,
orderby, limit] to filter data
‣ - Use joins to create relationships between tables to obtain
data
‣ - Use SQL boolean operators [AND and OR] and SQL
conditional operators [=,!=,>,<,IN and BETWEEN] to
obtain filtered data
9 DATA AGGREGATION IN SQL
‣ U- Create relationships between tables and data points
including has_many and many_to_many with join tables
using Joins [‘full’, and ‘union’]
‣ - Use sql conditional operators [=,!=,>,<,IN and
BETWEEN] and Null functions[‘is Null’, ‘ is not Null’ and
‘NVL’ ] to create boolean statements
‣ - Use sql mathematical functions [ABS, SIGN, MOD,
FLOOR, CEILING, ROUND, SQRT] to clean data
10 MORE DATA AGGREGATION IN SQL
‣ - Use aggregation commands [‘Min’, ‘Max’, ‘Sum’, ‘Average’,
‘Count’, ‘Count Distinct’] to summarize data sets
‣ - Use aggregation methods to determine trends from data
11 EFFICIENT AND DYNAMIC QUERIES
‣ Use CASE statements to structure data and create new
attributes
‣ - Use "WITH AS (" to combine subqueries into one query
‣ - Present analysis results and describe stakeholder
implications and insights
DATA IN SQL 2
9
Data Analytics
Units Continued

12 PRESENT ANALYSIS RESULTS
‣ Provide appropriate context of dataset
‣ Appropriately describe analysis techniques
‣ Present and describe stakeholder implications and insights
13 STATISTICS TO VALIDATE ANALYSIS
‣ Describe the value of descriptive and summary statistics in
understanding a dataset
‣ Create basic statistical measures to better understand the
range, average, and variance within a dataset
‣ Present the most salient statistics in order to provide
context to your audience
‣ Explain the importance of segmentation
14 PREDICTIVE ANALYSIS
‣ Describe the value of inferential statistics and predictive
analysis
‣ Review linear regression and Ordinary Least Squares (OLS)
‣ Use sample data to make predictions about a larger
population
15 DASHBOARD DESIGN
‣ Use scatter plots and bar graphs to visualize data
‣ Apply the best practices to build a dashboard
‣ Demonstrate good visual design without overloading their
dashboard with complexity
16 TRACK METRICS WITH DASHBOARDS
‣ Use bubble graphs to visualize data
‣ Apply the best practices to build a dashboard
‣ Contextualize data analysis by creating Tableau dashboards
[includes charts + conditional formatting] with supporting
information specific to the dataset
17 EFFECTIVE PRESENTATIONS WITH DATA
‣ Display geocoded information in Tableau
‣ Provide real-world context for basis of analysis
‣ Provide localized context for implications of findings
‣ Deliver short, effective presentations
DATA ANALYSIS 2 (CONTINUED)
DATA COMMUNICATION 3
10
Data Analytics
Units Continued

18 FLEXIBLE SESSION
‣ Focus on a topic selected by the instructor/class in order to
provide deeper insight into a specific area of data analysis
19 FLEXIBLE SESSION
‣ Focus on a topic selected by the instructor/class in order to
provide deeper insight into a specific area of data analysis
20 FINAL PROJECT PRESENTATION
‣ Present final project presentation to class