.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Asad Ali
Post New Web Links

How to calculate VIF and Odds ration in data mining

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
 
How to calculate VIF and Odds ratio using Microsoft logistic regression.


View Complete Post


More Related Resource Links

SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005

  

In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.

Jamie MacLennan

MSDN Magazine September 2004


Data Mining requirement specifications

  
  Hello All, Kindly I'm working now in a data mining project and we decided to use SQL server 2008 analysis services data mining algorithms. Now as we are at the start of the project we need to prepare all the required documentations like the requirement specification documents. can anyone help me in getting a template or guidance for the requirement document template or contents.   Regards, HebaHeba El-Desouky

Data Mining - Business User's view

  
Using BIDS, when I create a Mining model solution I can see lot's of useful utilities like Mining Model viewer, Mining Model Prediction etc that comes with lot's of graphs' etc. What would be the best approach to display these graph's to business users. Can I do this efficiently using SSRS or Do I need to use PowerPivot etc..

Data Mining solution - SSRS Problem

  
I have created a Data Mining - Time Series solution and I am getting proper results from SSAS(Mining Model prediction tab) & SQL Management Studio query. However when I try to create an report using SSRS, In the field where I am expecting the predicted value, I am getting "#Error" Any suggestions as why this is happening.

Microsoft Data Mining VS SAS Enterprise Miner

  
Hi We are thinking about using either Microsoft's data mining module for a task or use SAS Enterprise Miner. Price is not a factor. It is my impression that SAS Enterprise Miner is stronger concerning configuring the models with the statistical parameters etc. Does anyone know good arguments for using or not using Microsoft when price is NOT an issue? Thanks, Dennis

Extracting Association Rules from Data Mining Model

  
Hi I have succesfully created a Data Mining Model using the Association Model. I have deployed and processed it. I need to extract all the rules that is generated by the model. I know that you normally query the model using DMX prediction queries, but in this case I need to extract the rules to a separate table for further processing. I have tried the following approaches unsuccessfully: 1. Linked server in MSSQL Management Studio. DMX query using OpenQuery. The DMX query looks like this: SELECT FLATTENED NODE_CAPTION, NODE_SUPPORT, NODE_PROBABILITY, MSOLAP_NODE_SCORE FROM DataMiningModel.CONTENT WHERE NODE_TYPE = 8   On small models this method works. On larger models with many rules I receive an exception: "XML for Analysis parser: The XML for Analysis request timed out" before it was completed This always happens after 70min. I might have missed a timeout option? 2. Using SSIS to run the same DMX query as above. The method is presented here: http://www.sqlservercentral.com/articles/MDX/64697/ This method works on small models. On larger models that did not work with method 1, it return rules. The number of rules returned is sometimes different for the same package run multiple times. For the largest models it simply returns 0 rules. I suspect that the same XML Parser error happens under the hood of SSIS. I'm currently stuck, and need some inp

