#12 in Data warehousing books
Use arrows to jump to the previous/next product
Reddit mentions of Data Analysis Using SQL and Excel
Sentiment score: 1
Reddit mentions: 2
We found 2 Reddit mentions of Data Analysis Using SQL and Excel. Here are the top ones.
or
Specs:
| Height | 9.25195 Inches |
| Length | 7.40156 Inches |
| Number of items | 1 |
| Weight | 2.3 Pounds |
| Width | 1.499997 Inches |
Data Analysis using SQL and Excel
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