Showing posts with label purposes. Show all posts
Showing posts with label purposes. Show all posts

Sunday, February 12, 2012

beginner Analysis Services question

I'm looking into learning how to use Analysis Services- the problem , (for
learning purposes) I have set up is 1,000,000 rercords , which are made up
of opinions about various topics . It is one column , with up to 1000
length.
Does Analysis Services posess algorithms that will estimate , for example
Male or Female? Or does a developer have to build in the rules ?
--
Jack Vamvasyour table contains only 1 column which is a 1000 characters length?
When you say "estimate male or female" what do you mean by estimate? do you
talk about datamining?
"what is the probability of having male for a set of cases?"
"Jack Vamvas" <delete_this_bit_jack@.ciquery.com_delete> wrote in message
news:bOednQHceO9eqs_ZRVnyjg@.bt.com...
> I'm looking into learning how to use Analysis Services- the problem , (for
> learning purposes) I have set up is 1,000,000 rercords , which are made
> up
> of opinions about various topics . It is one column , with up to 1000
> length.
> Does Analysis Services posess algorithms that will estimate , for example
> Male or Female? Or does a developer have to build in the rules ?
>
> --
> --
> Jack Vamvas
>|||Correct, it's just a recordset of opinions on a certain topic.
By estimate, I mean "would the comment most likely be made by a female or
male?"
--
Jack Vamvas
"Jeje" <willgart@.hotmail.com> wrote in message
news:#dJt7v5aGHA.4060@.TK2MSFTNGP02.phx.gbl...
> your table contains only 1 column which is a 1000 characters length?
> When you say "estimate male or female" what do you mean by estimate? do
you
> talk about datamining?
> "what is the probability of having male for a set of cases?"
> "Jack Vamvas" <delete_this_bit_jack@.ciquery.com_delete> wrote in message
> news:bOednQHceO9eqs_ZRVnyjg@.bt.com...
(for[vbcol=seagreen]
example[vbcol=seagreen]
>|||a recordset of opinion... but is it 1 column only? how do you identify male
/ female on it?
By the way, you looking for a text mining tool, not an OLAP tool.
SSIS could extract terms from your sentence and generates a table of terms.
Or a recommand to use a survey tool.
these tools can do a lot of things and statistics with a minimum work.
"Jack Vamvas" <delete_this_bit_jack@.ciquery.com_delete> wrote in message
news:BoidnT7nxe1uC8nZnZ2dnUVZ8s6dnZ2d@.bt
.com...
> Correct, it's just a recordset of opinions on a certain topic.
> By estimate, I mean "would the comment most likely be made by a female or
> male?"
> --
> --
> Jack Vamvas
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:#dJt7v5aGHA.4060@.TK2MSFTNGP02.phx.gbl...
> you
> (for
> example
>