有人可以推荐用于数据分析的交互式应用程序 [英] Could anyone recommend an interactive application for data analysis?

问题描述

大家好，每个人

我需要对数据库进行大量的数据分析。有人可以推荐一个用于数据分析的交互式应用程序吗？

要求是：

1.能够快速应对意外需求。

2能够以交互方式对结果进行进一步的计算。

3.即使是大量复杂的计算也很容易面对

你会有什么好专家推荐的？

先谢谢。

Hi, everybody
I need to conduct a large amount of data analysis on database. Could anyone recommend an interactive application for data analysis?
The requirements are:
1. Able to cope with the unexpected requirement rapidly.
2. Able to perform further computations on results interactively.
3. Easy to confront even a large amount of complex computations
What would you great expert recommend?
Thanks in advance.

推荐答案

有什么建议吗？

plz ..... help ... ...

any suggestion?
plz.....help......

我的头脑中有统计分析软件（SAS），社会科学统计软件包（SPSS）和Wolfram Alpha。

Off the top of my head, there''s Statistical Analysis Software (SAS), Statistical Package for the Social Sciences (SPSS), and Wolfram Alpha.

谢谢你，Wolfram Alpha似乎是一个数学公式工具和搜索引擎（也许是一个文本匹配引擎），它缺乏海量数据计算能力。这是对的吗？如果是这样它不是一个理想的解决方案。


SPSS和SAS可能是理想的解决方案，我会检查SPSS的详细信息，这是一个复杂的系统，我可以''很快就能理解它。



说清楚，我想做的是：


来解决这些问题： 一个。选出10类畅销书b。作为基于a。的结果的进一步计算，从每个类别中选出前20个产品，c。根据a。的结果进一步比较去年的结果，选择今年名单上新出现的和消失的类别。

1. SQL不提供像Excel那样的逐步分析功能

2.如果更改问题a的SQL语句以选择5个类别，那么我将不得不在b和c的语句中进行相应的更改。另外，这些SQL语句太长太复杂。我有这样的数百个计算目标。


你觉得SPSS是一个理想的解决方案，根据上面的例子吗？

谢谢你兔子; - ）

thank you, Wolfram Alpha seems a math formula tool and search engine( Maybe a text matching engine), It lacks mass data computation ability.----Is that right? if so It''s not a ideal solution.

SPSS and SAS May be the ideal solution, I will check SPSS for detail, It''s a complex system and I can''t understand it very fast.


to make it clear , what I want to do is:

to solve these problems: a. to select out the 10 categories of best sellers b. as a further computation on the basis of result from a., to select out the top 20 products from each category, c. as a further comparison with that of the last year based on the result from a., to select out the newly-appeared and the disappeared categories on the list of this year.
1. SQL does not provide the stepwise analysis capability like Excel
2. If changing the SQL statement for the problem a to select out the 5 categories, then I''ll have to change accordingly in the statements for b and the c. In addition, these SQL statements are too long and too complex. I''ve got hundreds of goals of computations like this.

Do you think SPSS is a ideal solution according to the example above?
and thank you Rabbit ;-)

这篇关于有人可以推荐用于数据分析的交互式应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！