Share with your friends










Submit

Analytics Magazine

Frontline Systems releases Analytic Solver V2017-R2

Frontline Systems is shipping a new product line release for desktop and cloud, Analytic Solver 2017-R2 for Excel and enhancements to AnalyticSolver.com, its SaaS equivalent. Building on the February V2017 release that unified and simplified Frontline’s product and introduced Analytic Solver Basic, the V2017-R2 release features major performance improvements in optimization, new distribution and correlation functionality in simulation/risk analysis, and a new, radically simple way to convert Excel analytic models into Power BI custom visuals, for distribution to “BI consumers” throughout an organization.

“We’re not only making advanced analytics power tools and learning aids accessible to every business analyst,” says Daniel Fylstra, Frontline’s president and CEO. “We’re making the fruits of their efforts — working analytic models and their insights — readily accessible to everyone who needs them.”

Microsoft’s popular Power BI business intelligence and data visualization platform now supports “custom visuals,” originally conceived as a way to broaden the range of chart types available in Power BI dashboards. Independent developers, using an array of special Web development tools such as TypeScript (a “strongly typed JavaScript” programming language) and the Node.js framework, can create custom visuals to be used in Power BI. But for Excel-literate business analysts, creating their own Power BI custom visuals has been far out of reach.

All that has changed with Analytic Solver V2017-R2. Working in Excel with this tool, a business analyst user can turn his or her Excel-based optimization or simulation model into a Power BI Custom Visual, with just a few mouse clicks. The result isn’t just a chart – it’s a fully-functional optimization or simulation model, ready to accept Power BI data, run on demand on the web, and display visual results in Power BI. Users simply need to drag and drop appropriate Power BI datasets into the “well” of inputs to match model parameters.

The secret behind the remarkable capability to turn desktop Excel models into web-based Power BI custom visuals, without any programming, is Analytic Solver’s ability to translate an Excel model into RASON (RESTful Analytic Solver Object Notation), Frontline’s powerful modeling language embedded in JSON. Analytic Solver then “wraps” Power BI custom visual code around the RASON model. The result is a radically simple way to move from traditional Excel to cloud deployment to business intelligence “consumers” — not available anywhere else.

For large optimization models with tens to hundreds of thousands of decision variables, the V2017-R2 release greatly improves the speed of “problem setup,” where a “Jacobian matrix” is built from many thousands of Excel formulas. Though individual results vary, Frontline has seen speed gains of 10 to 50 times on real customer models. These improvements benefit all of Frontline’s 12 different “Solver Engines” that handle problems ranging from linear programming and nonlinear optimization, to “arbitrary” models and stochastic optimization.

Also part of the V2017-R2 release are new, higher performance Solver Engines for optimization based on latest releases of the Gurobi Solver, FICO’s Xpress Solver and Artelys Knitro Solver, as well as Frontline’s greatly-enhanced, high-performance Evolutionary Solver, focused on challenging non-smooth, non-convex models with integer variables. Free trials of the optional large-scale Solver Engines are “built in” and available to users at any time.

The V2017-R2 release supports a new family of probability distributions, called the metalog distributions, even more general than the Pearson distributions — members of this family can be chosen based directly on historical data (even just a few observations), without a distribution fitting process. The metalog distributions allow empirical data to “speak for itself” in simulation models.

The new V2017-R2 release is available now at Frontline’s website Solver.com and at its cloud version portal AnalyticSolver.com.

 

Related Posts

  • 74
    Frontline Systems is shipping a new product line release for desktop and cloud, Version 2017 of its Solvers for Excel and AnalyticSolver.com, its SaaS equivalent. The new release unifies and simplifies Frontline’s products, makes learning predictive and prescriptive analytics accessible to everyone at very low cost, is easier to upgrade…
    Tags: solver, frontline, analytic, release, data, software, models, analytics, optimization, excel
  • 70
    Frontline Systems, developer of the Solver in Microsoft Excel, has launched Solver.Academy, its online learning platform for predictive and prescriptive analytics. Frontline also announced that it has surpassed 500,000 users of its cloud-based advanced analytics tools, aimed at spreadsheet-literate business analysts who aren’t expert data scientists.
    Tags: analytics, frontline, solver, business, data, excel, software
  • 63
    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, software, analytics, frontline
  • 63
    Frontline Systems, developer of the Solver in desktop Microsoft Excel 26 years ago, announced that it has surpassed 200,000 users of its cloud-based advanced analytics tools for optimization, simulation/risk analysis, forecasting, data mining and text mining – based on usage data from Microsoft, Google and its own SaaS platforms.
    Tags: analytics, frontline, solver, excel, data, cloud, optimization
  • 59
    Gurobi Optimization recently introduced Gurobi Optimizer v7.0, with higher performance and powerful new modeling capabilities.
    Tags: optimization, model, software, analytics


Headlines

Using machine learning and optimization to improve refugee integration

Andrew C. Trapp, a professor at the Foisie Business School at Worcester Polytechnic Institute (WPI), received a $320,000 National Science Foundation (NSF) grant to develop a computational tool to help humanitarian aid organizations significantly improve refugees’ chances of successfully resettling and integrating into a new country. Built upon ongoing work with an international team of computer scientists and economists, the tool integrates machine learning and optimization algorithms, along with complex computation of data, to match refugees to communities where they will find appropriate resources, including employment opportunities. Read more →

Gartner releases Healthcare Supply Chain Top 25 rankings

Gartner, Inc. has released its 10th annual Healthcare Supply Chain Top 25 ranking. The rankings recognize organizations across the healthcare value chain that demonstrate leadership in improving human life at sustainable costs. “Healthcare supply chains today face a multitude of challenges: increasing cost pressures and patient expectations, as well as the need to keep up with rapid technology advancement, to name just a few,” says Stephen Meyer, senior director at Gartner. Read more →

Meet CIMON, the first AI-powered astronaut assistant

CIMON, the world’s first artificial intelligence-enabled astronaut assistant, made its debut aboard the International Space Station. The ISS’s newest crew member, developed and built in Germany, was called into action on Nov. 15 with the command, “Wake up, CIMON!,” by German ESA astronaut Alexander Gerst, who has been living and working on the ISS since June 8. Read more →

UPCOMING ANALYTICS EVENTS

INFORMS-SPONSORED EVENTS

Winter Simulation Conference
Dec. 9-12, 2018, Gothenburg, Sweden

INFORMS Computing Society Conference
Jan. 6-8, 2019; Knoxville, Tenn.

INFORMS Conference on Business Analytics & Operations Research
April 14-16, 2019; Austin, Texas

INFORMS International Conference
June 9-12, 2019; Cancun, Mexico

INFORMS Marketing Science Conference
June 20-22; Rome, Italy

INFORMS Applied Probability Conference
July 2-4, 2019; Brisbane, Australia

INFORMS Healthcare Conference
July 27-29, 2019; Boston, Mass.

2019 INFORMS Annual Meeting
Oct. 20-23, 2019; Seattle, Wash.

Winter Simulation Conference
Dec. 8-11, 2019: National Harbor, Md.

OTHER EVENTS

Applied AI & Machine Learning | Comprehensive
Dec. 3, 2018 (live online)


Advancing the Analytics-Driven Organization
Jan. 28–31, 2019, 1 p.m.– 5 p.m. (live online)

CAP® EXAM SCHEDULE

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 
https://www.certifiedanalytics.org.