Mittwoch, 2. Mai 2012 07:45
i've been trying for two days now to go through the example file included with DM addins. What I want to do is to get a someone reasonable prediction of BikeBuyer column for testing data, however, no matter what I've try I end up with nothing.
Has anyone succeeded in doing so?
Mittwoch, 2. Mai 2012 12:57
I have. I've been reading your threads and trying to figure out the best way to help you. I'm pretty new to this stuff myself. The book: SQL Server 2008 data mining has an excellent chapter on the data mining add-in for Excel. It walks you through examples for everything.
Here is a tutorial specific to the data mining add-ins. http://enterprise.waltoncollege.uark.edu/Example_SQL_Server_2008_Data_Mining_Addins_for_Excel2010.docx
I've started the first of a series of blog posts I intend to write about the data mining add-in. So, far I just have the set up complete. I hope to have another post completed today. You will be able to post comments on the blog entries to ask questions.
- Als Antwort vorgeschlagen Jerry NeeModerator Montag, 7. Mai 2012 06:12
Mittwoch, 2. Mai 2012 14:21
I've skimmed the DOC, and it basically walks through what does what.
My problem is, that no matter what model I use, what input columns, it only predicts like 20 new customers as bike buyers, which, obviously, is incorrect. Even coming down to 0.1 probability doesn't help, although the lift chart is pretty decent, at 40%.
Mittwoch, 2. Mai 2012 20:22Beantworter
Another resource if you are new to the add-ins is this series of video tutorials on TechNet.
They all use the sample data shipped with the Data Mining Add-ins. The video for Analyze Key Influencers covers the bike buyer scenario, although it only shows patterns, not predictions.
I like all the detail in Mike's example. OK if I post a link on the TechNet portal?
SQL Server UE, Data Mining
- Als Antwort vorgeschlagen Jerry NeeModerator Montag, 7. Mai 2012 06:13
Donnerstag, 3. Mai 2012 13:42