Peter Scheuermann, guest professor at SBA Research, gives a course on Data Warehousing and Business Intelligence at the Vienna University of Technology.
“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.”