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
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 & PowerBI: Data Modelling | Peyman Toreini |
November28t, 14:00 –15:30 |
10.11, Room 213 |
Exercise 4 | (3) SAP HANA & PowerBI: Reporting & 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