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.

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

 

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.