Frontline Solvers V2015 Offers Excel Users Enterprise-Level Text Mining, Advanced Analytics, Publishing to Web Spreadsheets

Share Article

New 2015 product line release features Data Mining and Forecasting, Text Mining, Monte Carlo Simulation and Risk Analysis, Conventional and Stochastic Optimization, and Publishing Models to Excel Online and Google Sheets.

Frontline Solvers V2015 Text Mining

Term-Concept ScatterPlot

Text mining is deeply integrated with data mining, from regression methods to neural networks.

Frontline Systems is shipping a major new product line release, Version 2015 of its Solvers for Excel, including its flagship integrated product, Analytic Solver Platform, and its "professional entry-level" integrated product, Analytic Solver Pro.

The new release features powerful text mining, ensemble methods, and feature selection in XLMiner Platform, an Excel-based tool for data mining and predictive analytics that Frontline says is a serious alternative to far more expensive data mining software from SAS, IBM and others.

The release also includes new versions of Risk Solver Platform, the leading tool for simulation / risk analysis, conventional and stochastic optimization in Excel; Premium Solver Platform, Frontline’s best-selling tool for conventional optimization; subset "professional entry-level" products Premium Solver Pro, Risk Solver Pro, and XLMiner Pro; and 8 optional large-scale Solver Engines for optimization.

"Our message for Analytic Solver Platform continues to be 'no-compromise analytics in Excel'," said Daniel Fylstra, Frontline's President and CEO. "Users enjoy the ease of use of Excel, and leverage their spreadsheet model-building experience, but they don't compromise at all on functionality or performance." Analytic Solver Platform incorporates many of the most powerful algorithms for optimization, simulation and data mining available, and exploits new technology in CPUs, GPUs and cloud servers to a greater degree than many "enterprise analytics" software packages costing far more.

Upward Compatible from Excel Solver, works with Excel 2013

Frontline’s Solvers for Excel are upward compatible from the Solver included in Excel, which Frontline developed for Microsoft, and improved in Excel 2010 for Windows and Excel 2011 for Macintosh. Users can solve problems hundreds to thousands of times larger than the basic Excel Solver, at speeds anywhere from several times to hundreds of times faster, and they can solve completely new types of problems.

With powerful “plug-in” large-scale Solver Engines, including the Gurobi Solver 6.0, XPRESS Solver 26.1, and KNITRO Solver 9.1, users can solve linear mixed-integer problems with millions of decision variables, nonlinear problems with hundreds of thousands of decision variables, and many of the largest risk-based stochastic optimization problems that have ever been solved, on any platform.

New Text Mining and Predictive Analytics Power

Two highlights of the V2015 release are a powerful new text mining facility, and ensemble methods for prediction and classification -- available in XLMiner Platform and Analytic Solver Platform. Text mining is deeply integrated with data mining, unlike other software: This means users can "mine" text in comment fields in web forms, support or maintenance tickets, and the like -- and use the results, along with structured data, in any of XLMiner's prediction and classification algorithms, from regression methods to neural networks. Ensemble methods enhance the power of classification trees, regression trees, and neural networks for classification and prediction -- automatically combining the "votes" of scores of trees or networks using boosting, bagging or "random forests" methods.

Feature selection methods, new in both XLMiner Pro and Platform, are a powerful aid in what's often the most challenging task of data mining: Deciding which data to "feed" into the classification and prediction algorithms. Of all the scores or hundreds of variables or columns of data users typically have, feature selection helps them identify the right variables that have predictive power for their problem.

Other enhancements in both XLMiner Pro and Platform include automatic variable "screening" for rank deficiencies in multiple linear regression and logistic regression, "partition-on-the-fly" for all classification/ and prediction functions, ROC/RROC curves in classification and prediction reports, and confidence intervals and prediction intervals in reports.

Wide-Ranging Enhancements in Monte Carlo Simulation / Risk Analysis

