With the Analytic Solver® Data Science add-in, created by Frontline Systems, developers of Solver in Microsoft Excel, you can create and train time series forecasting, data mining and text mining models in your Excel workbook, using a wide array of statistical and machine learning methods. This add-in can be used alone, but it’s designed to work with Frontline’s Analytic Solver add-in, offering powerful Monte Carlo simulation and conventional and stochastic optimization. One paid license enables you to use all features of both add-ins – so be sure to get them both! You can use them in Excel for Windows, Excel for Macintosh, and Excel Online through a browser.

You can use Analytic Solver to detect seasonal patterns in demand for better forecasts, predict which subscription customers are likely to "churn", choose whether to approve mortgage applications, check transactions for possible fraud, display products of greatest interest to online shoppers, trigger equipment maintenance ahead of predicted failures, or measure positive or negative sentiment in social media text – and that’s only the beginning. Please note that Analytic Solver Data Science is our “full-power version” designed for large-scale industrial problems – you’ll need either a free trial license or a paid license from Frontline Systems in order to use it. For a free option, see our XLMiner Analysis Toolpak add-in.

You can use data in Excel workbooks, PowerPivot datasets, SQL databases, and “big datasets” using our built-in connection to Apache Spark clusters. Explore data visually, use feature selection, clustering and principal components, transform data with binning, re-scaling and missing value handling, partition into training and validation sets, then apply ARIMA and exponential smoothing, linear and logistic regression, k-nearest neighbors, naïve Bayes, classification and regression trees (CaRT), neural networks, and ensembles of multiple algorithms. View multiple validation measures and display lift charts, ROC curves, CaRT trees, Scree plots and more. Use your models to “score” new data in Excel workbooks or SQL databases, or export your models in industry-standard PMML (Predictive Modeling Markup Language).

When your company wants to use your successful model outside Excel, Analytic Solver makes it easy: Use “Create App” on the Analytic Solver tab to deploy your model to the Azure cloud as a RESTful decision service with RASON® (see https://rason.com). Use your model in Tableau and Power BI dashboards, in Power Apps, Power Automate and Dynamics 365, or in your own web or mobile apps that consume JSON or OData results. Or create a desktop or server app that runs your model with Solver SDK®. Everything you need to get started is included with Analytic Solver.

You’ll have access to a wide range of support aids, including step-by-step dialogs and a graphical workflow editor, more than 35 example datasets, a Help Center, over 700 pages in the User Guide and Reference Guide, a range of video tutorials, built-in support Live Chat, and even paid online courses through Solver.Academy. Plan to take some time to master this powerful add-in, which builds on over 25 years of successful use of Frontline Solver products by hundreds of thousands of business analysts, in over 9,000 organizations across the world. Learn more at www.solver.com.

Analytic Solver Data Science

by Frontline Systems Inc.