Tool enables business analysts to create analytics-powered decision services, “point and click” without coding, using optimization, Monte Carlo simulation, data mining and machine learning, rules and decision tables; works in Excel for the Web, Windows and Macintosh and with Microsoft Teams.

INCLINE VILLAGE, NV – August 23, 2021 – Frontline Systems has released a major new 2021.5 version of Analytic Solver®, its leading toolset for Excel for the Web, Windows and Macintosh, that makes risk analysis, Monte Carlo simulation, data mining and machine learning easier for business analysts, and further simplifies the task of deploying analytic models in cloud-based applications.

Analytic Solver works in Microsoft Excel to enable business analysts who aren’t data scientists to build and solve analytic models themselves.  It is upward compatible from the Solver in Excel, which Frontline originally developed for Microsoft, and is able to solve virtually any type or size of optimization model.

Decision Intelligence Results in Months, not Years

Analytic Solver works with RASON, Frontline’s Azure-hosted platform, to empower users to ‘publish’ and manage analytic models as RESTful decision services, easily usable in Teams, Power BI, Power Apps, Power Automate, or any application that can consume JSON or OData.  The combination is a complete “decision intelligence suite” that supports business rules, forecasting, machine learning, optimization and simulation methods, from small models to large, multi-stage analytics workflows.

“With Analytic Solver, business analysts have unique risk analysis and machine learning capabilities - and they can ‘move beyond Excel’ to gain cloud-based data access, model management and governance, without losing the advantages of Excel”, said Daniel Fylstra, Frontline’s President and CEO.

Automate Data Mining with Find Best Model

Using Analytic Solver’s data mining and machine learning tools, users can “train” or fit data to a wide range of statistical and machine learning models: Classification and regression trees, neural networks, linear and logistic regression, discriminant analysis, naïve Bayes, k-nearest neighbors and more.  But the task of choosing and comparing these models, and selecting parameters for each one was up to the user.

With new Find Best Model options in V2021.5, this work is automated.  Analytic Solver will test and evaluate multiple types of machine learning models and their parameters, validate and compare them according to user-chosen criteria, and deliver the model that best fits the data.

Better Simulation Models with Metalog Distributions and Fitting

Analytic Solver and RASON support over 60 “classical” probability distributions for Monte Carlo simulation.  Since mid-2017, they’ve also supported the increasingly popular Metalog family of distributions, created by Dr. Tom Keelin: these tools can closely approximate virtually any classical continuous distribution, and often they can better fit historical data than classical distributions.  Analytic Solver V2021.5 brings Metalog distributions to the fore, with a powerful new facility to automatically fit user data to the full range of possible (bounded and unbounded, multi-term) Metalog distributions.  It’s never been easier to get an accurate probability distribution that fits a real-world phenomenon.

Share Machine Learning and Probability Models via RASON

In recent years, RASON has offered increasingly powerful facilities to deploy models to the cloud and share them with other users – culminating in Frontline Solvers V2020.5, which enabled deployment, sharing, versioning and management of Excel models as well as native RASON models, plus support for multi-stage decision flows, encompassing and going beyond traditional data science workflows.

Analytic Solver V2021.5 goes further:  Users can now deploy and share data mining and machine learning models, trained in Analytic Solver or RASON, to the Azure cloud, and use them directly for classification and prediction (without needing auxiliary “code” in R or Python, RASON or Excel).

Users can also deploy and share probability models, following the open Probability Management 3.0 standard.  With these tools, a large organization with multiple risk analysis and modeling projects can ensure they are using consistent assumptions about uncertain/risky variables, down to individual trials, in simulation or decision models – enabling results of different projects to be meaningfully compared.

Deployment Wizard for Teams, Power BI, Tableau and RASON

With Analytic Solver, business analysts can “deploy to the cloud,” and even monitor runs of deployed models, without leaving Excel.  A Deployment Wizard guides users through “point and click” options that make optimization, simulation and machine learning models available to run live in popular tools like Microsoft Teams, Power BI and Tableau.  No code is required – but developers can step in and modify JavaScript code to easily extend these cloud apps at any stage.

Even a Monte Carlo simulation model, built with a competitor product that works only in desktop Excel, can be easily converted to Analytic Solver (in Excel desktop or cloud), then auto-translated to RASON, or “used as-is” as an Excel workbook on the RASON cloud server, managed as a RESTful cloud service.

More Optimization, Simulation and Data Science Enhancements

Analytic Solver users constantly receive major functional and performance enhancements for analytic modeling.  Besides new features in this release, in the past year users have received new versions of four large-scale Solver Engines for optimization, 15 new PSI Simulation functions for easier use of time series simulation methods, 9 new PSI Optimization functions for live sensitivity results on worksheets, and multi-stage “data science flows” with a drag-and-drop editor in Analytic Solver, plus deployment to the RASON cloud service.

Free Trials, Learning and Coaching Resources

Business analysts and developers can sign up for free trial accounts to evaluate Analytic Solver at https://www.solver.com, and RASON at https://rason.com. They can use tools to create and solve models in Excel and RASON, exercise the REST API, try out dozens of example models illustrating use of decision tables, predictive models and machine learning, optimization and simulation, and download the Analytic Solver and RASON User Guides and Reference Guides in PDF form.  For more information please contact sales@solver.com.

Frontline Systems Inc. (https://www.solver.com) is the alternative to analytics complexity, helping business analysts and managers gain insights and make better decisions for an uncertain future, without the cost, delays and risk of ‘big vendor’ tools.  Its products integrate forecasting and data mining for “predictive analytics,” Monte Carlo simulation for risk analysis, conventional and stochastic optimization for “prescriptive analytics,” and business rules and Excel calculations to make the best business decisions.  Founded in 1987, Frontline is based in Incline Village, Nevada (775-831-0300).

Microsoft Excel, Office 365, Teams, Power BI, Power Apps, and Power Automate are trademarks of Microsoft Corp. RASON® and Analytic Solver® are registered trademarks of Frontline Systems Inc.