clarification on data mining prediction | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

clarification on data mining prediction

We have Two Dimension Tables namely, DIMPRODUCT table
and the following are the attributes of DIMPRODUCT table PRODUCT_ID
PRODUCT_DESC_ID
LAST_MODIFIED
PRODUCT_RELEASE_DATE
DIMTIME
MONTH_ID DIMTIME table and it’s content,
MONTH and MONTH_ID One Fact Table namely, FACT_FEATURED_PRODUCTS_SA table and it’s content, PRODUCT_ID
SALES_AMOUNT
MONTH_ID Now, we would like to predict for next one month sales amount for the particular product, based on historical data. How to do that? Please suggest me ASAP. Thanks,
Rama Rao & Srinivas

Is this a classroom based or interview question?
I believe you can take help of data mining features in this case. Time Series algorithm allows you to analyze and forecast any time-based data, such as sales or inventory. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
quote:Originally posted by satya Is this a classroom based or interview question?
I believe you can take help of data mining features in this case. Time Series algorithm allows you to analyze and forecast any time-based data, such as sales or inventory. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Hi Satya, Thanks for your reply. Can you please provide how to predict based on historical data using SSAS 2005? We are getting some results, but, we are unable to find, those results are correct or not. So, please provide some documentation or else any sample dumped application. Basically, we are failing in Mining Structure and Mining Model Prediction tab. Awaiting for your valuable reply. Thanks,
Rama Rao
Please do not duplicate the threads for same problem, http://sqlserver-qa.net/blogs/el/ar…ql-server-2005-analysis-services-mdx-etc.aspx fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>