Unix Technical Forum

Broken Lift Chart and Empty Classification Matrix in Data Mining

This is a discussion on Broken Lift Chart and Empty Classification Matrix in Data Mining within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi, I am studying data mining features of SSAS and for a workshop I've created 2 views derived from ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-01-2008, 02:40 PM
ist
 
Posts: n/a
Default Broken Lift Chart and Empty Classification Matrix in Data Mining

Hi,
I am studying data mining features of SSAS and for a workshop I've
created 2 views derived from vTargetMail view of AdventureWorksDW.
Train data consists every record except those in Pacific, and test
view consists only records from Pacific area.

1. I've created a mining structure based on Decision Tree and selected
BikeBuyer as predictable column.
2. According to input column suggestions, I've selected Age,
Eng.Education, NumberCarsOwned, YearlyIncome, CommuteDistance,
NumberChildsatHome and TotalChildren as input columns,
3. I've modified no other setting, and deployed project.

I can get training results in decision tree browser and dependency
network (and both seem to give rather logical results) however, when I
try to browse lift chart or classification matrix I get an empty
class.matr. and a lift chart of a single 45 degree line.

Am I missing a step, or must I do some fine-tuning on (what)
parameters?


Thanks...

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 03-01-2008, 02:40 PM
Dejan Sarka
 
Posts: n/a
Default Re: Broken Lift Chart and Empty Classification Matrix in Data Mining

Hi!

Do please check my answer to your previous post (Data Mining Training gives
No Results). You have the same problem - the content of your attributes.
This time, the wizard declared couple of attributes as continuous, and what
you got is a Regression Tree.

--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/


"ist" <saygin@gmail.com> wrote in message
news:1188988693.231953.209180@y42g2000hsy.googlegr oups.com...
> Hi,
> I am studying data mining features of SSAS and for a workshop I've
> created 2 views derived from vTargetMail view of AdventureWorksDW.
> Train data consists every record except those in Pacific, and test
> view consists only records from Pacific area.
>
> 1. I've created a mining structure based on Decision Tree and selected
> BikeBuyer as predictable column.
> 2. According to input column suggestions, I've selected Age,
> Eng.Education, NumberCarsOwned, YearlyIncome, CommuteDistance,
> NumberChildsatHome and TotalChildren as input columns,
> 3. I've modified no other setting, and deployed project.
>
> I can get training results in decision tree browser and dependency
> network (and both seem to give rather logical results) however, when I
> try to browse lift chart or classification matrix I get an empty
> class.matr. and a lift chart of a single 45 degree line.
>
> Am I missing a step, or must I do some fine-tuning on (what)
> parameters?
>
>
> Thanks...
>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 03-01-2008, 02:40 PM
ist
 
Posts: n/a
Default Re: Broken Lift Chart and Empty Classification Matrix in Data Mining

For anyone who is interested; the problem is solved by changing my
computer's regional and non-unicode programs configurations to US
English (which were set to Turkish).

Thanks Mr.Sarka...


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:46 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com