Detailed Course Outline
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
- Getting to know data models Starschema, Snowflag Schema, Full Historization and Data Vault models
- Modeling of dimension and facts
- Optimization concepts of large databases (partitioning, compression, indexing)
Building 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 a Customized Quality Assurance with Integration Services
Creation of DataMarts with Microsoft Analysis Services (Multidimensional and Tabular)
- Creation of Cubes
- Deployment of Cubes
- Updating Cubes
Overview of Reporting Tools
- Introduction to Power BI and Paginated Reports (SSRS)