Digicampus
Project seminar: Cases in Business Analytics - Details
Close message box
You are not logged into Stud.IP.
Lehrveranstaltung wird in Präsenz abgehalten.

General information

Course name Project seminar: Cases in Business Analytics
Semester SS 2023
Current number of participants 21
expected number of participants 15
Home institute Prof. Dr. Sebastian Schiffels - Digital Health and Medical Decision Making
Courses type Project seminar in category Teaching
First date Tue., 25.04.2023 15:45 - 19:00, Room: (CIP 2113)
Online/Digitale Veranstaltung Veranstaltung wird in Präsenz abgehalten.
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. Due to the new assignment of this course to Prof. Schiffels, the application form is still on the website of Prof. Brunner. You can find the form here: https://www.uni-augsburg.de/de/fakultaet/wiwi/prof/bwl/brunner/lehre/anmeldung-softwarekurs/ Registration is open from April 1, 2023 until April 19, 2023 11:59 PM

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 thought in this course.

Best, Steffen

Course location / Course dates

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

Module assignments

Comment/Description

In this course the students learn to use Excel as a tool for Business Analytics. At the end of the module, the students are able to use Excel effectively to analyze, optimize, and simulate service processes. Furthermore, the students are able to present their findings in class. Finally, they are able to make sound decisions. The course deals with the following topics:

• Advanced Excel Formulas
• Pivot Tables
• Optimization with the Excel Solver
• PowerQuery as Database tool
• Monte Carlo Simulation
• Macro Recording & VBA

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 neccecary functions tought in this course.

Admission settings

The course is part of admission "Zeitgesteuerte Anmeldung: Cases in Business Analytics".
Additionally to signing in for this course on Digicampus, you will need to apply separately using a form. Due to the new assignment of this course to Prof. Schiffels, the application form is still on the website of Prof. Brunner. You can find the form here: https://www.uni-augsburg.de/de/fakultaet/wiwi/prof/bwl/brunner/lehre/anmeldung-softwarekurs/ Registration is open from April 1, 2023 until April 19, 2023 11:59 PM
The following rules apply for the admission:
  • The enrolment is possible from 01.04.2023, 00:00 to 19.04.2023, 23:59.

Registration mode

After enrolment, participants will manually be selected.

Additionally to signing in for this course on Digicampus, you will need to apply separately using a form. Due to the new assignment of this course to Prof. Schiffels, the application form is still on the website of Prof. Brunner. You can find the form here: https://www.uni-augsburg.de/de/fakultaet/wiwi/prof/bwl/brunner/lehre/anmeldung-softwarekurs/ Registration is open from April 1, 2023 until April 19, 2023 11:59 PM