Capabilities: 
  • Learn predictive and prescriptive analytics
  • Leverage your Excel modeling skills
  • Learn to build effective Excel Solver models
  • See how to reduce costs through Optimization
  • Model and control risks through Simulation
  • Easily use machine learning for Data Mining
Get the 15-Day FREE Trial

How it works

1

Start with Analytic Solver Basic

Use a full featured version of Analytic Solver software (with model/data size limits, enough for all examples) -- FREE for 15 days, just $100 for 140 days.
2

Add Just the Courses You Want

Choose a course on Optimization, Simulation, or Data Mining -- Analytic Solver Basic does it all. Or get our best deal: All three 101-level courses for $495!

Learn Predictive and Prescriptive Analytics from the Experts

For business analysts, learning to build effective predictive and prescriptive analytics models can be a bit intimidating.  You're likely comfortable with numbers and Excel formulas, but you might not have used methods from probability, statistics, and linear algebra since college courses long ago.  You're in the right place to learn -- we specialize in teaching people like you!

Click to view and register for a free webinar: New live webinars every other week.

Purchase an online course at Solver.Academy. You'll get access to the course for the lifetime of your software license.

  • OPT101: Optimization Using Analytic Solver (6 weeks)
  • SIM101: Simulation and Risk Analysis Using Analytic Solver (6 weeks)
  • DM101: Data Mining Using Analytic Solver - Part I (6 weeks)
  • DM201: Data Mining Using Analytic Solver - Part II (6 weeks)

Any paid software license, from Analytic Solver Basic to Analytic Solver Comprehensive, will work for each class -- You can even use our special 140-day, $100 license for Analytic Solver Basic!

Course objective

Gain a comprehensive overview of optimization and its applications using Frontline Solvers software.  The information provided in this course will provide the necessary foundations if you are planning to use optimization to address business problems using Solver software.

Learning outcomes

  • You will be able to model an optimization problem.
  • You will be able to evaluate the results and use sensitivity analysis.
  • You will be able to use advanced features such as parametric optimization to study various scenarios.
  • You will be able to explain the structure of your model.
  • You will be able to use optimization in uncertain situations.

Description of assignments

The grade will be determined out of 100 total points. 10 quizzes will be given throughout the course. All exams are required (total possible points = 53). You can retake each quiz up to 2 times. A midterm exam consisting of 2 parts will be given (total possible points = 20). A comprehensive final exam will also be given which consists of 3 parts. All exams will be comprised of multiple choice and true/false questions. You can take midterm and final exams only ONE time.

Grading Criteria

The final grade will be based on scores obtained from all quizzes, the midterm and the final exam. If total points earned is >=85, your grade will be an A. Frontline Systems offers a certification to students with grade A.

Frontline Systems Certification Criteria

In order to qualify for a Frontline Systems certificate, you must earn an A in the course by scoring 85 points or higher.

Course objective

Gain a comprehensive overview of simulation and its applications using Frontline Solvers software.  The information provided in this course will provide the necessary foundations if you are planning to use optimization to address business problems using Solver software.

Learning outcomes

  • You will be able to model a simulation problem.
  • You will be able to evaluate the results and use sensitivity analysis.
  • You will be able to use advanced features such as parametric simulation to study various scenarios.
  • You will be able to use decision trees and their sensitivity analyses.
  • You will be able to use optimization in uncertain situations using simulation optimization, chance constraints and recourse decisions.

Description of assignments

The grade will be determined out of 104 total points. 9 quizzes will be given throughout the course. All exams are required (total possible points = 44). You can retake each quiz up to 2 times. A midterm exam consisting of 1 part will be given (total possible points = 20). A comprehensive final exam will also be given which consists of 2 parts ((total possible points = 40). All exams will be comprised of multiple choice and true/false questions. In the Final exam you will need to build a model to answer the questions. You will only have ONE chance to complete the midterm and final exams.

Grading Criteria

The final grade will be based on scores obtained from all quizzes, the midterm and the final exam. If total points earned is >=85, your grade will be an A. Frontline Systems offers a certification to students with grade A.

Frontline Systems Certification Criteria

In order to qualify for a Frontline Systems certificate, you must earn an A in the course by scoring 85 points or higher.

Course objective

Gain a comprehensive overview of data mining and its applications using Frontline Solver's Analytic Solver Data Mining software.  The information provided in this course will provide the necessary foundations if you are planning to use data mining to address business problems using Solver software.

Learning outcomes

  • You will learn learn the steps required in a typical data mining process.
  • You will learn how to explore and prepare their data for a typical data mining process.
  • You will learn to properly sample your data and perform a clustering analysis.
  • You will learn how to use supervised methods to create a classification model.
  • You will learn how to use supervised methods to create a regression model.
  • You will learn to use ensemble methods to create both a classification and regression model.

Description of assignments

The grade will be determined out of 100 total points. Four quizzes and two exams will be given throughout the course. All quizzes and exams are required. You can retake each quiz up to 2 times. There is a midterm exam and a comprehensive final exam. All exams and quizzes are comprised of multiple choice and true/false questions. You can take midterm and final exams only ONE time.

Grading Criteria

The final grade will be based on scores obtained from all quizzes, the midterm and the final exam. If total points earned is >=85, your grade will be an A. Frontline Systems offers a certification to students with grade A.

Frontline Systems Certification Criteria

In order to qualify for a Frontline Systems certificate, you must earn an A in the course by scoring 85 points or higher.

Course objective

Gain a a deeper understanding of data mining and its applications using Frontline Solver's Analytic Solver Data Mining software.  The information provided in this course will provide the necessary foundations if you are planning to use data mining to address business problems using Solver software.

Learning outcomes

  • You will learn how to create a model using Association Rules analysis.
  • You will learn how to create classification models using neural networks, ensemble methods and discriminant analysis.
  • You will learn how to create a regression model using neural networks and ensemble methods.
  • You will learn to make forecasts using time series (ARIMA and exponential smoothing) techniques.
  • You will learn to use latent semantic indexing to create a text mining model.
  • You will learn learn how to call XLMiner SDK through C#, Java, and Python to complete data mining tasks.

Description of assignments

The grade will be determined out of 100 total points. Four quizzes and two exams will be given throughout the course. All quizzes and exams are required. You can retake each quiz up to 2 times. There is a midterm exam and a comprehensive final exam. All exams and quizzes are comprised of multiple choice and true/false questions. You can take midterm and final exams only ONE time.

Grading Criteria

The final grade will be based on scores obtained from all quizzes, the midterm and the final exam. If total points earned is >=85, your grade will be an A. Frontline Systems offers a certification to students with grade A.

Frontline Systems Certification Criteria

In order to qualify for a Frontline Systems certificate, you must earn an A in the course by scoring 85 points or higher.

Download Frontline Solvers for Excel
(All fields are required)

At least 7 printable characters that you can remember.

By submitting this form, you consent to certain follow-up communications as described in our Privacy Policy. Your information will not be shared with third parties.