VL Data Warehousing

TitleData Warehousing
Weekly hours2 SSt. (3 ECTS)
ObjectivesStudents are able to apply methods and tools for the integration of large amounts of data - particularly business and web data - in a data warehouse. Students know methods and tools for data analysis with data warehouses - particularly OLAP languages. Students know the reference architecture of data warehouse systems, are able to plan, design and implement data warehouse systems.
  • Reference architecture of data warehousing systems
  • Multidimensional data model
  • Conceptual, logical and physical design process for data warehouses
  • Extraction, cleaning and storage techniques for business data
  • languages and tools for OLAP
  • Security aspects
  • Distributed data warehousing
  • Big Data Analytics