Programming options for an analyst

Discussion in 'Mac Programming' started by mylesg, Nov 25, 2010.

  1. mylesg macrumors newbie

    Nov 25, 2010
    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.
  2. Hansr macrumors 6502a

    Apr 1, 2007
    Python, but ultimately you should focus on R and SQL first. If your using them don't spend time on something else yet.
  3. mylesg thread starter macrumors newbie

    Nov 25, 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).
  4. mrbash macrumors 6502

    Aug 10, 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.
  5. Hansr macrumors 6502a

    Apr 1, 2007
    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.

    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.


Share This Page