Jump to navigation Jump to content Jump to help Jump to language Jump to logout

491739-HS2024-0-Business Analytics using Excel





Root number 491739
Semester HS2024
Type of course Lecture
Allocation to subject Business Administration
Type of exam Oral exam
Title Business Analytics using Excel
Description This course covers the design, development, and implementation of Excel-based decision support systems using various techniques from business analytics. The first part of the course consists of lectures and exercises, including an introduction to programming in Visual Basic for Applications, and a project; the latter consists of the development and implementation of a decision support system for a given planning situation.

Prerequisites are the knowledge of linear optimization and mixed-integer linear optimization discussed in the undergraduate course "Quantitative Methods in Business Administration". In particular, students should be able to implement a given optimization model in Microsoft Excel, use the solver add-in to find an optimal solution, and interpret the results.

To register for this course, please send a current transcript to elena.rener@unibe.ch by September 9, 2024.
ILIAS-Link (Learning resource for course) Registrations are transmitted from CTS to ILIAS (no admission in ILIAS possible). ILIAS
Link to another web site
Lecturers Prof. Dr. Norbert Trautmann, Chair of Quantitative Methods in Business Administration ✉
Dr. Elena Rener, Chair of Quantitative Methods in Business Administration ✉
ECTS 4.5
Recognition as optional course possible No
Grading 1 to 6
 
Dates Wednesday 18/9/2024 08:15-10:00
Monday 23/9/2024 16:15-18:00
Wednesday 2/10/2024 08:15-10:00
Monday 7/10/2024 16:15-18:00
Wednesday 9/10/2024 08:15-10:00
Monday 14/10/2024 16:15-18:00
Wednesday 16/10/2024 08:15-10:00
Monday 25/11/2024 16:15-18:00
Wednesday 4/12/2024 08:15-10:00
 
Rooms Seminarraum 206, Hauptgebäude H4
 
Students please consult the detailed view for complete information on dates, rooms and planned podcasts.