Business Intelligence Systems
- Type: Lecture
- Semester: WS 16/17
-
Place:
10.11, Room 213
-
Time:
Thursday
11:30 - 13:00
Weekly
- Lecturer: Prof. Dr. Alexander Mädche
- SWS: 2/1
- ECTS: 4,5
- Lv-No.: 80270210
- Information:
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 SAP Lumira tools to create a BI solution by doing the capstone project.
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 SAP Lumira tools to create a BI solution by doing the capstone project.
Course Content
Time
Lecture: Thu 11:30 – 13:00 / Geb. 10.11, Room 213 / Starting 20.10.16
Assignment (5 sessions): Thu 14:00 –15:30 / Geb. 10.11, Room 223 / Starting 27.10.16
Capstone Presentation: TBD / Geb. 10.11, Room 223 / 09.02.2017
Assignment (5 sessions): Thu 14:00 –15:30 / Geb. 10.11, Room 223 / Starting 27.10.16
Capstone Presentation: TBD / Geb. 10.11, Room 223 / 09.02.2017
Course Schedule
Date, Time |
Building, Room |
Block |
Lecture |
October 20th , 11:30 – 13:00 |
10.11, Room 213 |
Foundations |
(1) Organizational Information and Foundations |
October 27th , 11:30 –13:00 | 10.11, Room 213 | BI Provisioning Capabilities | (1/2) Foundations cont’d and ETL, Data Warehouses & Data Marts |
November 3rd, 11:30 – 13:00 | 10.11, Room 213 | BI Provisioning Capabilities | (2) ETL, Data Warehouses & Data |
November 10th, 11:30 – 13:00 | 10.11, Room 213 |
BI ProvisioningCapabilities |
(3) Big Data Technologies |
November 17th, 11:30 – 13:00 | 10.11, Room 213 | BI Consumption Capabilities | (4) Reporting & Dashboards |
November 24th , 11:30 – 13:00 | 10.11, Room 213 | BI Consumption Capabilities | (5) Advanced Analytics |
December 1st , 11:30 – 13:00 | 10.11, Room 213 | BI Consumption Capabilities | (6) BPM & Process Intelligence |
December 8th , 11:30 – 13:00 | 10.11, Room 213 | Management of BI Systems | (7) BI Strategy & Governance, Implementation Projects |
December 15th , 11:30 – 13:00 | 10.11, Room 213 | Business Talk | Bosch |
January 19th , 11:30 – 13:00 | 10.11, Room 213 | Management of BI Systems | (8) Adoption & Use of BI Systems |
January 26th , 11:30 – 13:00 | 10.11, Room 213 | Management of BI Systems | (9) Trends, Our Research, Q&A |
February 9th , TBD | 10.11, Room 223 | Capstone Project | Group presentations of the KPMG case study results |
Assignment Schedule
Date, Time |
Building, Room |
Block |
Lecture |
Speaker |
October 27th , 14:00 –15:30 |
10.11, Room 223 |
Exercise 1 |
(4) Capstone Project Introduction / Overview KPMG |
KPMG |
November03r, 14:00 –15:30 |
10.11, Room 223 |
Exercise 2 | (1) SAP HANA & Lumira Introduction & Data Loading | Peyman Toreini |
November10th , 14:00 –15:30 |
10.11, Room 223 |
Exercise 3 | (2) SAP HANA & Lumira: Data Modelling | Peyman Toreini |
November17t, 14:00 –15:30 |
10.11, Room 223 |
Exercise 4 | (3) SAP HANA & Lumira: Reporting & Analysis | Peyman Toreini |
December 1st, 14:00 –15:30 |
10.11, Room 223 |
Exercise 5 | Q&A (Mandatory) | Peyman Toreini |
January 12th, 14:00 –15:30 |
10.11, Room 223 |
Exercise 6 | Q&A (Optional) | Peyman Toreini |
February 9th
, TBD |
10.11, Room 223 |
Final Presentation | Final Presentation
|
All |
Course Grading
Exam (individual effort) : 60 %
Capstone Project (team effort, with individual accountability): 40 %Contact:
For submission of capstone project and organizational questions please contact Peyman Toreini.