Is data mining techniques better than using fulltext , soundex , pattern to search records? heres my

  
<!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0; mso-font-charset:2; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:0 268435456 0 0 -2147483648 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} p {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} /* List Definitions */ @list l0 {mso-list-id:27487746; mso-list-template-ids:77652700;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l1 {mso-list-id:297423348; mso-list-type:hybrid; mso-list-template-ids:1760099356 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;} @list l1:level1 {mso-level-tab-stop:66.0

Data mining addin for excel 2010

  
Anyone know when be available the data mining addin for excel 2010?  in this moment the current addin doesnt work in excel 2010 .. Thanks for any infoJuan Alvarado - MVP SQL SERVER

Data Mining Solution Question

  
Hi, I am working for a company that would like to use Aanalysis Services for predictive analytics. My problem is that there are only 40 or so months worth of data. I am wondering if this is enough to even make anything relevant and/or accurate.   So far I've made a time series mining structure, that just uses the booking number as input and predict. I am having a hard time justifying this as they view it as something that could have just been done in excel.   Also I have made a neural network. The company has several (continuous) metrics that they track along with bookings. So I made a neural network to use these inputs to predict the bookings.   This made another problem. The prediction that the neural network makes is different from the next month that that time series predicts and is causing distrust by the potential end users.   I've thought about combining the two models. I could use the output of the neural net and do a natural prediction join of that result into the time series.   Seeking advice, and something that I can do with Analysis Services that could be useful to a company with only a small number of months of data to work with.   -S

Data Mining Solution Question

  
Hi, I am working for a company that would like to use Aanalysis Services for predictive analytics. My problem is that there are only 40 or so months worth of data. I am wondering if this is enough to even make anything relevant and/or accurate.   So far I've made a time series mining structure, that just uses the booking number as input and predict. I am having a hard time justifying this as they view it as something that could have just been done in excel.   Also I have made a neural network. The company has several (continuous) metrics that they track along with bookings. So I made a neural network to use these inputs to predict the bookings.   This made another problem. The prediction that the neural network makes is different from the next month that that time series predicts and is causing distrust by the potential end users.   I've thought about combining the two models. I could use the output of the neural net and do a natural prediction join of that result into the time series.   Seeking advice, and something that I can do with Analysis Services that could be useful to a company with only a small number of months of data to work with.   -S

data mining using nural network

  
<!-- [if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"

data mining using nural network

  
<!-- [if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"

Optimizing Data Mining processing time for a Time Series model in SQL Server 2008 R2

  

Does anyone have any references around optimizing the initial processing time for a data mining model? Books, blogs, etc. I have the Wiley “Data Mining with SQL Server 2008” book, and while I’ve learned a lot from it, it doesn’t seem to cover much around trouble shooting things like processing time. I also have a few other books that have a chapter or two on data mining, but again just basic “here’s what it is and how to set it up”, nothing that quite covers trouble shooting or optimization. I’ve also checked out the various Data Mining blogs/sites.

 

I’ve got a Microsoft Time Series model I’m basing on a Cube. Very simple, trying to forecast sales. I have one dimension which is the list of products (about 1600), a second which is the time dimension, finally the measure is daily sales figures for each, about 3.2 million rows in total. On a brand new server, with two quad core processors and 16 gig of ram it took 40 hours to process. Seems rather high?

Data Mining With Direct Marketing

  

Hello Data Miners!

 I have been reading about Data Mining in preperation for my assignment titled 'How are data fusion and data mining used to improve the effectiveness of direct marketing?' , as you are all no doubt the tip top brains of Data Mining, I was wondering if you could point me in the direction of anything useful you can see for my assignment, I have currently been reading 'Mastering Data Mining' and 'Data Mining Cookbook'.

 

Thank you all! Smile

 

-Meowth

How to use the library Data Mining Web Content Viewer

  

Hi all!

I am developing a web application that will work with Data Mining-models deployed to Analysis Services. I downloaded the library Data Mining Web Content Viewer of Microsoft SQL Server 2008 R2 Feature Pack (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ceb4346f-657f-4d28-83f5-aae0c5c83d52&displaylang=en). Installed it in the Program Files folder appears Microsoft SQL Server 2008 DM Content Viewer, in which many assemblies

 

Microsoft.AnalysisServices.DLL



Microsoft.AnalysisServices.Controls.DLL



Microsoft.AnalysisServices.DeploymentEngine.dll



Microsoft.AnalysisServices.Design.DLL



Microsoft.AnalysisServices.Graphing.DLL



Microsoft.AnalysisServices.Importer.DLL



Microsoft.AnalysisServices.Normalizer.DLL



Microsoft.AnalysisServices.OleDbDM.DLL



Microsoft.AnalysisServices.OneClickCube.DLL



Microsoft.AnalysisServices.Project.dll



Microsoft.AnalysisServices.TimeDimGenerator.dll



Microsoft.AnalysisServices.Viewers.DLL



Microsoft.AnalysisServices.Wizards.DLL



Microsoft.DataWarehouse.DLL



Microsoft.DataWarehouse.Interfaces.DLL



Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll



Microsoft.SqlServer.Batchparser.dll



Microsoft.SqlSer

'Culture 'en' is a neutral culture - excel data mining add-in

  

I am running the SQL Server data mining add - in for excel and have been running into problems with certain Data mining functions.  In particular anything that uses the tree graph.  I am receiving the following error.  I have a colleague that has installed the same add-in and is not running into any issues.  I have exhausted all obvious trouble shooting steps with no luck. I am running into a brick wall when it comes to finding anyone else experiencing this issue with regard to this add-in.  

=================================================

ERROR MESSAGE:

The tree graph cannot be created because of the following error:

'Culture 'en' is a neutral culture. It cannot be used in formatting and parsing and therefore cannot be set as the thread's current culture.

=================================================

The language on my PC is set to English (United States).  All references to this error that I have been able to find, which is limited to a couple obscure postings, are associated with programming and setting the culture in the code or under properties - neither apply to using the add-in within Excel.  Can someone please shed some

EXCEL 2007 DATA MINING

  

Recent install of add in  Excel data mining on excel 2007 when I press the classification matrix button for example it gives me the error : A connection to analysis service is required to perform the classification matrix task. Click the no connection button on the data mining tool bar to create a new connection.

I click new connection then new,, I type in my name , and then test connection then another error Test connection Failed Aconnection cannot be made ensure that the server is running : No such host is known.

Can someone please help me with this so i may use the data mining feature on my spread sheets thanks in advance :]


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend