Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Reply
 
Thread Tools Search this Thread Display Modes
Old Nov 25, 2010, 01:43 PM   #1
mylesg
macrumors newbie
 
Join Date: Nov 2010
Programming options for an analyst

I am a business analyst and stats person. For years I have been able to live off point and click options in programs like SPSS, Access, Filemaker and of course Excel.

Now, my world is getting more complex. Both R and SQL seems to be the growth area in analytics. So are applications in data mining and doing more work in relational databases.

Now, I don't necessarily want to be able to write applications. I just want to be able to better manipulate data, ETL, use command and script based applications for data mining and statistics.

What is the best language to learn to give me the background to begin and do more work within R, SQL, Filemaker, and other data management/mining and stats programs? Even SPSS has an underlying language that I really don't use (yet). So, just a language to better manipulate and analyze data.

Seems like the basic options are C++, Java, VB, Python, etc. As I don't want to be a programmer per say- I just want to learn the basics of a language to better help me with the above tasks.

Finally, when given a choice, I alway prefer to do things on my Mac. So, prefer a language that is works well with a Mac.

Thanks for any advice.
mylesg is offline   0 Reply With Quote
Old Nov 25, 2010, 01:54 PM   #2
Hansr
macrumors 6502a
 
Join Date: Apr 2007
Python, but ultimately you should focus on R and SQL first. If your using them don't spend time on something else yet.
Hansr is offline   0 Reply With Quote
Old Nov 25, 2010, 02:00 PM   #3
mylesg
Thread Starter
macrumors newbie
 
Join Date: Nov 2010
Cool. So, as I want to start to (soon) getting into R and SQL- would I be helped by understanding some other language first? Are R and SQL based on some other basic language or language structure? OR should I go from "programming novice" right into R and SQL?

But you say Python is better (which would be good, as Python is used extensively by SPSS).
mylesg is offline   0 Reply With Quote
Old Nov 25, 2010, 02:07 PM   #4
mrbash
macrumors 6502
 
Join Date: Aug 2008
There are many dialects of SQL. Each DB vendor tends to create their own SQL versions. When it comes to all of the interesting stuff, it is very DB specific.
mrbash is offline   0 Reply With Quote
Old Nov 25, 2010, 02:34 PM   #5
Hansr
macrumors 6502a
 
Join Date: Apr 2007
Quote:
Originally Posted by mylesg View Post
Cool. So, as I want to start to (soon) getting into R and SQL- would I be helped by understanding some other language first?
Yes prior understanding of other languages is helpful, but as a complete novice it's pointless to go for anything prior to what you're going to be using.

Quote:
Originally Posted by mylesg View Post
Are R and SQL based on some other basic language or language structure?
R is semi based on S, SQL is a all encompassing name for a variety of implementation of similar querying languages used for various relational database servers. There are subtle differences between the databases servers and the language is different for each because of that.

Quote:
Originally Posted by mylesg View Post
OR should I go from "programming novice" right into R and SQL?
Yes.
Hansr is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Mac programming should be more like iOS programming. moonman239 Mac Programming 13 Feb 17, 2014 01:37 PM
How to get educated about analyst credibility? FloatingBones Site and Forum Feedback 19 Oct 18, 2013 01:34 PM
iPhone 4S has no USB capabilities--any options other options to sync with iTunes? phoneqs iPhone Tips, Help and Troubleshooting 0 Jul 22, 2013 01:02 AM
Get your ANALYST on! Santabean2000 Buying Tips and Advice 0 Jun 24, 2013 04:51 PM
System Analyst determined09 Community Discussion 0 May 11, 2013 07:56 PM

Forum Jump

All times are GMT -5. The time now is 10:58 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC