Opleiding: Master Class: Building a Data Warehouse in SQL 2022 (BDWSQL22MC)

In this 5-day practical workshop, participants will learn how to set up a data warehouse solution with Microsoft SQL Server 2022 components.

After an architectural overview and modeling approaches...

Overview of a data warehouse architecture


- Understanding the Layer Stage, Core Datawarehouse and DataMart
Basics of a data warehouse database


- Special features of a data warehouse database
- Familiarization with data models Starschema, Snowflag Schema, full historization and Data Vault models
- Modeling of dimension and facts
- Optimization concepts for large databases (partitioning, compression, indexing)
Setting up a data warehouse load with Microsoft Integration Services


- Introduction to Integration Services
- Getting to know the SSIS transformation tasks
- Parameterization and configuration of Integration Services packages
- Deployment and operation of integration services
Implementation of a quality assurance layer


- Introduction of Data Quality Services
- Implementation of customized quality assurance with integration services
Creating DataMarts with Microsoft Analysis Services (Multidimensional and Tabular)


- Creating cubes
- Deployment von Cubes
- Updating cubes
Overview of reporting tools


- Introduction to Power BI and Paginated Reports (SSRS)

The target group are developers and architects who are planning to set up a data warehouse system.

You will gain an overview of the layers of a DWH system and finally learn how the various components interact.