Digicampus
Projektseminar: Cases in Business Analytics - Details
Nachrichtenbox schließen
Sie sind nicht in Stud.IP angemeldet.
Lehrveranstaltung wird online/digital abgehalten.

Allgemeine Informationen

Veranstaltungsname Projektseminar: Cases in Business Analytics
Semester WS 2021/22
Aktuelle Anzahl der Teilnehmenden 9
erwartete Teilnehmendenanzahl 15
Heimat-Einrichtung Prof. Dr. Jens Brunner - Health Care Operations / Health Information Management
Veranstaltungstyp Projektseminar in der Kategorie Lehre
Erster Termin Donnerstag, 28.10.2021 14:15 - 17:45, Ort: (https://uni-augsburg.zoom.us/s/96844140441)
Online/Digitale Veranstaltung Veranstaltung wird online/digital abgehalten.
Hauptunterrichtssprache englisch
Sonstiges Dear students,

the spots in this course are limited. To apply for one of the spots, please download the applications files from the files section in this course, fill them out and send them to Alexander Horn (alexander.horn@uni-a.de) including your most recent Studis transcript of records. 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 October 20, 2021 11:59 PM

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

(https://uni-augsburg.zoom.us/s/96844140441)
Donnerstag: 14:15 - 17:45, wöchentlich (11x)

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.