Vorlesung + Übung: Cases in Business Analytics - Details

Vorlesung + Übung: Cases in Business Analytics - Details

You are not logged into Stud.IP.

General information

Course name Vorlesung + Übung: Cases in Business Analytics
Course number WIW-0355
Semester WS 2024/25
Current number of participants 15
Home institute Prof. Dr. Sebastian Schiffels - Digital Health and Medical Decision Making
Courses type Vorlesung + Übung in category Teaching
Next date Tuesday, 14.01.2025 15:45 - 19:00, Room: (J: CIP 2113)
Veranstaltung findet in Präsenz statt / hat Präsenz-Bestandteile Yes
Hauptunterrichtssprache englisch
Miscellanea Dear students,

the spots in this course are limited. Additionally to signing in for this course on Digicampus, you will need to apply separately using a form. You can find the form here: https://www.uni-augsburg.de/de/fakultaet/wiwi/prof/bwl/schiffels/lehre/anmeldung-softwarekurs/ Registration is open from September 23, 2024 until October 9, 2024 11:59PM.

If you plan to work a lot from home and not in the CIP-pool for the homework assignments, it is highly recommended that you have access to a Windows machine with Microsoft Excel 2016 or newer installed. The Mac OS Version does not support all necessary functions taught in this course.

Best, Jakob

Rooms and times

(J: CIP 2113)
Tuesday: 15:45 - 19:00, weekly (11x)

Module assignments

Comment/Description

The course deals with the following topics:
- Advanced Excel functions
- Application of Sensitivity Analysis and Pivot-Tables for advanced business analytics
- Utilization of the Excel Solver for optimization problems
- Performing Monte Carlo Simulation
- Using Power-Query to enable advanced Data Management
- Macro-Recording and Visual Basic for Applications

Admission settings

The course is part of admission "Anmeldung gesperrt (global)".
The following rules apply for the admission:
  • Admission locked.