Following my last two articles, today i will go on with the interactive analysis and related tools. And what about the data analytics tools? Most business intelligence tools manufacturer are engaging in developing the most efficient analytics tools, and there are various data analytics tools targeting at different purposes.
What's the Requirements on analysis tools?
The characteristics of interactive analysis determine its requirements on computation tool:
l Abundant library function or fixed algorithm
l Provide a convenient interactive procedure
l Business expert can handle
l Support massive structural data
Here are Common tools for interactive analysis.
Based on the requirements on the interactive analysis tool, we can list some common tools, just name a few:
n Excel. Please refer to: http://office.microsoft.com/en-us/excel/
n R language. Please refer to: http://www.r-project.org/
n esProc. Please refer to: http://www.raqsoft.com/products
n SQL. Please refer to: http://en.wikipedia.org/wiki/SQL
n SAS. Please refer to: http://www.sas.com/
n SPSS. Please refer to: http://www-01.ibm.com/software/analytics/spss/
n Matlab. Please refer to: www.mathworks.com/products/matlab/
There are many other excellent tools for interactive analysis. However, one point to note is that none of them is perfect on all aspects. For example, the analyst may find that it is easy to grasp Excel but hard to compose SQL statements; esProc lacks of the non-linear model, but it can provide a convenient interactive process; SPSS boasts the abundant fixed algorithms but is not as convenient as SQL in relation query.
The tool suitable for your needs is the correct one. Please refer to the Comparison between Interactive Analysis Tools to join us on choosing the analysis tool suitable for your needs.
As you may find that the interactive analysis is similar to OLAP in some respects. And next, i plan to write an article on interactive analysis and OLAP. Wish you like it!