Quantitative Business Analysis Models

Course facts

Code:
M07310
Credits:
7.5
Study period:
2026-10-27 - 2027-01-18
Organization:
Department of Entrepreneurship, Innovation and Technology
Information:
Elective Course (All MSc Programs)
CEMS Elective Course

Description

Course Director: Johan Båge

Content is subject to change, and the changes will be posted on the Canvas in October.

Purpose
This course gives comprehensive knowledge in creating and using models for business analysis with the use of computers. It complements other courses in the master program and is useful when composing a thesis. The course is also valuable from job interviews throughout careers in business life and academia: in business, accounting, finance, economics, marketing, and management.

Content
The amount of business data is vast and growing. And so is the demand for the knowledge how to use models to analyze data. In this course, theories and models are used to create analysis models. Many of these models are widely used in industry. Furthermore, real business data is used with samples from both large and small organizations, and from small data sets to the notion of "big data". The results of analyses with the models are presented and assessed. During the course, students will have the opportunity to learn and exercise how to use Excel and Python in order to:

  • Build, analyze and assess models for business analysis
  • Organize and analyze business data, such as sales, accounting, economic, financial, and web data etc
  • Describe data, patterns, relations, and predictability
  • Compute decisions that give, for example, maximum profits
  • Conduct sensitivity and what-if analyses
  • Study market behavior and decision rules
  • Analyze data with theories and models, assess and present results

Course format
The course is based on the lectures, seminars, exercises and assignments. The exercises and their respective seminars are voluntary; the assignments and the seminars where they are presented are mandatory. The first, last and the guest lectures are all mandatory. The mandatory session will be accessible online, so remote attendance is an option. The first lecture will contain all relevant administrative information needed to pass the course. The exercises are designed so students can solve problems in individual pace, and ask questions related to the topic. At the end of each exercise, solutions are presented and can be reviewed. It can be possible to alter between groups to fit personal schedules, please let us know so that we can follow the logistical restrictions. The bachelor course DA IV (or equivalent) is not a prerequisite, but useful, for this course. Microsoft Excel and Python will be used as tool for analysis.

Note that while it is possible to take and pass this course online, it is NOT an online course per se - it is a hybrid course. That means not all of the course resources will be available online - most notably the seminars and Q/A sessions are classroom only. Be aware of this if you plan on only using the online parts of the course.

Registration
This course is for Master's students only, Bachelor students cannot register for this course. If you have any questions about course registration, deregistration or being placed on a waiting list, please contact the course administrator.

Course administrator: Anna.Burell@hhs.se

Intended learning outcomes

By the end of the course, students should be able to:

  • Structure business problems, and create models for analysis
  • Develop and use business analysis model on computers
  • Organize data, conduct analysis with theories and models, assess and present results

Prerequisites

Students do not need to have previous knowledge of Python or programming in general. Students are expected to have a foundation of Excel knowledge, equivalent to the mandatory Excel module in the bachelor course DA II. Students are expected to fill any gaps in this foundation during the first week of the course (recap course material will be provided).

Literature

No literature is required. The course material is made available online via Canvas. Besides that almost all problems one can encounter in Excel or Python have a solution that has been posted online, so access to google should be enough of a complement to the course material provided.

If a student wishes to have further reference literature, the list below contains a some that could be of use.

Reference literature

Dodge, M. & Stinson, C. (2010). Microsoft Office Excel 2010 Inside Out. Microsoft Press.

Jelen, B. Syrstad, T. (2010). Using Microsoft Office Excel 2010. Que Publishing.

Jelen, B. & Syrstad, T. (2010). VBA and Macros for Microsoft Office Excel 2010. Que Publishing.

Judd, K. (1998). Numerical Methods in Economics. The MIT Press.

Law, A. (2006). Simulation Modeling and Analysis. The MIT Press.

Miranda, M. & Fackler, P. (2002). Applied Computational Economics and Finance. The MIT Press.

Examination

The Grading system for this course is Pass/Fail.

The examination of the course consists of individual assignments, which are peer graded, handed in and presented orally. Mandatory.

Schedule

Find the course schedule in: TimeEdit

Make sure that you can attend ALL of the mandatory sessions if you wish to take this course.

Attendance is required during three specific lectures. These are:

  • The First Lecture (Tuesday 27th Oct 10-12)
  • The Guest Lecture (Thursday 26th Nov 10-12)
  • The Last Lecture (Tuesday 15th Dec 13-15)

Attendance is also mandatory during the three presentation seminars:

  • Presentation 1 (Tuesday 3rd Nov 10-12, 13-15)
  • Presentation 2 (Thursday 19th Nov 10-12, 13-15)
  • Presentation 3 (Thursday 3rd Dec 10-12, 13-15)

All mandatory sessions can be attended online via zoom.

Additional information

Have you been granted educational support because of a documented disability? If so, please contact the course director as soon as possible so that adequate accommodations can be made.

Contact specialneeds@hhs.se if you have questions about being granted educational support or need a copy of your educational support certificate.

For more information, visit the Specific Educational Needs page on the Student Hub (login required).