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.
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
- Data compression
- Indexing strategy
Part 4 – Data
- Data movement
- ETL best practices
- Orchestration the ETL process
- Data Quality