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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Excel Data Mining Plug-in (2005) - Analyze Key Influencers - What happens when target column is incl

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

When I click Analyze Key Influencers I am able to select a column to analyze for key factors and then picks columns to be used for analysis.  What happens when I include the column to analyze for key factors in my list of columns used for analysis?  Based on testing it doesnt seem to matter very much, but i wanted to check what happens behind the scenes in the statical processes. Thank you.

View Complete Post

More Related Resource Links

I requested access to use the excel 2005 data mining addin from our IT group and this is the message


I requested access to use the excel 2005 data mining addin from our IT group (specifically being able to connect to ana instance of analysis services and have the addin create models on the server. This is the message my IT group sent me

The 2005 data mining add in requires SSAS administrative privileges to install and operate. Since there is no separate SSAS administrative role outside of sysadmin for the instance, the IT policy is not to grant sysadmin roles to end users.

Can anyone say if this is typical at other organizations?

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 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

Importing Excel 2007 data into SQL 2005 database

I have a SQL 2005 cluster installation without SSIS and without management studio (I didn't install it). Now we need to import data from an excel 2007 file into a specific table in a database. I have tried doing this from a remote management studio, BI development studio and DTSwizard but I can't seem to make it work. The error message from BIDS is that "the data source is on a remote computer..." Does any of you have a step by step  guide that works from a remote location. BR Rasmus    

Convert excel rows wise data into column wise


public static string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;";

               OleDbDataAdapter adapter = new OleDbDataAdapter();

            OleDbCommand selectCommand = new OleDbCommand("SELECT * FROM [Sheet1$]");

            OleDbConnection connection = new OleDbConnection(connectionString);

            selectCommand.Connection = connection;

            adapter.SelectCommand = selectCommand;

            DataSet cities = new DataSet();


SSIS 2005 - Export Data into an Excel 2007 Table


Hello !

I have an excel file (xlsx) containing a table :

Excel Table

Once I launched my ssis task (successfully) to insert data in it, it is actually append after the table :

Excel Table after the SSIS task

So I am looking for a way to insert into the table and expand it with the data. I hope someone could help me.

Thank you !

'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.  



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



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 :]

Excel data mining add-in dissapears


2 of us were able to download and install the excel data mining add-in, the tab showed up in the ribbon and it behaved normally. Some number od fays later it was no longer showing in the ribbon. We re-installed more than once and it never reappears. We did see reference to enable disabled add-ins but it does not show up as disabled and in fact show up as enabled in the excel options add-in screen. We are running Office 2010, Windows 7.

Any ideas why it dissapears and why we can't even re-install it?


Extract XML data fro Excel Column

  • I have the following xml data in excel column, how do i extract data from it to a table using ssis.

    Column name XT_BODY

    <SendData><Guid>cPKNWB6XUkyIcLctQdsNkg==</Guid><Dbg>3308:1.2.3960.15716:frmDPSReportProduction:RWC_PromptControl1:Qty:OnValid:6</Dbg><_IP></_IP><_MAC>00:26:2D:26:6C:11</_MAC><_DN>KYBWS421</_DN><MSGID>t_DPS_Prod_Qty</MSGID><SEQN>000001</SEQN><CONTRACT>FRK</CONTRACT><PROD_LINE>MA11</PROD_LINE><QTY>1200</QTY><DT>20101116114300</DT><STAMP>40498.4881944444</STAMP><DEVID>WS421 </DEVID><SOURCEID>RPCC</SOURCEID></SendData>

Exctract XML Data from Excel Column


I have the following xml data in excel column, how do i extract data from it to a table using ssis.

Column name XT_BODY

<SendData><Guid>cPKNWB6XUkyIcLctQdsNkg==</Guid><Dbg>3308:1.2.3960.15716:frmDPSReportProduction:RWC_PromptControl1:Qty:OnValid:6</Dbg><_IP></_IP><_MAC>00:26:2D:26:6C:11</_MAC><_DN>KYBWS421</_DN><MSGID>t_DPS_Prod_Qty</MSGID><SEQN>000001</SEQN><CONTRACT>FRK</CONTRACT><PROD_LINE>MA11</PROD_LINE><QTY>1200</QTY><DT>20101116114300</DT><STAMP>40498.4881944444</STAMP><DEVID>WS421 </DEVID><SOURCEID>RPCC</SOURCEID></SendData>

issue with excel data column



i have a excel sheet (excel 2003) and one of the column doesn't have value in all the rows. some of the rows have value and it is integer. when i use this sheet to import, in external column, it is showing data type as unicode string, i manually changed the data type of output column to different integer types but it doesn't shows any data.

if i go back to excel sheet, change the numeric value into text (add quote next to number '999999 instead 99999) it shows me the value. what is the best method to work with this issue.

one thing is for sure, if this column will have value that will be always integer.

any help,




mark it as answer if it answered your question :)

Data mining add-in for Excel 2010

has the add-in for Excel 2010 been released? (sql server 2008 r2), if so do you know in what is the link to download?
Javier Guillen

Data Mining add in for Excel 2007 video tutorials



Does any one knows where can i get Data Mining add in for Excel 2007 video tutorials? (Classify, Estimate,Cluster, Associate, Etc.)

All i can find are videos tutorials for Data Mining table analysis tool.




Excel 2007 Data Mining Add-in disappear



I install add-in and run fine for a while, then all of sudden I could not see Table Analyze tool and data mining tab at my ribbon. I re-run server configuration and re-connect to DMAddinDB (remote server, but I am the administrator), but data mining add-in and table analyzer still not showing at my ribbon.


Then I uninstall DMAddin, re-install it, go through configuration again, but still the tabs are not showing up.


Any idea you can help me get my add in back?

Error inserting data in Excel spreadsheet from SQL 2005 SP



I am using a SP on a SQL 2005 server to insert data into an Excel spreadsheet.

If I run the following query:



INTO OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0','Data Source ="\\wvns01\data\Finance\ZIP\FY2011_testZIP\BankFile.xls";extended Properties=Excel 8.0')...

Import excel data to Sql Server 2005 problem




I have tried to import data from Excel 2003 to Sql Server 2005 using the Import Wizard to no avail.  Here is my issue:


Excel column has            After import, database table

these value sets:             has these corresponding value sets:

1.01                              null

1.02                              null

1.04                              1.04

1.05                              1.05

1.06                              null

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