Business Intelligence Systems

  • Type: Lecture
  • Semester: WS 17/18
  • Place:

    10.11, Room 223

  • Time: Monday 11:30 - 13:00 (weekly)
  • Lecturer: Prof. Dr. Alexander Mädche
    Mario Nadj
  • SWS: 2 + 1
  • Lv-No.: 2540422

Course Description

Systems targeting to achieve business advantages by enhancing enterprise transparency and improving decision-support effectiveness have been designed and developed over the last 40 years. Today, they are subsumed under the heading business intelligence (BI). This lecture aims to provide a holistic understanding of the area of business intelligence, including a management, organizational and technical perspective. Students will get in this lecture the theoretical knowledge of major concepts of the area, as well as a more practically oriented view of tools and their actual use.
From a practically oriented perspective, students will expand the theoretical foundations by carrying out a capstone project and create a BI solution for a particular business scenario by themselves. The capstone project in the BI lecture is in cooperation with KPMG and students will work with a real dataset from KPMG customers. Moreover, students will learn how to work with SAP HANA and PowerBI tools to create a BI solution by doing the capstone project.

Course Content

BIS1718

Time

Lecture: Mondays 14:00 – 15:30 / Geb. 11.10, Room 223 / Starting 16.10.17
Assignment (5 sessions): Tuesday 14:00 –15:30 / Geb. 11.10, Room 213 / Starting 24.10.17
Capstone Presentation: TBD / Kd2Lab / 09.02.2018

Course Grading

Exam (individual effort) : 60 %

Capstone Project (team effort, with individual accountability): 40 %

 

Course Schedule

 

Date, Time

Building, Room

Block

Lecture         

October 16th , 11:30 – 13:00

 

10.11, Room 223

Foundations

Organizational Information and Foundations

October 23rd 
11:30 – 13:00
10.11, Room 223 BIS Provisioning Capabilities Foundations cont’d  and ETL, Data Warehouses & Data Marts
October 30th,
11:30 – 13:00
10.11, Room 223 BIS Provisioning Capabilities ETL, Data Warehouses & Data
November 13th
11:30 – 13:00
10.11, Room 223

BIS ProvisioningCapabilities

Big Data Technologies
November 20th
11:30 – 13:00
10.11, Room 223 BIS ConsumptionCapabilities Reporting & Dashboards
November 27th 
11:30 – 13:00
10.11, Room 223 BIS ConsumptionCapabilities Reporting & Dashboards cont'd
December 4st 
11:30 – 13:00
10.11, Room 223 BIS Consumption Capabilities  Advanced Analytics
December 11th 
11:30 – 13:00
10.11, Room 223 BIS Consumption Capabilities BPM & Process Intelligence
December 18th 
11:30 – 13:00
10.11, Room 223 IndustryTalk | Trumpf
January 8th ,
11:30 – 13:00
10.11, Room 223 Management of BIS  BI Strategy & Governance, BIS Implementation Projects
 January 15th ,
11:30 – 13:00
10.11, Room 223  Industry Talk ||  Bosch
 January 29th 
11:30 – 13:00
10.11, Room 223 Management of BIS  Adoption & Use of BIS
 February 5th , 
11:30 – 13:00
10.11, Room 223 Summary Trends, Our BIS Research, Summary, Trial Exam, Q&A

 

 

 

Assignment Schedule

 
 

Date, Time

Building, Room

Block

Lecture 

 Speaker

October 24th , 14:00 –15:30

10.11,
Room 213

Exercise 1

(4) Capstone Project Introduction / Overview KPMG

 KPMG
November07th
14:00 –15:30
 10.11,
Room 213
Exercise 2  (1) SAP HANA & PowerBI Introduction Data Loading  Peyman Toreini
November14th 
14:00 –15:30
 10.11,
Room 213
Exercise 3  (2) SAP HANA & PowerBIData Modelling  Peyman Toreini
November28t,
14:00 –15:30
 10.11,
Room 213
Exercise 4  (3) SAP HANA & PowerBIReporting & Analysis  Peyman Toreini
December 12st,
14:00 –15:30
 10.11,
Room 213
Exercise 5  Midterm Presentation (Demo Data)  Peyman Toreini
January 9th,
14:00 –15:30
 10.11,
Room 213
Exercise 6  Q&A (KPMG Data)  Peyman Toreini
February 9th , 
TBD
Kd2Lab Final Presentation  Final Presentation

 

 All

Contact:

For submission of capstone project and organizational questions please contact Peyman Toreini

For the questions relevant to exam, please contact Dr.Nadj