THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

Data Mining Addin for Excel

My experience with the term "add-in" was that you have a piece of software put on top of a bigger software, just to enable some little functionality. Today at SQL Pass 2006 I've seen how this term has to be redefined.

The Data Mining Add-ins for Office 2007 (CTP Nov 06 downloadable here) transforms your Excel 2007 and Visio 2007 products in full featured Data Mining clients. It requires Analysis Services 2005, but no work is required, the client can be used both to browse existing models or to create whole new models, starting from data contained in Excel or accessible from Data Sources defined into Analysis Services 2005 databases. One limitation of the current CTP (Nov. 06) is that it requires the Beta 2 Technical Refresh version of Excel 2007; a new add-in will be released shortly with a full support for Office 2007 RTM.

This "add-in" changes the accessibility of the Data Mining features of Analysis Services 2005. Yesterday Microsoft only had the server, today Microsoft has also the client, that fully leverages the power of Excel 2007. Guys, the demo was really impressive for the easy of use and the power that this add-in gives to end-user, not to mathematicians.

Published Thursday, November 16, 2006 9:20 PM by Marco Russo (SQLBI)

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement