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.