Analytic Solver Data Mining - gives you easy to use, comprehensive data mining, text mining and predictive analytics in Excel. You can sample data from SQL databases, Power Pivot and Apache Spark, explore your data visually, clean and transform data, and create, evaluate and apply a full range of time series forecasting and data mining models -- from multiple regression and logistic regression to classification and regression trees, neural networks, and association rules. Its speed will amaze you!

Capabilities:

• Forecasting, data mining, text mining in Excel

• Uncover new revenue, predict churn or fraud

• Explore, partition, transform data, extract features

• Use regression, trees, neural nets, ensembles, PMML

• Includes both desktop Microsoft Excel and cloud AnalyticSolver.com versions

Feature:

Advanced Data Mining and Text Mining, the Ease of Excel, and Competitive Pricing

Analytic Solver Data Mining - "XLMiner's Big Brother" - Includes Everything You Need to Apply Predictive Analytics to Your Data

Use data from many sources

Sample data from spreadsheets, text files and SQL databases, including Microsoft's PowerPivot in-memory database handling 100 million rows or more.

Visualize your data

Use visualization aids from simple bar, line and histogram charts to multiple linked charts, instant axis changes, colors, panels, zooming, brushing and more.

Analyze text for insights

Automatically transform free-form text into structured data, identifying most frequent terms and extracting key concepts with latent semantic indexing [XLMiner Platform].

Clean & transform data

Clean and transform your data with a comprehensive set of data handling utilities including categorizing data and handling missing values.

Identify key features

Use feature selection to automatically identify columns or variables with the greatest explanatory power for your desired classification or prediction task.

Reduce and cluster data

Use principal components to reduce columns, and k-means clustering or hierarchical clustering to group data by rows.

Partition for training

Easily partition your data into training, validation, and test datasets, with no limits on dataset size -- even "on the fly" as you build a predictive model.

Forecast time series

Apply the most popular exponential smoothing and Box-Jenkins (ARIMA) methods with seasonality to forecast time series, such as sales and inventory, from historical data.

Prediction methods

Use powerful multiple linear regression with variable selection, and data mining methods like k-nearest neighbors, and ensembles of regression trees and neural networks.

Classification methods

Use classical discriminant analysis and logistic regression, and data mining methods like k-nearest neighbors, naive Bayes, and ensembles of classification trees and neural networks.

Affinity analysis

Use market basket analyses and recommender systems with association rules.

Easy to use interface

Use a Ribbon interface, with Wizard-style dialogs to guide you through model and option selections.

Example datasets

Over 30 example datasets give you practice with a range of prediction, classification, time series forecasting, and affinity analysis problems.

Help and support

Access extensive online Help, or review our 400+ page XLMiner User Guide to get your questions answered.

Easy upgrades

Upgrade to Analytic Solver Platform for the most powerful combination of data mining and forecasting with simulation/risk analysis and optimization available at any price.

Quick Navigation;