Digicampus
Projektseminar: Cases in Business Analytics - Details
Sie sind nicht in Stud.IP angemeldet.
Lehrveranstaltung wird als Hybrid/gemischt abgehalten.

Allgemeine Informationen

Veranstaltungsname Projektseminar: Cases in Business Analytics
Semester SS 2022
Aktuelle Anzahl der Teilnehmenden 12
erwartete Teilnehmendenanzahl 15
Heimat-Einrichtung Prof. Dr. Jens Brunner - Health Care Operations / Health Information Management
Veranstaltungstyp Projektseminar in der Kategorie Lehre
Erster Termin Montag, 23.05.2022 15:45 - 19:00, Ort: (CIP 2114)
Online/Digitale Veranstaltung Veranstaltung wird als Hybrid/gemischt abgehalten.
Hauptunterrichtssprache englisch
Sonstiges Dear students,

the spots in this course are limited. To apply for one of the spots, please download the application file from the files section in this course, fill it out and send it to Alexander Horn (alexander.horn@uni-a.de) including your most recent Studis transcript of records, a recent CV (english or german) as well as the signed declaration of consent (in the files section), in case we have to swith to a remote session. If you want to attend another software class of our chair, please use the same form and indicate, if you want to apply for both but just want to take one class or if you want to apply for both and would like to participate in both classes. Deadline for application is April 27, 2022 11:59 PM

The course will be held in a compact format, meaning that the first Lecture will be on May 23 and the final presentations will be on June 29. This will result to an increased workload during those five weeks but no workload in the remaining weeks of the semester.

Currently, we are planning to hold the course in the computer labs (CIP-pools) of the University. To stay flexible for any unforeseen upcoming events or in case one of the students has to go in quarantine during the course, we are labeling this course as hybrid version, meaning that we will stream the course via Zoom from the CIP-pool if necessary. Due to the frequent presentations during the course, we will focus on holding this course offline (CIP Pool). Hybrid (parallel streaming in Zoom) will only be offered in exceptional cases after consultation with the lecturer.

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

Räume und Zeiten

(CIP 2114)
Montag: 15:45 - 19:00, wöchentlich (3x)
Montag: 15:45 - 19:00, wöchentlich (2x)
Mittwoch: 15:45 - 19:00, wöchentlich (2x)
Mittwoch: 15:45 - 19:00, wöchentlich (4x)

Kommentar/Beschreibung

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.

Anmelderegeln

Diese Veranstaltung gehört zum Anmeldeset "Zeitgesteuerte Anmeldung: Cases in Business Analytics".
Folgende Regeln gelten für die Anmeldung:
  • Die Anmeldung ist möglich von 08.03.2022, 00:00 bis 27.04.2022, 23:59.