Predictive Analysis in SQL Server 2005?

Question

Predictive Analysis in SQL Server 2005?

sunit_82

Newbie

Points: 6
More actions
April 9, 2009 at 3:42 am

#132918

I want to know if SQL Server 2005 has predictive analysis tools?
http://www.microsoft.com/sql/technologies/dm/TATForecast/TATForecast.html
In above link you can see how Office 2007 has this Forcast feature using the analysis services. Can such a thing be done in VS 2005/2008 or SQL Server Business Intelligence Development Studio
If yes, then can you point me to some useful links or demos.
Thanx,
s.a.w

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

sunit_82 (4/9/2009)
I want to know if SQL Server 2005 has predictive analysis tools?
http://www.microsoft.com/sql/technologies/dm/TATForecast/TATForecast.html
In above link you can see how Office 2007 has this Forcast feature using the analysis services. Can such a thing be done in VS 2005/2008 or SQL Server Business Intelligence Development Studio
If yes, then can you point me to some useful links or demos.
Thanx,
s.a.w

I don't think there is such feature out-of-the-box in SQL Server. I would recommend you ask your question here, too.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

RBarryYoung SSC Guru Points: 143329 More actions · Answer 2

If so, it would almost certainly be in Analysis Services, not Integration Services.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Famson SSC Eights! Points: 997 More actions · Answer 3

Yes, SQL server 2005 has predictive analysis tools. You use SQL Server Analysis Services (SSAS) to perform data mining tasks like creating predictive models using decision tree, naive bayes etc.

sunit_82 Newbie Points: 6 More actions · Answer 4

thanx all for replies,

Grasshopper , you mentioned predictive analysis using decision trees.

Can you pls point to some useful site /examples regarding this.

I googled but did not find what i want.

What i wan is, if i have a certain amount of historical data of sales of a product(lets say year wise for pass 20 years), then i should be able to generate predictions for next 2 to 5 yrs.

Thanx,

s.a.w

RBarryYoung SSC Guru Points: 143329 More actions · Answer 5

Well certainly, rudimentaty trending predictors, such as least-squares projections are easy enough to code up in Transact-SQL, however this kind of thing is the specialty of Analysis Services(SSAS). I recommend that you ask in that forum.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]