Digicampus
Project seminar: Cases in Business Analytics - Details
You are not logged into Stud.IP.
Lehrveranstaltung wird als Hybrid/gemischt abgehalten.

General information

Course name Project seminar: Cases in Business Analytics
Semester WS 2022/23
Current number of participants 17
expected number of participants 15
Home institute Prof. Dr. Jens Brunner - Health Care Operations / Health Information Management
Courses type Project seminar in category Teaching
First date Wed., 26.10.2022 15:45 - 19:00, Room: (CIP 2113)
Online/Digitale Veranstaltung Veranstaltung wird als Hybrid/gemischt abgehalten.
Hauptunterrichtssprache englisch
Miscellanea Dear students,

the spots in this course are limited. The registration process is described on our website https://www.uni-augsburg.de/de/fakultaet/wiwi/prof/bwl/brunner/lehre/ in the section for software courses. Please register for this digicampus course and fill out the application linked on our website. Deadline for application is October 19, 2022 11:59 PM

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

Course location / Course dates

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

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.