Course curriculum

  • 1

    Introduction, Descriptive and Predictive Analytics

  • 2

    Prescriptive Analytics, Low Uncertainty

    • 2.1-How to Build an Optimization Model

    • 2.2-Optimizing with Solver

    • 2.3-Network Optimization Example

    • 2.4-Review

    • 2.5-Solver on Mac

    • 2.6-Solver in Google Sheets
  • 3

    Predictive Analytics, Risk

    • 3.1-Comparing Decisions in Uncertain Settings

    • 3.2-Simulating Uncertain Outcomes in Excel

    • 3.3-Interpreting and Visualizing Simulation Output

    • 3.4-Review
  • 4

    Prescriptive Analytics, High Uncertainty

    • 4.1-Decision Trees

    • 4.2-Using Simulation with Decision Trees

    • 4.3-Using Optimization Together with Simulation

    • 4.4-Wrap-up

    • 4.5-Review

    • 4.6-Advanced Session on Optimization
  • 5

    Resources for reading and Excel sheets for Practicing

    • Resources and Data files for Practice