Master Class: Building a Data Warehouse in SQL 2022

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)