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

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

Data Mining add in for Excel 2007 video tutorials

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server


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.




View Complete Post

More Related Resource Links

Video: Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists

Learn how to use the Open XML SDK 2.0 to create Excel 2007 PivotTables that are connected to data stored in SharePoint lists.



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

MOSS 2007 Tutorials video

This link about how create sharepoint website ,blogs,team site,document lib etc

display data in excel 2007


 I am using .net  version 1.1  and  excel 2003 to display data.I need to display data in 2007 .Can  anyone suggest the reference to be added ,connection string change and what should be imported.  

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

Reading data from Excel 2007

I am attempting to read data from an uploaded spreadsheet using ACE.OLEDB. The code, which is running fine on dev and test machines for XL2003/2007 reports "External table is not in the expected format" error on connecting on the production server for XL2007 only. The code is Dim connectionString As String = "provider=Microsoft.Ace.OLEDB.12.0;" _ & "Data Source='" & ImportData.FullName & "';Extended Properties=Excel 12.0;" LogWebActivity.LogThis("Entering POPSUKD, ConStr=" & connectionString, LogWebActivity.LogDetailLevel.DetailAndData) Dim con As New System.Data.OleDb.OleDbConnection(connectionString) LogWebActivity.LogThis("Dimmed con", LogWebActivity.LogDetailLevel.Debugging) Try Dim cmdSelect As New System.Data.OleDb.OleDbCommand("SELECT * FROM [" & WorksheetName & "$]", con) Dim adapter As New System.Data.OleDb.OleDbDataAdapter(cmdSelect) Dim dS As New Data.DataSet LogWebActivity.LogThis(cmdSelect.CommandText, LogWebActivity.LogDetailLevel.Debugging) con.Open() LogWebActivity.LogThis("Opened Connection", LogWebActivity.LogDetailLevel.Debugging) adapter.Fill(dS, WorksheetName) LogWebActivity.LogThis("Filled DataAdapter", LogWebActivity.LogDetailLevel.Debugging) _SKUS = dS.Tables(W

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    

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 !

Initialization of the data source failed in Excel 2007 from As 2008R2


Environment: Win server 2003 , Office2007, SQL Server2003, PowerPivot for Excel

All the user do have access to connect the cube. am the admin user and i get the same error message.

"Initialization of the data source failed. Check the database or contact your database administrator. Make sure the external database is avaliable, and then try to operation again.

I have tried deleteing the data source and creating a new one.

Can any one help with this there are other fourms on this but i can't see a answer for it.


'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

CLASS Not Registered - Excel 2007 Data Source (Not 64 Bit machine)


First off, I am not running on a 64 bit machine.

I keep getting the following error when I try to run a task that has an ODBC connection to an xlsx file on a SQL Server 2005 server using SQL Server Agent.

Executed as user: ACCT02\ssc_emr_ra. ... 9.00.4035.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  7:29:39 AM  Error: 2010-10-28 07:29:42.63     Code: 0xC0202009     Source: RFC_Data_Load Connection manager "Excel ODBC Connection"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040154.  An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".  End Error  Error: 2010-10-28 07:29:42.63     Code: 0xC020801C     Source: Data Flow Task OLE DB Source [3052]     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel ODBC Connection" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method c

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?


SSAS 2008 data refresh problem in Excel 2007



My problem sounds like that:

I have some cube created with SSAS 2008 and I'm using Excel 2007 as browser to view cube data.

I made pivot table with nessesary data, everything works fine till I save excel file and sent it to my client.

When client uses some filter, some row measures disapear. Dimension data are shown, measures are blank cells, but calculations from those measures is filled.

e.g. I see difference of sales between years in percent, but I can't see measures, which were used to count that difference, because in excel I see blank cells.

Any ideas?

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

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


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.

Video: Using the Excel Services REST API to Access Excel Data in SharePoint Server 2010 (Visual How

Watch a short video that shows how to programatically retrieve data from an Excel workbook.
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