In Monte Carlo simulation, V2015 adds 20 new Psi functions computing Six Sigma metrics, that users can easily drag and drop into cells from the Results gallery, or check quickly in a new side panel of the Uncertain Function chart display. Chart enhancements for both uncertain variables and uncertain functions include a new, clean look, more revealing multiple overlaid charts, new easily-applied color schemes, automatic re-sizing, editable confidence intervals, and summary statistics on the chart itself. The Sensitivity (Tornado) chart now includes a third option, a "Conditional Mean" presentation which is often more useful for decision-makers. Distribution fitting offers a new AIC/BIC criterion, and extensive Help text is available for Psi functions and each of their arguments.

Analytic Solver Pro/Platform was the first software to bring the power of data mining and visual data explora­tion, to the analysis of Monte Carlo simulation trial data. For example, one of the most popular and easiest to use data mining methods – k-means clustering – is available directly in the dialog which displays charts of simulation results. The automatically-discovered clusters of trials are displayed visually in these charts.

Use with Microsoft Power BI Amplifies "Self-Service Business Intelligence"

Analytic Solver Platform users can access and work with large amounts of data, from a variety of sources, far more easily than with other analytic software packages -- thanks to Microsoft's recent investment in data access and "self-service business intelligence," which has made Excel much more than a spreadsheet.

With Power Pivot -- an Excel add-in based on SQL Server Analysis Services' xVelocity database engine -- Excel functions as a modern, in-memory, multidimensional database, capable of holding 100 million rows of data. The Power Query add-in, based on SQL Server Integration Services, provides an exceptionally powerful and easy to use ETL (Extract, Transform and Load) capability for this in-memory database. It can draw data from a huge range of sources, from enterprise on-premise databases to cloud-based public data stores on Windows Azure Data Marketplace.

Excel users can easily summarize, "slice and dice" data from this in-memory database into Pivot Tables on the spreadsheet, and use this summarized data in an analytic model. Analytic Solver Platform can also draw representative samples of the data directly from Power Pivot, and use this data to "train" a data mining or predictive analytics model.

Publishing Optimization and Simulation Models to Web-based Spreadsheets

Since mid-2013, users of Microsoft's Excel Online in Office 365 have been able to use Frontline's Solver App, available free in the Office Store, to solve the same kinds of optimization models handled by the Solver in desktop Excel, that Frontline developed for Microsoft. Models are solved using Windows Azure cloud-based servers maintained by Frontline Systems.

Now, with release of Frontline's Risk Solver App for Excel Online, and Solver Add-on and Risk Solver Add-on for Google Sheets, advanced analytics using optimization and simulation is available to everyone. These free Apps / Add-ons will solve small models by themselves. What's more, users with Frontline's Pro and Platform products can solve much larger models, both in desktop Excel, and in Excel Online and Google Sheets. A new Publish button in the desktop software makes this as easy as possible, dealing automatically with many differences between desktop Excel and Excel Online or Google Sheets.

Academic Version and Upgrades for Existing Users Available

Users of existing Frontline Solver products can upgrade to V2015 at no cost if they have current Annual Support. This is a bonanza for users of Analytic Solver Platform and XLMiner Platform, both of whom will receive powerful text mining, ensemble methods and more at no cost. Users of Premium Solver Pro, Risk Solver Pro and XLMiner Pro can upgrade to Analytic Solver Pro for the modest difference in price.

Frontline Systems Inc. (http://www.solver.com) is the leader in spreadsheet-based analytics software, helping managers gain insights and make better decisions for an uncertain future. Its products integrate forecasting and data mining for “predictive analytics,” Monte Carlo simulation and risk analysis, and conventional and stochastic optimization for “prescriptive analytics.” Frontline developed the solvers/optimizers in Microsoft Excel, Lotus 1-2-3 and Quattro Pro, distributed to more than 1 billion spreadsheet users. Founded in 1987, Frontline is based in Incline Village, Nevada (775-831-0300).

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Daniel Fylstra
Follow us on
Visit website