Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bestbird7788
Starting Member
4 Posts |
 Posted - 2012-05-23 : 05:18:12
|
| Hi, everybodyI 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 computationsWhat would you great expert recommend? Thanks in advance. |
|
|
bestbird7788
Starting Member
4 Posts |
Posted - 2012-05-28 : 02:35:11
|
| hi,plz give me some advice |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-28 : 13:25:14
|
| we need more detailed info likewho 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
bestbird7788
Starting Member
4 Posts |
Posted - 2012-05-29 : 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 value1 2009 1104 2 2009 608 3 2009 606 1 2010 1504 2 2010 508 3 2010 1312I want to compute the product whose annual sales values are all among the top 2. so I need to do step1: split data by year2009product year value 1 2009 1104 2 2009 608 3 2009 606 2010product year value 1 2010 1504 2 2010 508 3 2010 1312 step2: compute rank in every group2009product year value rank1 2009 1104 1 2 2009 608 2 3 2009 606 3 2010product year value rank1 2010 1504 1 2 2010 508 3 3 2010 1312 2step3: filter top2 in every group2009product year value rank1 2009 1104 1 2 2009 608 2 2010product year value rank1 2010 1504 1 3 2010 1312 2step4: compute intersection of every groupproduct1-----------------------------------------------------My second problemthe original data is based on step1 above:2009product year value 1 2009 1104 2 2009 608 3 2009 606 2010product year value 1 2010 1504 2 2010 508 3 2010 1312I 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:2009product year value relative1 2009 1104 0 2 2009 608 -494 3 2009 606 -2 2010product year value relative1 2010 1504 0 2 2010 508 -996 3 2010 1312 804 quote:
Originally posted by visakh16
we need more detailed info likewho 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 MVPhttp://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
bestbird7788
Starting Member
4 Posts |
Posted - 2012-05-29 : 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 measuresseehttp://www.databasejournal.com/features/mssql/article.php/3598931/Report-Builder--Creating-a-Report-Model.htm------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
|
|
|
|
|
an interactive application for mass data analysis?