195.074 Data Warehousing and Business Intelligence
Diese Lehrveranstaltung ist in allen zugeordneten Curricula Teil der STEOP.
Diese Lehrveranstaltung ist in mindestens einem zugeordneten Curriculum Teil der STEOP.

2014S, VU, 2.0h, 3.0EC

Merkmale

  • Semesterwochenstunden: 2.0
  • ECTS: 3.0
  • Typ: VU Vorlesung mit Übung

Ziele der Lehrveranstaltung

This course will provide state of the art coverage of data warehousing (DW) and it use in a business intelligence platform. We will study the Dimensional Fact Model (DFM) that provides the conceptual layer of a DW and then discuss a number of logical models that are used to represent a multidimensional data structures: ROLAP and MOLAP. Next, we will discuss the steps involved in populating a DW : ETL—Extract, Transform and Load. We will also study the modern techniques that deal with big data in the context of data warehousing: Column Store databases, No-SQL and Hadoop.

Inhalt der Lehrveranstaltung

Introduction: DW

  • DW –requirements, basic architecture and life-cycle.

Conceptual Modeling of DW:

  • The DFM: facts, measures dimensions and cubes
  • Events and Aggregation : additive, non-additive, aggregations with hierarchies
  • Advanced Concepts: slowly-changing dimensions and dynamic hierarchies.

Logical Modeling of DW:

  • ROLAP versus MOLAP
  • Star schemas and snowflake schemas
  •  View materialization and greedy algorithm for their selection

ETL—Extract, Load and Transform:

  • Immediate and delayed extraction, computing deltas
  • Loading dimension, fact tables and populating materialized views
  • Data Cleansing

Real-time Business Intelligence with DW:

  • Detecting changes with sentinels: a new data mining type
  • In memory implementations for DW

Weitere Informationen

This is a visiting professor course of Vienna PhD School of informatics in the area of Business Informatics. 

Lecturer: Peter Scheuermann, Northwestern University, US.

Vortragende

Institut

LVA Termine

TagZeitDatumOrtBeschreibung
Di.10:30 - 12:0025.03.2014 - 08.04.2014Seminarraum FAV 01 B (Seminarraum 187/2) Lecture
Do.10:30 - 12:0027.03.2014 - 10.04.2014FAV Hörsaal 3 Zemanek (Seminarraum Zemanek) Lecture
Di.10:30 - 12:0029.04.2014 - 27.05.2014Seminarraum FAV 01 B (Seminarraum 187/2) Lecture
Do.10:30 - 12:0008.05.2014 - 22.05.2014FAV Hörsaal 3 Zemanek (Seminarraum Zemanek) Lecture
Data Warehousing and Business Intelligence - Einzeltermine
TagDatumZeitOrtBeschreibung
Di.25.03.201410:30 - 12:00Seminarraum FAV 01 B (Seminarraum 187/2) Lecture
Do.27.03.201410:30 - 12:00FAV Hörsaal 3 Zemanek (Seminarraum Zemanek) Lecture
Di.01.04.201410:30 - 12:00Seminarraum FAV 01 B (Seminarraum 187/2) Lecture
Do.03.04.201410:30 - 12:00FAV Hörsaal 3 Zemanek (Seminarraum Zemanek) Lecture
Di.08.04.201410:30 - 12:00Seminarraum FAV 01 B (Seminarraum 187/2) Lecture
Do.10.04.201410:30 - 12:00FAV Hörsaal 3 Zemanek (Seminarraum Zemanek) Lecture
Di.29.04.201410:30 - 12:00Seminarraum FAV 01 B (Seminarraum 187/2) Lecture
Di.06.05.201410:30 - 12:00Seminarraum FAV 01 B (Seminarraum 187/2) Lecture
Do.08.05.201410:30 - 12:00FAV Hörsaal 3 Zemanek (Seminarraum Zemanek) Lecture
Di.13.05.201410:30 - 12:00Seminarraum FAV 01 B (Seminarraum 187/2) Lecture
Do.15.05.201410:30 - 12:00FAV Hörsaal 3 Zemanek (Seminarraum Zemanek) Lecture
Di.20.05.201410:30 - 12:00Seminarraum FAV 01 B (Seminarraum 187/2) Lecture
Do.22.05.201410:30 - 12:00FAV Hörsaal 3 Zemanek (Seminarraum Zemanek) Lecture
Di.27.05.201410:30 - 12:00Seminarraum FAV 01 B (Seminarraum 187/2) Lecture

LVA-Anmeldung

Von Bis Abmeldung bis
01.03.2014 00:00 31.03.2014 00:00 31.05.2014 00:00

Anmeldemodalitäten:

Registration takes place in TISS

Curricula

StudienkennzahlSemesterAnm.Bed.Info
PhD Vienna PhD School of Informatics

Literatur

  1. “The Data Warehouse Life Cycle Toolkit.”, Second Edition by R. Kimball et. al, Wiley, 2008
  2. Data Warehouse Design: Modern Principles and Methodologies by M. Golfarelli and S. Rizzi, McGraw-Hill, May 20009

Sprache

Englisch