Frontline Systems is shipping XLMiner Platform, a new product that is available by itself, and integrated into a new release of Frontline's flagship product, Analytic Solver Platform. In doing so, Frontline has brought an add-in for Excel, used for years by MBA students and analysts in industry to learn about data mining and predictive analytics, to an "industrial strength" level that Frontline says is a serious alternative to far more expensive data mining tools from SAS,
Ten Years of Use in Teaching and Learning Analytics
XLMiner was originally developed more than ten years ago by statistics experts, to bring data mining to a broad audience. The software inspired a very popular textbook Data Mining for Business Intelligence, by Professor
Analytic Solver Platform for Education, a special version with problem size limits suitable for teaching, has become the most popular software used to teach analytics in MBA education. Frontline estimates that between one-third and one-half of all enrolled MBA students used this software in 2013 alone.
Completely Rewritten Algorithms
Given XLMiner's growth, Frontline decided in early 2013 to invest in a major technology upgrade of the underlying software. Over the last 18 months, Frontline's engineers have redesigned all of the algorithms and rewritten hundreds of thousands of lines of code to produce XLMiner Platform, and a new subset product XLMiner Pro.
XLMiner's data mining algorithms, written in C++, are based on studies of the latest published papers, doctoral theses and conference proceedings in data mining and machine learning, and take maximum advantage of multi-core processors and modern vector instruction sets. The result is a dramatic improvement in performance (often 100 times faster or more) and capacity to handle large, complex datasets.
Frontline's engineers have benchmarked performance of the new XLMiner against the best-known statistical software packages, to ensure that XLMiner could handle datasets just as large, with similar or better performance. For example, on a dataset measuring Twitter "tweet popularity" with 580,000 rows and 77 columns, an XLMiner multiple linear regression with variable selection, ANOVA and diagnostics took just 3.4 seconds for computation and 11 seconds to create Excel worksheet reports, on a Dell XPS 8700 PC.
XLMiner Use with Excel 2013, Power Pivot and Power Query
But can an Excel add-in really be a serious alternative to far more expensive data mining tools from SAS,
Frontline is leveraging
Excel users can easily summarize and "slice and dice" data from this in-memory database into Pivot Tables on the spreadsheet, but XLMiner can draw representative samples of the data directly from Power Pivot. As taught for many years by SAS with its SEMMA methodology and SPSS with its CRISP methodology, a data mining model can, and usually should be "trained" by using a representative sample of a larger dataset, then "validated" against a different sample from the larger dataset. This methodology is built-in and easy to use in XLMiner.
Predictive Analytics Plus Powerful Prescriptive Analytics
The world of predictive analytics is beginning to move beyond classification and prediction, towards what industry analysts are calling "advanced analytics" -- making better decisions based on data and models. This is where Frontline's 20 years of development of advanced analytics software, using the latest methods for mathematical optimization, Monte Carlo simulation and risk analysis, and stochastic optimization, pays off heavily for Excel users.
XLMiner is deeply integrated into Analytic Solver Platform, which combines all of Frontline's industrial-strength tools for advanced analytics. For example, users can quickly apply k-means clustering to Monte Carlo simulation trial data, or use a time series forecasting model created in XLMiner to automatically generate forecast 'sample paths' in Monte Carlo simulation.
And this software handles the largest and most challenging decision problems. Analytic Solver Platform and its predecessors have featured multi-core parallel algorithms for optimization and simulation since 2009, robust optimization since 2007, and algebraic model analysis of Excel formulas since 2005 – capabilities that some vendors are just now beginning to offer in 2014. Frontline believes that with Analytic Solver Platform, users can build, train, simulate or solve virtually any data mining, simulation or optimization model that they could create using 'enterprise' software tools costing 10 to 20 times more, and do it faster and more easily in Excel.
Read the full story at http://www.prweb.com/releases/xlminer-data-mining-excel/fast-predictive-analytics/prweb12014582.htm
Most Popular Stories
- New Hershey's Logo Revealed
- Americans Still Pessimistic Despite Economic Growth
- Obama's Delay on Immigration Creates Uncertainty
- Startups Offer Smartphone Banking Apps
- Illinois Issues Fracking Rules
- Mexico's Pemex Forecasts 6.7% Drop in 2014 Crude Production
- 'Longmire' Cancelled, Looks for New Network
- Hip-Hop Takes Up Ferguson Cause
- Clippers Deal Started With 2 Numbers
- Echeveste Steps Down, Perez Steps Up at VPE