can someone walk me through DM sample excel?
-
Mittwoch, 2. Mai 2012 07:45
hello,
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?
Alle Antworten
-
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.
http://bidn.com/blogs/MMilligan

Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz- Als Antwort vorgeschlagen Jerry NeeModerator Montag, 7. Mai 2012 06:12
-
Mittwoch, 2. Mai 2012 14:21
Very nice!
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.
http://technet.microsoft.com/en-us/library/dd299424(v=sql.100).aspx
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?
http://technet.microsoft.com/en-us/sqlserver/cc510301.aspx
SQL Server UE, Data Mining
- Als Antwort vorgeschlagen Jerry NeeModerator Montag, 7. Mai 2012 06:13
-
Donnerstag, 3. Mai 2012 13:42Certainly! Thank you!

Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz

