New Tools Simplify Data Mining

Published

In this era of big data, researchers are relying more and more on data mining to help them with their research. Researchers from nearly every field (not to mention businesses from almost every sector) are slicing, dicing, and sifting an exponentially growing mass of data, looking for patterns, trends, and insights. This is powerful stuff, and the essence of the data-intensive “fourth paradigm” of scientific inquiry. 

Powerful, yes, but also complex. Data mining requires numerous steps: data understanding, data cleaning, model creation, and model comparison. Fortunately, there are new tools for Microsoft Excel that make each step simpler and combine them more seamlessly. 

New add-ins for Microsoft Excel that simplify data mining are available to download.
New add-ins for Microsoft Excel that simplify data mining are available to download.

Microsoft Research Podcast

AI Frontiers: Models and Systems with Ece Kamar

Ece Kamar explores short-term mitigation techniques to make these models viable components of the AI systems that give them purpose and shares the long-term research questions that will help maximize their value. 

Listen now

These tools, collectively known as the Microsoft SQL Server 2012 SP1 Data Mining Add-ins for Office (just rolls off the tongue, yes?) are the product of a joint effort between the Data Mining SQL team and the Microsoft Research Machine Learning and Applied Statistics group (opens in new tab).  The tools are available for download (opens in new tab).

Microsoft Data Mining Add-ins help you take advantage of SQL Server predictive analytics in Microsoft Excel and Microsoft Visio. The download includes the following components:

  • Table Analysis Tools for Excel: This add-in provides easy-to-use tasks within Excel that utilize SQL Server 2012 data mining models to deliver quick insights on your spreadsheet data. With just a few clicks, you can analyze key influencers for a given outcome, highlight exceptions, automatically detect groups, fill in missing data, make time series forecasts, or do market basket analysis.
  • Data Mining Client for Excel: By using this add-in, you can create, test, explore, and manage data mining models within Excel, by using either your spreadsheet data or external data that is accessible through your SQL Server 2012 Analysis Services instance.
  • Data Mining Templates for Visio: This add-in enables you to render and share your mining models as annotatable Visio drawings.

This integrated, comprehensive set of tools should make life simpler for anyone with big data to mine.

—David Heckerman (opens in new tab), Distinguished Scientist, Microsoft Research 
—Raman Iyer (opens in new tab), Principal Group Manager (Development), SQL Server Business Intelligence, Microsoft Corporation

Learn More