Can we display Future year sales forcating using SSAS with predictions?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Mining » Can we display Future year sales forcating...

Can we display Future year sales forcating using SSAS with predictions?

Rate Topic

Display Mode

Topic Options

Author

Message

Saravanan_tvr

Posted Tuesday, October 16, 2012 1:15 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:04 AM
Points: 269, Visits: 1,110

Coz Its analyzing only what we pushed data and shows diagrammatically.. not for Future year , If possible can any one suggest me to do...

Many Thanks!
S.saravanan
“I am a slow walker, but I never walk backwards-
Abraham Lincoln”

Post #1373061

davoscollective

Posted Monday, November 19, 2012 10:07 PM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 12:34 AM
Points: 408, Visits: 686

You can create a data-mining project with SSAS. Use your cube as a datasource, there is an algorithm/model type called "Microsoft time series" which can do forecasting. It's way too involved for me to give instructions here, but it is fairly straight forward if you've done data mining projects in BIDS before.

Post #1386678

Raunak Jhawar

Posted Thursday, December 20, 2012 11:57 PM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739

Yes you can the popular ways are:
1. Regression
2. Forecasting

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum

Post #1399213

« Prev Topic | Next Topic »

Permissions