Advanced Analytics Tools for Excel and the Cloud

  • Data Mining and Machine Learning
  • Optimization - Excel Solver Upgrade
  • Monte Carlo Simulation/Risk Analysis
  • Stochastic and Robust Optimization
  • Comprehensive Training & Support
Used by:
  • Companies
  • Cloud Users
  • MBA Students
  • Recommend

The Business Analyst's Secret Weapon:

Advanced analytics using skills you already have

  • INTEGRATED ANALYTIC SOLVER

    Everything You Need for Insights and Better Decisions

    Start Easily with One Tool, Upgrade to the Integrated Suite

    Get everything you’d find in high-end enterprise analytics software, but with far lower cost, risk, and learning curve.

    Leverage your Excel expertise in both desktop and cloud versions - your license and your model work in both.

    All data mining, optimization and simulation features always available - upgrade model size and pay only for what you need.

  • OPTIMIZATION AND EXCEL SOLVER

    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.

  • MONTE CARLO SIMULATION

    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.

  • DATA MINING AND FORECASTING

    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.

  • DEVELOPER APIs AND WEB SERVICES

    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.

Start Your Journey from Business Analyst Pro to Analytics Ninja:

Tutorials - Videos - Webinars - Online Courses for You and Your Team

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

Hear what some of our customers are saying

Ready to get started?

Use a full featured version of Analytic Solver software (with model/data size limits, enough for all examples) for 15 days, free of charge.