data mining prediction quries

External Since: Mar 19, 2004 Posts: 7

In the classic foodmart 2000 example(a data set i'm taking as input into building an mining application) in an attempt to identify patterns in customers in SQL SERVER 2000: analysis services based on sales data(customer transactions)...what are the patterns i should try to find and what would be the input, target and predictable columns for those patterns....another question is what sort of data mining prediction quiries can i write in order to ge tthe desired output. examples in VB would be very much appriciated. i'm vaguely aware that u can write quries using DTS, but do we use DTS only when a remote db is used(remote as in the the databse is not in SQL server and maybe a access db). what is the easiest way of writing quries.(examples in VB)
as futher background to the project i'm doing....i have a sales cube and i'm going to build a mining model both in OLAP and in relational.
thanks

External Since: Sep 04, 2003 Posts: 88

Foodmart 2000 example data is generated without patterns in-mind. It's very
unlikely you'll find any interesting pattern other than random.

For data mining queries (aka DMX), I suggest you should check out FAQ
(http://groups.msn.com/AnalysisServicesDataMining/faq.msnw), Item 8, where
you'll find a VB app (and its sample queries) with which you can
interactively create DMX queries and run them. Please also check out other
items in the FAQ to get you started better.
--
Peter Kim
This posting is provided "AS IS" with no warranties, and confers no rights.

"jrock" <anonymous.DeleteThis@discussions.microsoft.com> wrote in message
news:08C5E40F-8E31-4D3E-AD12-FA7BB6A0A227@microsoft.com...
> In the classic foodmart 2000 example(a data set i'm taking as input into
building an mining application) in an attempt to identify patterns in
customers in SQL SERVER 2000: analysis services based on sales data(customer
transactions)...what are the patterns i should try to find and what would be
the input, target and predictable columns for those patterns....another
question is what sort of data mining prediction quiries can i write in order
to ge tthe desired output. examples in VB would be very much appriciated.
i'm vaguely aware that u can write quries using DTS, but do we use DTS only
when a remote db is used(remote as in the the databse is not in SQL server
and maybe a access db). what is the easiest way of writing quries.(examples
in VB)
> as futher background to the project i'm doing....i have a sales cube and
i'm going to build a mining model both in OLAP and in relational.
> thanks