With new extensions, customers will be able to convert Excel optimization and simulation/risk analysis models to run in Tableau, “point and click” without any programming.
LAS VEGAS, NEVADA – October 10, 2017 – Frontline Systems, developer of the Solver in Microsoft Excel, today participated in a demonstration of a new “Extensions API” capability at the Tableau Conference. Leveraging the new API, Frontline’s software enables a customer using Excel and Tableau to easily create a sophisticated prescriptive analytics model, using business logic, optimization and/or Monte Carlo simulation – and convert it into a Tableau Dashboard Extension that’s immediately deployable to desktop and cloud business users, in seconds without any programming.
Any Tableau customer, regardless of analytics expertise, will be able to easily connect such a Dashboard Extension model to data in Tableau, via “point and click”. The extension then responds to the customer’s actions in Tableau and data refreshes by re-running the analytic model and displaying new prescriptive results – recommended actions or “decision data” – in visual form. This enables an organization’s people to go beyond analyzing “what happened”, and take action to “make it happen”.
The Tableau Extensions API, which Frontline has used on an early confidential disclosure basis, is broadly available now for software developers to try. The ability to convert Excel prescriptive analytics models into Dashboard Extensions will be included an early 2018 release of Frontline’s Analytic Solver desktop and cloud software.
“We’re empowering people to build prescriptive models in days, that once required management science experts and many months,” said Daniel Fylstra, president of Frontline Systems, “and deploy those models to consumers in ways that once required IT experts and many more months. It’s a key step to enable organizations to ‘operationalize’ analytics and realize business value.”
“These APIs give developers new ways to extend the functionality of Tableau to meet the needs of their organizations,” said Francois Ajenstat, Chief Product Officer at Tableau. “We’re excited to work with Frontline Systems to provide customers with easy-to-use prescriptive analytics.”
25 Years of Advanced Analytics Development Leveraged in Tableau
Although Tableau’s Extensions API and Frontline’s conversion of Excel models to Dashboard Extensions are both new, they fully leverage Frontline’s 25 years of developing, marketing and supporting software for prescriptive analytics, used in over 8,500 business organizations – mostly Fortune 1000 and Global 2000 companies – and by more than 500,000 business school students learning analytics methods over the last ten years.
For example, these Dashboard Extensions can use any of Frontline’s twelve Solver Engines for optimization, from linear programming and nonlinear optimization to genetic and evolutionary algorithms, simulation optimization, and stochastic programming. They can also use its high-performance Monte Carlo simulation engine with support for over 50 probability distributions, 50 statistics and risk measures, distribution and correlation fitting, and stratified sampling.
While not part of today’s demonstration, Frontline’s analytic software suite also includes powerful tools for data mining and machine learning, text mining, and prescriptive analytics. Examples include time series forecasting, linear and logistic regression, classification and regression trees, neural networks, ensembles and ‘random forests’, feature selection, principal components, and latent semantic analysis. Frontline intends to make these capabilities available in Tableau Dashboard Extensions as well.
RASON® Modeling and REST API Key to ‘Live’ Extension Models
Frontline Systems Inc. (www.solver.com) is the leader in analytics for spreadsheets and the web, 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.” Founded in 1987, Frontline is based in Incline Village, Nevada (775-831-0300).
Excel® is a registered trademark of Microsoft Corporation. Tableau® is a registered trademark of Tableau Software, Inc. Analytic Solver® and RASON® are registered trademarks of Frontline Systems, Inc.