Optimization Training

——–Call Us Now 1800-212-2120

Course Agenda

About The Course

Optimization involves finding the best possible solution from multiple available solutions which is cost effective and high performance solution. Optimization is used in solving multiple business problems and one of the core concept in advance analytics.

Some of the areas where optimization is used widely are

  • Crew member allocation in various industries
  • Airlines industries to schedule their cargo flight routes
  • Supply chain optimization
  • Pricing and Revenue optimization
  • Manufacturing sector for production
  • Transportation and logistics

Optimization techniques not only provides the best optimal solution but also provides feedback on how changing the objective function coefficient will change the optimal solution. Every industry faces optimization problem and different optimization techniques are used to solve different problems. Different optimization problems include linear optimization problem, combinatorial optimization problem, constrained optimization problem, multi objective optimization problem, nonlinear optimization problem etc.

Are you looking to build an optimized routing system and solve a transportation problem; Do you want to identify what is the right volume of spare parts that need to be manufactured based on demand, supply, resource availability; Do you want to know what is the right way to allocated resources to a project without any redundancy or do you want to know a simple trick to solve Sudoku puzzle, then Optimization is the right subject that you need to learn.

It is important that we understand which optimization technique need to be used to solve a problem and also get a clear view on how to identify the objective function, decision variables and constraints to solve the problem correctly. We help you in learning different optimization techniques by using industry business scenarios and also teach widely used optimization tools like Solver, @Risk optimizer.

Data for a Data Scientist is what Oxygen is to Human Beings. This is also a profession where statistical adroit works on data – incepting from Data Colection to Data Cleansing to Data Mining to Statistical Analysis and right through Forecasting, Predictive modeling and finally Data Optimization. A Data Scientist does not provide a solution; they provide most optimized solution of the lot. Gartner predicted in 2012 that Data Scientist & Business Analytics jobs will increase to the tunes of Millions by the end of 2015. This is very evident with the rise in job opportunities in various job portals. As a Data Scientist or an aspirant you should not believe us. Go search for your own and confirm with facts and figures.

Topics You Will Learn…

PART 1 – Linear Continuous Optimization

  • Geometry & Sensitivity analysis
  • Introduction to Linear Programming (LP) and Management Science applications
  • Geometry of linear programs and graphical solution of LPs
  • A systematic explanation of how to formulate LPs and then implement them using spreadsheets
  • LP sensitivity analysis
  • Applications & Duality
  • LP duality and optimality conditions
  • Application in retail operations and multi-period planning applications
  • Network Optimisation
  • Network Flow models and specifically discuss the transportation problem, assignment problem, and the max-flow problem with their applications

PART 2 – Discrete Optimization

  • Binary variable modeling
  • The use of binary variables and modeling logical constraints
  • The fixed-charge problem
  • Other applications in finance and operations
  • Combinatorial optimization
  • Matching, spanning trees and others along with their application
  • Non-linear & Stochastic optimization
  • Basic mean-variance single period quadratic programming optimization model which was developed in the pioneering work of Markowit

Tools You Will Learn…

  • Solver
  • @Risk optimizer

Course Introduction Video

  • Introduction to optimization
    • Introduction to optimization

    • Watch Video

Watch our sample e-learning video recorded by industry’s best trainers with extensive subject knowledge expertise and who are considered to be the best trainers of the industry. All the participants will be provided access to our state-of-the-art Learning management system (LMS) at ExcelR.net, where one can access end to end course videos at your own pace & convenience sitting back at your home. Videos can be accessed from your desktop, mobile, tablet, etc. Switch back and forth as you choose


  • Data optimisation is used to provide the best solution given the business constraints. For e.g., customer wants to manufacture maximum number of shirts per day with highest quality possible. However, customer has limited budget to accomplish this. So given the Cost constraint, we need to provide the most optimal solution.
  • Data Optimization is used across all industries & sectors. Majorly it is applicable for Airlines to manage the routes of different flights, Logistics & Courier companies to deliver maximum products with least cost.
  • A lot of tools are used including XLMiner, Solver, R, SAS, STATA, MATLAB, Minitab, etc. We at ExcelR teach you Data Optimisation training on Excel Solver & XLMiner which are highly in demand.
  • The detailed course outline is provided on the website. Two core concepts included in the training program are Linear Continuous Optimization & Discrete Optimization.
  • Yes, data optimization is considered to be the most advanced level of analytics.



As I am a fresher, the training helped me a lot in understanding the industry norms and practices. Examples were very helpful.Good conduct over the subject.

Nikhil Mittal, MTS, NetApp



  Training was  Informative and interactive

  Tahmid Ikhlas, Team Leader , Empulse Global


Read More

Modes of Training

Why Excelr?

Our Clients