Reddit Reddit reviews Data Analysis Using SQL and Excel

We found 2 Reddit comments about Data Analysis Using SQL and Excel. Here are the top ones, ranked by their Reddit score.

Computers & Technology
Books
Data Warehousing
Databases & Big Data
Data Analysis Using SQL and Excel
Check price on Amazon

2 Reddit comments about Data Analysis Using SQL and Excel:

u/datadude · 2 pointsr/statistics

Data Analysis using SQL and Excel

u/flipstables · 1 pointr/datascience

I'm very much a data science newbie. But here's my attempt to answer your question.

Excel is both very powerful and very limited in data analysis.

Pros: a lot of quick and dirty analysis can be done using Excel. Data manipulation is easy and fast. Particularly with Excel 2013, it's very easy to mash data together from different data sources. PowerPivot is a nice way to "import" data from SQL sources. Popular data mining addin = XLMiner.

Cons: Limited in size of data sets, and it can get extremely slow and unstable with large amounts of data. Analysis is very biased towards financial applications. Programming is Excel is very clunky (I'd rather let python do the heavy lifting if necessary).

Excel really needs a database engine and/or business intelligence backend to perform a lot of the heavy analytics. Nevertheless, it's a good tool.

For resources, I was recently introduced to this book, and it seems promising:

http://www.amazon.com/Data-Analysis-Using-SQL-Excel/dp/0470099518