The course deals with general topics of business analytics with a focus on digitalization and sustainability, and is divided into the following parts:

  • Basic and Advanced Excel Formulas
  • Basic Mathematical Optimization
  • Monte Carlo Simulation with Excel
  • Power Query and Power Pivot in Excel
  • Macro Recording and Usage of VBA

The course has the following learning objectives:

Subject-related skills: Students are able to use in-depth methods of data manipulation. They learn to apply modeling of mathematical optimization and to correctly interpret obtained results. The students are capable of implementing the introduced methods using suitable spreadsheet software (e.g., MS Excel).

Methodical skills: Students are able to implement different data problems and solve mathematical programming problems using suitable spreadsheet software (e.g., MS Excel). At the end of the module, the students are able to understand the approaches to tackle planning problems in management and they understand different data structures in business life. Furthermore, the students are able to assess the modeling approaches in terms of effectiveness and efficiency, and to present their findings in class.

Interdisciplinary skills: Students are able to apply what they have learned to other subjects of their course of study. Students are able to apply these skills in every-day life. In particular, students develop skills for critical understanding of the capabilities and limitations of the utilized methods, which can be applied to other situations in life.

Key qualifications: Students are able to analyze questions from business life and problems from everyday life. In doing so, they develop critical thinking skills. Students develop the skills to present achieved results. Finally, they are able to make sound decisions in complex situations.