- INTEGRATED ANALYTIC
SOLVER - OPTIMIZATION AND
EXCEL SOLVER - MONTE CARLO
SIMULATION - DATA MINING AND
FORECASTING - DEVELOPER APIs AND
WEB SERVICES
Everything You Need for Insights and Better Decisions
Start Easily with One Tool, Upgrade to the Integrated Suite
Learn just what you need today, knowing you can upgrade and get the benefits of deep integration in Analytic Solver Pro and Platform.
Choose our Pro level products for problems you expect to solve in Excel. Choose our Platform products for greater power, matching far more expensive enterprise solutions.
Easily share your solution: Move your model from desktop Excel to Office 365 and Power BI, Google Sheets, or a custom application running on-premise or in the cloud.
Find the Best Way to Allocate Scarce Resources
Upgrade the Excel Solver with the World's Most Powerful Optimizers
Premium Solver: 100% upward compatible from the Solver in Excel - just open your workbook and solve, then expand to handle thousands of variables and constraints.
Guided Mode automatically diagnoses your model, finds (and even fixes) modeling problems, and helps you select the best optimization method and Solver Engine.
Solve every type and size of problem, using methods from linear/mixed-integer programming, nonlinear and global optimization, genetic algorithms and local search.
Understand, Quantify, and Control Your Risks
Explore Thousands of Scenarios in Seconds
Risk Solver: Start with any what-if model - easily add uncertain inputs with our Distribution Wizard, or use your historical data for fitting or resampling.
Get instant charts and statistics that show the full range of outcomes, and what factors really matter for the results you care most about.
Find better choices for the factors you can control, using parameterized simulations, simulation optimization, and industry-leading stochastic optimization.
Find Hidden Relationships, Make Better Predictions
Point-and-Click Wizards Make You a Data Mining Whiz
XLMiner: Sample data from virtually any database, from Oracle or SQL Server to Excel's own PowerPivot in-memory database handling 100 million rows or more.
Visualize your data with multiple linked charts, data-driven colors, panels, zooming, brushing and more. Easily transform, cluster, and identify or extract features from data.
Point and click to use text mining, time series forecasting, regression, ensembles of classification and regression trees or neural networks, affinity analysis and more.
Easily Add Analytics to Your Applications
For Desktop, Server, Mobile and Cloud-based Apps
Solver SDK: Easily use Analytics in your C++, C#, VB, Java, PHP and JavaScript apps, defining your model in code with an object-oriented API that's also a Web Services API.
Easier: Load, update and solve Excel workbook models from your application, running on-premise or in the cloud, on Azure or AWS.
Easiest of all: Define your model in our high-level RASON® modeling language, and solve on your desktop or server, or via our REST API in your web or mobile app.
Your Next Step Towards Analytics Results
Free Software Trial White Papers Example Models Tutorials and Videos
Tutorials, Videos and Webinars
Optimization Tutorial
Solvers, or optimizers, are software tools that help users determine the best way to allocate scarce resources. Examples include allocating money to investments, or locating new warehouse facilities, or scheduling hospital operating rooms. In each case, multiple decisions need to be made in the best possible way while simultaneously satisfying a number of requirements (or constraints). The "best" or optimal solution might mean maximizing profits, minimizing costs, or achieving the best possible quality. Here are some representative examples of optimization problems:
- Finance/Investment: Cash management, capital budgeting, portfolio optimization.
- Manufacturing: Job shop scheduling, blending, cutting stock problems.
- Distribution and Networks: Routing, truck loading, fleet scheduling.
Simulation/Risk Analysis Tutorial
Quantitative risk analysis is the practice of creating a mathematical model of a project or process that explicitly includes uncertain parameters that we cannot control, and also decision variables that we can control. Monte Carlo simulation explores thousands of possible scenarios, and calculates the impact of the uncertain parameters and the decisions we make on outcomes that we care about -- such as profit and loss, investment returns, environmental results and more. Industries where simulation and risk analysis are heavily used include:
- Pharmaceuticals: Modeling R&D and clinical trials
- Oil & Gas: Modeling drilling projects
- Insurance: Modeling frequency and types of claims
Data Mining Tutorial
Data mining software tools help users find patterns and hidden relationships in data, that can be used to predict behavior and make better business decisions. A machine learning algorithm "trained" on past observations can be used to predict the likelihood of future outcomes such as customer "churn'" or classify new transactions into categories such as "legitimate" or "suspicious". Other methods can be used uncover "clusters" of similar observations, or find associations among different items. Common applications include:
- Financial Services: Fraud detection, good vs. bad credit risks
- Direct Marketing: Segmentation to improve response rates
- Electoral Politics: Identifying "most persuadable" voters





