Want the Secrets to Succeed on Wall Street?

Click below to get access to our Free Wall St. Compensation Report and more.

About WSO

The Age of Big Data Forum's RSS Feed Share

zoomi's picture
(Monkey, 43
 
Points)
 on 2/14/12 at 6:18pm

Anybody know a good on-line training program that teaches data analysis?

Tags:
Abdel's picture

zoomi wrote: Anybody know a

O
(King Kong, 1,483
 
Points)
  on 2/14/12 at 6:29pm
zoomi:

Anybody know a good on-line training program that teaches data analysis?

You mean SQL?

'' Come to Wall Street. Spend two years working your butt off ... Taste it, enjoy it; just don't get drunk on it. Cause the hangover is a real bitch.'' - IlliniProgrammer

econ's picture

SAS is more for data

O
(Neanderthal, 2,393
 
Points)
  on 2/14/12 at 6:36pm

SAS is more for data analysis. SQL is more about pulling data from databases, updating databases, etc.

"Many of life's failures are people who didn't realise how close to success they were when they gave up"
~~ Thomas Edison ~~

Abdel's picture

econ wrote: SAS is more for

O
(King Kong, 1,483
 
Points)
  on 2/14/12 at 6:39pm
econ:

SAS is more for data analysis. SQL is more about pulling data from databases, updating databases, etc.

Oh ok.

Similar to SAS, we use ''Stata'' here.

'' Come to Wall Street. Spend two years working your butt off ... Taste it, enjoy it; just don't get drunk on it. Cause the hangover is a real bitch.'' - IlliniProgrammer

cibo's picture

You use both. You absolutely

(Baboon, 103
 
Points)
  on 2/14/12 at 6:53pm

You use both.

You absolutely need to learn SQL for data extraction. For the data analysis, you can use SAS, R, SPSS, or even Excel.

You can also write sql code into SAS or R and then handle the objects within the programs.

dwight schrute's picture

Just download R and attempt

(Gorilla, 574
 
Points)
  on 2/14/12 at 7:20pm

Just download R and attempt the modules

I would steer away from excel for anything sophisticated.

My favorite is SAS and R is quickly unseating it. Also try talkstats.com.

Because you just never know what stupid rule tomorrow will bring...

Quarterlife's picture

dwight schrute wrote: Just

CO
(Orangutan, 280
 
Points)
  on 2/14/12 at 8:24pm
dwight schrute:

Just download R and attempt the modules

I would steer away from excel for anything sophisticated.

My favorite is SAS and R is quickly unseating it. Also try talkstats.com.

Exactly! What I love about R is that it is completely free too! You should definitely check it out http://www.r-project.org/

My formula for success is rise early, work late and strike oil - JP Getty

econ's picture

I've noticed a lot of people

O
(Neanderthal, 2,393
 
Points)
  on 2/14/12 at 8:34pm

I've noticed a lot of people are saying that about R. However, I am slightly skeptical because I know a private sector statistician who told me that R doesn't handle big data sets well (among other things). In any event, it's probably good to learn SAS and R, if you have the time.

"Many of life's failures are people who didn't realise how close to success they were when they gave up"
~~ Thomas Edison ~~

wadtk's picture

use eviews

AM
 
Points)
  on 2/14/12 at 8:44pm

use eviews

Quarterlife's picture

Speaking of R, I recommend

CO
(Orangutan, 280
 
Points)
  on 2/14/12 at 11:53pm

Speaking of R, I recommend this for self-taught purpose

My formula for success is rise early, work late and strike oil - JP Getty

dwight schrute's picture

econ wrote: I've noticed a

(Gorilla, 574
 
Points)
  on 2/15/12 at 1:33am
econ:

I've noticed a lot of people are saying that about R. However, I am slightly skeptical because I know a private sector statistician who told me that R doesn't handle big data sets well (among other things). In any event, it's probably good to learn SAS and R, if you have the time.

Yeah I've noticed some performance issues starting ~500 mb. There are some packages that allow you to store the data on your hard drive although its counterproductive once you have to load the data into memory.

Quarterlife:

Speaking of R, I recommend this for self-taught purpose

I've heard approving reviews of it before. Is it primarily aimed at beginners or will intermediate users still find it useful?

Because you just never know what stupid rule tomorrow will bring...

Quarterlife's picture

dwight schrute wrote: I've

CO
(Orangutan, 280
 
Points)
  on 2/15/12 at 3:00am
dwight schrute:

I've heard approving reviews of it before. Is it primarily aimed at beginners or will intermediate users still find it useful?

I am a complete n00b and I find it very useful so I guess it's mostly aimed at beginners. However, there are many chapters in the books so if you're an intermediate user you can just look at the content from Amazon and see if those other chapters benefit you or not.

My formula for success is rise early, work late and strike oil - JP Getty

econ's picture

Abdel wrote: econ wrote: SAS

O
(Neanderthal, 2,393
 
Points)
  on 2/15/12 at 5:59am
Abdel:
econ:

SAS is more for data analysis. SQL is more about pulling data from databases, updating databases, etc.

Oh ok.

Similar to SAS, we use ''Stata'' here.

Yeah, Stata is also good to know too, and I think it's supposed to be easier to pickup then SAS. Knowing SAS and SQL will open up the most doors career wise (at least at this point in time).

Also, anyone's who's interested in this stuff should check out this article: http://www.nytimes.com/2012/02/12/sunday-review/big-datas-impact-in-the-...

"Many of life's failures are people who didn't realise how close to success they were when they gave up"
~~ Thomas Edison ~~

zoomi's picture

Thanks..there are some good

(Monkey, 43
 
Points)
  on 2/15/12 at 6:22pm

Thanks..there are some good You Tube vids on SQL...