- #Analytic solver platform for education full
- #Analytic solver platform for education software
- #Analytic solver platform for education free
- #Analytic solver platform for education windows
#Analytic solver platform for education windows
Models are solved using Windows Azure cloud-based servers maintained by Frontline Systems.
#Analytic solver platform for education free
Solves on Cloud-Based Office 365 or On-Premise Serversįor the past year, users of Microsoft's Excel Online in Office 365 have been able to use Frontline's Solver App, available free in the Office Store, to solve the same kinds of optimization models handled by the Solver in desktop Excel that Frontline developed for Microsoft. It can draw data from a huge range of sources, from enterprise on-premise databases to cloud-based public data stores on Windows Azure Data Marketplace.Įxcel users can easily summarize, "slice and dice" data from this in-memory database into Pivot Tables on the spreadsheet, but Analytic Solver Platform can draw representative samples of the data directly from Power Pivot and use this data to 'train' a data mining or predictive analytics model. The Power Query add-in, based on SQL Server Integration Services, provides an exceptionally powerful and easy to use ETL (Extract, Transform, and Load) capability for this in-memory database. With Power Pivot – an Excel add-in based on SQL Server Analysis Services' xVelocity database engine – Excel functions as a modern, in-memory, multidimensional database, easily capable of holding 100 million rows of data.
#Analytic solver platform for education software
Use with Microsoft Power BI Amplifies "Self-Service Business Intelligence"Īnalytic Solver Platform users can access and work with large amounts of data, from a variety of sources, far more easily than with other analytic software packages – thanks to Microsoft's recent investment in data access and "self-service business intelligence," which has made Excel much more than a spreadsheet.
This is a great convenience for users building finance and investment models, and other simulation models that include dynamic forecasts.
#Analytic solver platform for education full
New in this release is a full set of add-in "Psi Functions for Data Mining," which allow Excel users to apply a classification, prediction or time series forecasting model, 'trained' using XLMiner, to new data in an Excel spreadsheet – automatically re-applying the model on each spreadsheet recalculation.Īs a special case, time series (ARIMA, exponential smoothing or Holt-Winters) models can be used to automatically generate time series 'sample paths' on each trial of a Monte Carlo simulation. 'Scoring' of Data Mining and Forecasting Models in the Spreadsheet
The automatically-discovered clusters of trials are displayed visually in these charts. For example, one of the most popular and easiest to use data mining methods – k-means clustering – is available directly in the dialog which displays charts of simulation results.
Visual Data Exploration and Data Mining Applied to Monte Carlo SimulationĪnalytic Solver Platform is the first software to bring the power of data mining and visual data exploration to the analysis of Monte Carlo simulation trial data. Users can solve problems hundreds to thousands of times larger than the basic Excel Solver, at speeds anywhere from several times to hundreds of times faster, and they can solve completely new types of problems. Upward Compatible from Excel Solver, Works with Excel 2013įrontline's Solvers for Excel are upward compatible from the Solver included in Excel, which Frontline developed for Microsoft, and improved in Excel 2010 for Windows and Excel 2011 for Macintosh. "Users enjoy the ease of use of Excel and leverage their spreadsheet model-building experience, but they don't compromise at all on functionality or performance."Īnalytic Solver Platform incorporates many of the most powerful algorithms for optimization, simulation, and data mining available, and exploits new technology in CPUs, GPUs, and cloud servers to a greater degree than many "enterprise analytics" software packages costing far more. "Our message for Analytic Solver Platform continues to be 'no-compromise analytics in Excel'," said Daniel Fylstra, Frontline's President and CEO. The release also includes new versions of Risk Solver Platform, the leading tool for simulation / risk analysis, conventional and stochastic optimization in Excel Premium Solver Platform, Frontline's best-selling tool for conventional optimization and subset "professional entry-level" products Premium Solver Pro, Risk Solver Pro, and XLMiner Pro. The new release features XLMiner Platform, a completely re-engineered, very powerful tool for data mining and predictive analytics that Frontline says is a serious alternative to far more expensive data mining software from SAS, IBM and others.
0 kommentar(er)
