Marcin Szeliga
Andrzej Kukuła

Data warehouse is a crucial part of every Business Intelligence system — its design and implementation determine if stored data can be used to answer business questions quickly and efficiently. Because data warehouses serve a different purpose than operational databases (OLTP), their structure is also different, which means that to create a successful data warehouse a distinct set of skills is needed.

The goal of the workshop is to equip BI specialists and database programmers with knowledge and skills necessary to manage and conduct data warehouse projects. The workshop emphasizes practical ramifications of multidimensional modelling and implementations of those techniques using Microsoft technologies, mainly SQL Server 2014 and above.

Agenda:

Part 1 – Conceptual model

  • Data models
  • Data Warehouse architectures.
  • Binding business people with IT
  • Project governance

Part 2 – Logical model

  • Kimball methodology.
  • From basic to advanced modelling techniques

Part 3 – Physical model

  • Designing hardware for a data warehouse
  • Partitioning
  • Data compression
  • Indexing strategy

Part 4 – Data

  • Data movement
  • ETL best practices
  • Orchestration the ETL process
  • Data Quality
  • Metamodel