Project Business Analytics 2

COURSE OBJECTIVE
After completion of this course, the student can
1. use Excel and Crystal Ball to perform Monte Carlo simulations
2. build a simulation model for a practical problem in risk management based on given data
3. analyze and assess risks, and give a recommendation on the basis of this simulation model
4. present his/her approach and results in a written report
5. present his/her approach and results in an oral presentation

COURSE CONTENT
You will work in teams to solve a simplified business case about risk management using a simulation model in Excel and Crystal Ball. You will use knowledge obtained in other Business Analytics courses in the first year, in particular the courses Probability Theory and Risk Management to build and analyse your model. You will write a report and give an oral presentation on your results and conclusions.

TEACHING METHODS
The course starts with an introductory lecture. During the first week of the course you will work on computer assignments in the field of applied probability theory and risk management. During the second and third week, you will continue with a team project. For both the computer assignments and the team project, 3 hours of computer lab work is scheduled each weekday. The final presentation in the last week of the course will be scheduled on an individual basis.

TYPE OF ASSESSMENT
Part A: Five computer assignments (5% of the grade each, 25% in total), submitted either in pairs of individually.
Part B: A written report and simulation model (in Excel) of your team (50% of the grade).
Part C: An individual oral presentation (25% of the grade).

You must complete all parts of the course to receive a final grade.