Share with your friends


Analytics Magazine

Frontline shipping V. 2017 of Solvers for Excel and Analytic


“We’re making advanced analytics power tools and learning aids accessible to every business analyst,” says Daniel Fylstra, Frontline’s president and CEO. “Our users can build models with point-and-click ease of use, while taking advantage of the most advanced analytic algorithms and methods.”

In this release, Frontline is making available to all users Analytic Solver Basic V2017, a new version of its Analytic Solver Platform for Education product, formerly offered only for university MBA programs and used to learn by hundreds of thousands of students. Analytic Solver Basic includes every feature of Frontline’s analytics software, but handles only limited-size models and data sets, suitable for learning. (All of the 100+ example models and data sets included with the software can be used.) A software license is just $250 per year and includes both the desktop version and access to Paired with Solver Academy, Frontline’s new Open edX-based online learning platform, Analytic Solver Basic offers a way for business analysts to gain “advanced analytics ninja” skills.

Analytic Solver Basic gives the user an ongoing “free trial” opportunity for all the large-capacity products that Frontline offers. Users can simply create or open models or data sets larger than Analytic Solver Basic’s limits – and run them. The software enters “Test Run Summary Only” mode, and runs the problem but delivers only summary information such as the final objective in optimization or key statistics in simulation/risk analysis, then recommends the best upgrade option. After a simple, point-and-click upgrade step, the user has both the large-capacity product and Analytic Solver Basic, with its ongoing “free trial” of other functions.

Also in this release, Frontline has implemented a new cloud-based software licensing system, similar to the approach taken by Adobe Systems. Users can now install and use Frontline’s software on multiple computers, such as a desktop, laptop, home PC or virtual machine – but only one of these at a time. A multi-user license option enables organizations to share a license among multiple users and multiple machines, without having to run a special “license server.” Licenses can be used while disconnected from the Internet, for lengths of time specific to the license.

The V2017 release features further significant enhancements to Frontline’s popular Evolutionary Solver for optimization, focusing on the most difficult non-smooth, non-convex models with integer variables.

The new release features support for industry-standard PMML (Predictive Model Markup Language) for Analytic Solver’s full range of classification, prediction, and time series forecasting methods, as well as PMML extensions for text mining. Other data mining enhancements include:

  • Ability to create ensembles of any combination of six different classification methods or four different prediction methods.
  • Direct use of categorical variables in many predictive algorithms that, in other analytics software, can use only continuous variables
  • Ability to “fit,” store and apply to new data a wide range of data transformation and unsupervised learning tools, such as PCA and clustering.
  • Enhanced neural networks with any number of layers, and better scaling, training and activation function options,
  • Enhanced reports and charts, especially for model evaluation, and simplified functions to apply predictive models in Excel worksheets.

Other enhancements include support for very high resolution (4K) monitor, and support for a new version of Tableau Software’s Web Data Connector.

In this release, Frontline has simplified its product line and renamed most products. Frontline continues to offer eight plug-in, large-scale Solver Engines for optimization, upgraded in the new release, that work with Analytic Solver Optimization and Analytic Solver Comprehensive.

The new V2017 release is available at

Related Posts

  • 74
    Frontline Systems is shipping a new product line release for desktop and cloud, Analytic Solver 2017-R2 for Excel and enhancements to, its SaaS equivalent.
    Tags: solver, analytic, frontline, excel, release, models, optimization, data, software, analytics
  • 62
    Frontline Systems has released XLMiner SDK V2018, a next-generation version of its Software Development Kit for data mining, text mining, forecasting and predictive analytics. XLMiner SDK offers application developers working in C++, C#, Java, Python or R a powerful, high-level API for quickly creating applications that use predictive analytics.
    Tags: data, predictive, software, analytics, frontline
  • 56
    As the Big Data Analytics space continues to evolve, one of the breakthrough technologies that businesses will be talking about in the coming years is prescriptive analytics. The promise of prescriptive analytics is certainly alluring: it enables decision-makers to not only look into the future of their mission critical processes…
    Tags: analytics, prescriptive, data, software
  • 50
    Use of the term “business analytics” is being used within the information technology industry to refer to the use of computing to gain insight from data. The data may be obtained from a company’s internal sources, such as its enterprise resource planning application, data warehouses/marts, from a third party data…
    Tags: analytics, data, predictive, prescriptive
  • 49
    November/December 2014 The marriage of two “natural resources” – hydrocarbons and data – will transform unconventional oil development. By Atanu Basu (right), Daniel Mohan and Marc Marshall Known-knowns, known-unknowns and unknown-unknowns. Donald Rumsfeld’s notable turn of phrase is an apt characterization of where we are with unconventional oil development today.…
    Tags: data, analytics, sets, prescriptive, predictive


Artificial intelligence a game changer for personal devices

Emotion artificial intelligence (AI) systems are becoming so sophisticated that Gartner, Inc. predicts that by 2022, personal devices will know more about an individual’s emotional state than his or her own family. AI is generating multiple disruptive forces that are reshaping the way we interact with personal technologies. Read more →

FICO predicts AI and blockchain will meet in 2018

Scott Zoldi, chief analytics officer at FICO, in his AI predictions for 2018, predicts the rise of “defensive AI” and manipulative chatbots. Blockchain will use AI to search through relationship data, Zoldi says, and defensive AI will be used to protect systems from malicious AI and machine learning. Adds Zoldi: Chatbots will get so good at understanding us they will learn how to manipulate us. Read more →



2018 INFORMS Conference on Business Analytics and Operations Research
April 15-17, 2018, Baltimore


CAP® Exam computer-based testing sites are available in 700 locations worldwide. Take the exam close to home and on your schedule:

For more information, go to