| Author |
 Topic  |
|
|
bestbird7788
Starting Member
4 Posts |
 Posted - 05/23/2012 : 05:18:12
|
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 (base on the mass data).
3. Easy to confront even a large amount of complex computations
What would you great expert recommend?
Thanks in advance.
|
|
|
bestbird7788
Starting Member
4 Posts |
Posted - 05/28/2012 : 02:35:11
|
| hi,plz give me some advice |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48076 Posts |
Posted - 05/28/2012 : 13:25:14
|
we need more detailed info like
who will be doing analysis? is it by end user or business analysts?
Able to cope with the unexpected requirement rapidly.
waht kind of requirement are you talking about here?
your exeplanation sounds like what you're looking at is a reporting/analytic solution.
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
bestbird7788
Starting Member
4 Posts |
Posted - 05/29/2012 : 03:28:35
|
thanks for your replay.
the user is business analysts.
here is my problem, I need every steps, not just a final result, because I would do the further analysis based on every step in the future, if there be a new business requirement (It's unexpected requirement ):
original data:
product year value
1 2009 1104
2 2009 608
3 2009 606
1 2010 1504
2 2010 508
3 2010 1312
I want to compute the product whose annual sales values are all among the top 2. so I need to do
step1: split data by year
2009
product year value
1 2009 1104
2 2009 608
3 2009 606
2010
product year value
1 2010 1504
2 2010 508
3 2010 1312
step2: compute rank in every group
2009
product year value rank
1 2009 1104 1
2 2009 608 2
3 2009 606 3
2010
product year value rank
1 2010 1504 1
2 2010 508 3
3 2010 1312 2
step3: filter top2 in every group
2009
product year value rank
1 2009 1104 1
2 2009 608 2
2010
product year value rank
1 2010 1504 1
3 2010 1312 2
step4: compute intersection of every group
product
1
-----------------------------------------------------
My second problem
the original data is based on step1 above:
2009
product year value
1 2009 1104
2 2009 608
3 2009 606
2010
product year value
1 2010 1504
2 2010 508
3 2010 1312
I want to get relative difference in every group (It's a simple sample, has no actual business means, in business I want to solve link relative ratio problem)
that means: 0, 608-1104,606-608 and 0, 508-1504, 1312-508. I know in SQL It should use lag and lead function.
What I want in result should be:
2009
product year value relative
1 2009 1104 0
2 2009 608 -494
3 2009 606 -2
2010
product year value relative
1 2010 1504 0
2 2010 508 -996
3 2010 1312 804
quote:
Originally posted by visakh16
we need more detailed info like
who will be doing analysis? is it by end user or business analysts?
Able to cope with the unexpected requirement rapidly.
waht kind of requirement are you talking about here?
your exeplanation sounds like what you're looking at is a reporting/analytic solution.
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
Edited by - bestbird7788 on 05/29/2012 21:48:43 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48076 Posts |
|
|
bestbird7788
Starting Member
4 Posts |
Posted - 05/29/2012 : 22:03:13
|
thanks
I had checked the article you provided.
But I cant see every steps in a report, and I cant do the further analysis on a report . It is just a final result.
I think reporting tools is not what I want, I need a mass data analysis tool.
quote:
Originally posted by visakh16
ok..so what you need is adhoc reporting solution where you'll add required entity attributes and measures to do analysis. You've several reporting tools providing adhoc reporting capabilities. In SQL reporting services, its called report builder and you need to build a report model for it including required attributes and measures
see
http://www.databasejournal.com/features/mssql/article.php/3598931/Report-Builder--Creating-a-Report-Model.htm
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
| |
Topic |
|
an interactive application for mass data analysis?
