Astronomer to Data Scientist
womeninastronomy.blogspot.com
womeninastronomy.blogspot.com
1. Java and Python are good languages for data mining, due to their libraries, though the others aren't great. C++ is good for finance.
2. Excel is not a statistical analysis package. "Just because you can drive a car with your feet doesn't make it a good idea" - Chris Rock. Excel is great for pivot tables, however.
3. Hadoop is not a distributed database, it is MapReduce plus a distributed file system. Hive is also not really a distributed database. It lets you write SQL that turns into mapreduce jobs.
On the accuracy of statistical procedures in Microsoft Excel 2007
http://or.nps.edu/faculty/PaulSanchez/oa4333/handouts/Excel/...