3404362: Business intelligence

Description

• Conceptual basics
• Decision Support Systems (DSS)
• Management Information Systems (MIS)
• Executive INformation Systems (EIS)
• The Data-Warehouse Theory
• Attributes of a Data Warehouse
• The Data Warehouse layered architecture
• Online Analytical Processing
• Codd's rules
• Technological appendages (MOLAP, ROLAP, HOLAP)
• The snowflake scheme
• SAP BW NetWeaver Data Modeling
• InfoObjects
• InfoProvicer
• Business Content
• BI Publishing
• Cockpits
• Exception Reporting
• Balanced Scorecard
• Data Mining
• Information Broadcasting
• SAP Business Explorer and SAP BusinessObjects
• Mobile BI
• Data Warehouse Modeling
• Performance optimization
• ETL processes
• Reporting and Analysis
• Composite applications
• Maintenance and operations of Business Intelligence solutions and Data Warehouses
• In Memory Computing with SAP HANA

Lecture Goals

This cource instructs the implementation and operation of Business Intelligence solutions, based on SAP NetWeaver BW, SAP NetWeaver and SAP BusinessObjects. The main learning outcomeas are:

The scholars are familiar with the BI concepts and enabled to build a Data Warehouse, based on SAP NetWeaver BW. They know the relevant tools, like SAP BEx Query Designer, and the BEx front end tools, as well as the SAP BusinessObjects front end tools.

Lectures Method

Vorlesung

Admission Requirements

Für dieses Modul sind keine spezifischen Vorkenntnisse notwendig.

Literature

Pflichtliteratur:

• Hasso Plattner: A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database, Hasso Plattner Institute for IT Systems Engineering University of Potsdam.

• Egger et al. (2009): Reporting und Analyse mit SAP BusinessObjects, Galileo Press. (ISBN: 978-3-8362-1380-6).

Materials

Zur Lehrveranstaltung werden Skripte, Übungsaufgaben und Lösungen zur Verfügung gestellt.

Software: Zugang zu SAP BI wird zur Verfügung gestellt.