Please note! Course description is confirmed for two academic years, which means that in general, e.g. Learning outcomes, assessment methods and key content stays unchanged. However, via course syllabus, it is possible to specify or change the course execution in each realization of the course, such as how the contact sessions are organized, assessment methods weighted or materials used.

LEARNING OUTCOMES

The objective of the course is to give the students an understanding of the data informed decision-making. The focus is on business-oriented analytical skills, which enable the students to work with the data, to understand them and turn them into intelligence and actions.

Credits: 6

Schedule: 01.03.2021 - 07.04.2021

Teacher in charge (valid 01.08.2020-31.07.2022): Yong Liu

Teacher in charge (applies in this implementation): Yong Liu

Contact information for the course (valid 05.02.2021-21.12.2112):

Lecturer: Yong Liu (yong.liu@aalto.fi)
Teaching assistant: Jiang Yuting (yuting.jiang@aalto.fi)

CEFR level (applies in this implementation):

Language of instruction and studies (valid 01.08.2020-31.07.2022):

Teaching language: English

Languages of study attainment: English

CONTENT, ASSESSMENT AND WORKLOAD

Content
  • Valid 01.08.2020-31.07.2022:

    This course aims at providing an understanding of issues related to data informed decision-making and problem solving. To do this, it offers a balanced insight into the building blocks of business intelligence (BI), such as data management, data warehousing, reporting, and analytics. Besides a set of guest speakers representing academia and business life, a central feature of the course is a BI challenge, which students work in small groups. The course requires both independent learning skills and organizational skills.

  • Applies in this implementation:

    In this course, you will learn two popular BI software, including Power BI and IBM Cognos. The business analyst job market and its requirements will be studied. We will elaborate on how BI has been used and implemented at different levels of enterprise management. Speakers from industries (e.g. F-secure, Ecraft) are invited to present in the course to talk about how BI has been used at their companies. IBM will provide technical support to the learning of IBM Cognos and explains the requirements of implementing BI at enterprises from a view of BI system designer. We will explain how data scientists work with data and model and how to learn and use R effectively.

Assessment Methods and Criteria
  • Valid 01.08.2020-31.07.2022:

    Spring 2021:

    50% assignments
    50% learning diary

    Spring 2022:

    70% assignments
    30% learning diary

  • Applies in this implementation:

    Based on the use of Power BI (10%) and IBM Cognos (40%), two assignments will be submitted.
    Based on the lectures, students are required to write learning diaries (50%).



Workload
  • Valid 01.08.2020-31.07.2022:

    Contact teaching 24h
    Independent work 136h
    Total 160h (6 ECTS)

  • Applies in this implementation:

    Course activities include:
    1. Contact teaching
    2. Learning diary
    3. Power BI: video and individual assignment
    4. IBM Cognos: lecture and group assignment
    5. Reading literature



DETAILS

Study Material
  • Valid 01.08.2020-31.07.2022:

    Course book: Sharda, Ramesh Delen, Dursun Turban, Efraim (2014) Business Intelligence and Analytics (10th edition). Pearson, New York (NY).

Substitutes for Courses
  • Valid 01.08.2020-31.07.2022:

    37E00550 Business Intelligence

    EMS MIM students can replace this capstone with 42E05400 CEMS Business Project

Prerequisites
  • Valid 01.08.2020-31.07.2022:

    Before registration, one is expected to know SQL and database management basics.

Registration for Courses
  • Valid 01.08.2020-31.07.2022:

    Via WebOodi

  • Applies in this implementation:

    A knowledge on SQL is important for understanding how data scientists work with data and model!