If you’ve ever been interested in using datamining tools – but don’t have the time to figure out how it all works…take a look at these add-ins for the Excel2007. With the data in a spreadsheet – you can kick off an analysis.
I can see this a great way to clean and analyze data…especially scientific data.
Microsoft SQL Server 2005 Data Mining Add-ins for Office 2007 (Data Mining Add-ins) allow you take advantage of SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007. The download includes the following components:
- Table Analysis Tools for Excel: This add-in provides you with easy-to-use tasks that leverage SQL Server 2005 Data Mining under the covers to perform powerful analytics on your spreadsheet data.
- Data Mining Client for Excel: This add-in allows you to go through the full data mining model development lifecycle within Excel 2007 using either your spreadsheet data or external data accessible through your SQL Server 2005 Analysis Services instance.
- Data Mining Templates for Visio: This add-in allows you to render and share your mining models as annotatable Visio 2007 drawings.