Digicampus
Vorlesung + Übung: Cases in Business Analytics - Details
You are not logged into Stud.IP.
Lehrveranstaltung wird online/digital abgehalten.

General information

Subtitle Business Analytics in Service Operations Management
Semester WS 2020/21
Current number of participants 17
expected number of participants 15
Home institute Prof. Dr. Jens Brunner - Health Care Operations / Health Information Management
participating institutes Wirtschaftswissenschaftliche Fakultät
Courses type Vorlesung + Übung in category Teaching
First date Thu , 01.10.2020 09:30 - 12:30
Participants The exercises during the seminar should be processed in groups of 3 students.
Pre-requisites Basic knowledge in mathematics and statistics is required.
Learning organization All course topics are introduced in class by a lecture and tutorials. Students solve assignment-sheets in groups of three and can get assistance by a tutor.
Performance record Course assessment consists of the following parts:
• Results of assignment-sheets (as group)
• Presentation (individually)
• In-class participation (individually)

Since every course is part of the course assignment, it's necessary to be present in each of the six lecture-dates !
Online/Digitale Veranstaltung Veranstaltung wird online/digital abgehalten.
Hauptunterrichtssprache englisch
Miscellanea The course is limited to 15 students. Therefore an application is necessary. Please register for the course on the following website: https://wiki.unika-t.de/Students+Application with your "rz-Kennung" until Sunday September 27 2020. We will inform you whether or not you can attend the course until Wednesday September 30 2020.

Course location / Course dates

n.a Thu , 01.10.2020 09:30 - 12:30
Fri , 02.10.2020 09:30 - 12:30
Tue , 06.10.2020 13:30 - 16:30
Wed , 07.10.2020 13:30 - 16:30
Tue , 13.10.2020 13:30 - 16:30
Wed , 14.10.2020 13:30 - 16:30
Tue , 20.10.2020 13:30 - 16:30
Wed , 21.10.2020 13:30 - 16:30
Tue , 27.10.2020 13:30 - 16:30
Wed , 28.10.2020 13:30 - 16:30
Tue , 03.11.2020 13:30 - 16:30

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

Admission settings

The course is part of admission "Anmeldung gesperrt (global)".
Settings for unsubscribe:
  • Admission locked.