This is great news – Software-plus-Services that any scientist/researcher could use. The SQL Server Data Mining folks have a Data Mining Service in the cloud they are testing out…I posted previously [OLAP and Scientific Data & Data Mining Addins for Office 2007 (Excel & Visio)] about the Excel addins that allow anyone with Excel to do Data Mining on Excel tables. Now the team is testing out SQL Server Data Mining Services – from which you can do the data mining directly from Excel 2007 or even upload a csv file.
So for fun – I downloaded a csv file of a stream gauge near Redmond into Excel and ran the “Highlight Exceptions” tool to find outliers in the dataset – it read the table, uploaded it to the service and in seconds returned the results – which included the number of outliers – in this case air temperature and it also highlighted in the table the rows. It was so easy. I can see it being used for many scientific datasets – even to clean them before doing other analysis, charting, graphs, uploads, etc.
The Table Analysis Tools included are:
- Analyze Key Influencers
- Detect Categories
- Fill from Example
- Highlight Exceptions
- Scenario Analysis
- Prediction Calculator
- Shopping Basket Analysis
Mine your Data, Any Place, Any Time
The SQL Server Data Mining team is working to extend the power and ease of use of SQL Server Data Mining to the Cloud. Our goal is provide services that allow you to build rich, predictive applications without worrying about server infrastructure, and showcase these services with cool applications that give you a glimpse of what’s possible. We bring you a technology preview of our work below. Enjoy!
Table Analysis Tools for the Cloud
Build powerful predictive reports on your data with just a few clicks!
– No data mining expertise required
– No server installation required
– All you need is your Internet connection