Re: Multiple Quesions and some feedback on Modelling

See my answer for Q7 inline:

> Inline are some answers.
>
> > 1. How to EDIT/CHANGE NUM of Clusters (seems defaults to 10)
>
> Click on the Mining Models tab, right-click on the model and select Set
> Agorithm Parameters option.
>
> > 2. LIFT CHART for 2+ models instead of current model, how?
>
> You can have a single lisft chart for multiple models that share the same
> structure.
>
> > 3. using Clustering model, input includes firstName and lastName,
> > characteristics indicates that both values are missing -- good
> > and yet, probability histogram/bar has 60-70% 'mark', why not blank?
> > since they are not determinants for prediction attribute -- income.
>
> Why do you need names in the model anyway?
>
> > 4. Any way to change a model structure's source table (not edit ds view)?
>
> AFAIK no - create a new model. You could help yourself with ds view, as you
> mentioned, or with a wiev in the relational database. You could refer to the
> view in the structure and then change the view definition as needed.
>
> > 5. Have a model structure that entails three mining models including tree.
> > One input is yearlyIncome set to descretized and for the tree model,
> > parameter for force regressor has no values set at all. Still,
> > while processing all models I got an error, "xxx model, column xyz must
> > be of continous type since REGRESSOR flag is set on for it." but
> > that flag has no value at all, which I construed as not set. ?
> > And if I make the yearlyIncome column of continous type, then my naive
> > bayes
> > model in this structure would complain. So, how do we deal with it?
> > I must have this column.
>
> Set the attribute to discretized in the minimg structure (use the Mining
> Structure tab), and clear the regressor flag for this attribute for the DT
> model (using Mining Models tab).
>
> > 6. model status: how can you tell if it has been trained in BI dev studio?
> > and similary, define the word, 'Process' here as in Process a model?
> > Is it Train model data only or more? And if more, what's that?
> > same question goes for it for sql management studio, my initial thought
> > was they are trained already for sql management studio because otherwise
> > they won't be deployed at server, however, I still see the menu option
> > "Process", would it imply that the model may have changed, hence, the
> > need for re-train etc.?
>
> Process means to re-train, so the model does not have to change - you can
> reprocess it because you have some new data. So disabling the option when
> the model is processed for the 1st time wouldn't be very useful.
>
> > 7. Legend: relationship between prediction probability and score?
> > Case in mind, a naive bayes model generated 75.51% prediction probability
> > and the score is 0.78. Also, a tree model did not show legend, could
> > it because my window settings mess up? On a similar note, some model has
> > a score of 10.78 something, how come? Or possibly that model wasn't
> > created
> > properly. BOL does not seem to explain the term Score here.

[ZHT]: Predict probability in NB is calcualted based on the normalized score of the probability of each input attribute.
While the score described in the NB Discrimination View is purely based on the correlation count of a single input attribute (see the cross table in the mining legend)


>
> I will leave this one to the DM team:-)
>
> > 8. where can I find a updated copy of MS_DM_Tutorial if there's any
> > revision?
> > (for MS SQL Server 2005)
> > by
> > Seth Paul,Jamie MacLennan,Zhaohui Tang,Scott Oveson
> > Microsoft Corporation
> > 07/2004
>
> There is a tutorial in Books OnLine, and
> http://www.sqlserverdatamining.com/DMCommunity/Tutorials/default.aspx.
>
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
>
>
.

Loading