What's New in XLMiner V4.0

We've been investing in further development of XLMiner, the easy-to-use data mining add-in for Excel that we acquired just over a year ago from Cytel Corporation and Statistics.com LLC.  XLMiner has traditionally offered surprisingly powerful data mining and predictive analytics in an Excel add-in, but graphics were not its strength.  We've changed that in our new release, XLMiner V4.0.

Now, XLMiner includes powerful data exploration and visualization features to support the ‘front end’ of business data analytics.  To aid analysis using multiple, disparate ‘Big Data’ sources, XLMiner now works with Microsoft PowerPivot, sampling from datasets with up to hundreds of millions of rows.

Data Visualization – Beyond Excel Charts

Excel has traditionally included extensive tools for creating charts and graphs, but these were designed primarily for presentation, not for exploration and visualization of complex inter-relationships in multivariate data. Now in XLMiner V4.0, you can easily explore and visualize your data direcly in Excel.

• Use our Chart Wizard, or create new charts with a single click -- then change axes and colors, or create multi-panel charts with one more click.
• With multiple linked charts, you can select data points of interest in one chart, see the same point highlighted in other charts, and see the actual data values in a side window.
• Easily filter your data with simple sliders and checkboxes. Use your mouse to zoom in on a part of a chart, and zoom back out.
• Create multi-variable displays like a scatterplot matrix or parallel coordinates chart, with a single click.

Work with 'Big Data' using XLMiner's New PowerPivot Support

Do you want to apply data mining methods to very large datasets, or multiple datasets from different sources? Yes, you CAN do this in Excel, with XLMiner V4.0 and Microsoft's PowerPivot add-in!

PowerPivot for Excel (www.powerpivot.com) is a free add-in from Microsoft’s SQL Server group that brings a powerful database engine into memory with Excel. It handles up to hundreds of millions of rows of data in Excel. What's more, PowerPivot makes it easy to integrate data from multiple disparate data sources – including Microsoft’s Window Azure Data Marketplace, with a huge array of publicly available datasets – into one, potentially quite large, in-memory relational database.

In XLMiner V4.0, we've extended XLMiner's "sample from database" facility to sample from the in-memory database maintained by PowerPivot. So you can explore, visualize, and build a data mining model for any sort of data that you can bring into Excel through PowerPivot!

Supports Excel 2013, and the New PowerPivot

Unlike XLMiner V3.x and many other Excel add-ins, XLMiner V4.0 works with new Excel 2013 Preview Edition, available as a free download for 'public beta' testing and evaluation, as a part of Office 2013 Preview, and with the RTM (Release to Manufacturing) version that will be available in early 2013. In Excel 2013, a new version of PowerPivot is included 'in the box' with Excel -- and XLMiner V4.0 works with this new version of PowerPivot, right now!

What you can do next