Advanced Decision Analytics

UNSW graphic yellow



5 days

Delivery mode

In-Person, On-Campus


UNSW Canberra City Campus

Standard price


Accelerate your career, learn new skills, and expand your knowledge.

First in Australia for research excellence and impact.

Top 50 in the world. 2020 QS World University Rankings.


This course will be run as a live simulcast online course presented through Microsoft Teams.  You will be required to use Excel 2016 or later during this course.

Decision analytics refers to a systematic, quantitative, iterative and interactive approach to addressing and evaluating important decision choices confronted by organisations in the private and public sector. This short course on Advanced to Decision Analytics is designed to provide basic understanding of the principles and practices of decision analytics, to introduce several decision-making tools for analysing complex decision problem environments, and for making appropriate decisions within that environment, and to strengthen the individual’s decision making skills. 

Course content

Module 1: This three-day module addresses well-structured Decision Analytics problems using spreadsheets. The course addresses the concepts of analytics and introduces few basic decision analytics tools such as linear program and integer program for practical decision making. Examples of a wide variety of problems that can be solved using an Add-in to EXCEL (Solver), will be covered. Problems involving product mix, capital budgeting, transportation, assignment and networks to name a few will be presented.

Module 2: This two-day module builds upon the course “Basic Decision Analytics”. The course addresses the concepts of decision making with goal achievement and multiple objectives. Other topics include managing tasks and resources in network problems and managing waiting line and service utilisation. Non-linear interactions in decision problems and evolutionary optimisation will be discussed. A number of practical problems will be solved using EXCEL Solver.

Learning outcomes

Skills/competencies/knowledge that would be gained through this course:
  • The participants will learn a good number of decision making tools and techniques, and gain skills on the use of Excel Solver in solving practical decision making problems. 
  • Statement of Attendance is provided upon completion. However, to obtain competency certificate, the participants must demonstrate their knowledge gained in the course by completing a few small scale problem solving exercises during the course
  • UNSW Canberra allows students who have successfully completed a minimum of 10 days of approved professional education advanced short courses to use those courses as credit in eligible postgraduate programs.

Who should attend

The course is valuable for anyone faced with complex and continually changing decision problems in public or private sector organisations or communities.


Must be familiar with basic operations of Excel, and knowledge of High School level maths would be an advantage. If not, a short course ‘Basic Data Analytics’ is recommended prior to taking this course.


Prof. Ruhul A Sarker

Prof. Ruhul A Sarker obtained his Ph.D. in Operations Research from Dalhousie University (former TUNS), Halifax, Canada in 1992. He is currently a Professor in the School of Engineering and IT, co-ordinator of the Master of Decision Analytics program in the school, and the Director of Faculty Postgraduate Research at UNSW Canberra (located at ADFA), Australia. He was the Deputy Head of School (Research) from 2011 to 2014. Prof. Sarker’s broad teaching and research interests include decision analytics, computational intelligence, operations research, and applied optimization. He is the lead author of the book Optimization Modelling: A Practical Approach, Taylor & Francis /CRC Press, Boca Raton. Prof. Sarker has successfully obtained more than $1.5million external research grants. He was a member of the national executive committee of the Australian Society for Operations Research (ASOR) and Editor-in-chief of ASOR Bulletin from 2000 to 2011. As recognition of Prof. Sarker’s contributions to ASOR and Operations Research, ASOR awarded him an ASOR Medal (2011) and Special Service Certificate (2009). Currently, he is an associate editor of three international journals.

Cancellation policy

Courses will be held subject to sufficient registrations. UNSW Canberra reserves the right to cancel a course up to five working days prior to commencement of the course. If a course is cancelled, you will have the opportunity to transfer your registration or be issued a full refund. If registrant cancels within 10 days of course commencement, a 50% registration fee will apply. UNSW Canberra is a registered ACT provider under ESOS Act 2000-CRICOS provider Code 00098G.