BDWSQL22MCMTMaster ClassMT-BDWSQL22MC1.0<p>Basic knowledge in the following areas is desirable:</p> <ul> <li>Relational databases</li><li>Language TSQL</li></ul><p>The target group are developers and architects who are planning to set up a data warehouse system.</p> <p>You will gain an overview of the layers of a DWH system and finally learn how the various components interact.</p><h5>Overview of a data warehouse architecture</h5><ul> <li>Understanding the Layer Stage, Core Datawarehouse and DataMart</li></ul><h5>Basics of a data warehouse database</h5><ul> <li>Special features of a data warehouse database</li><li>Familiarization with data models Starschema, Snowflag Schema, full historization and Data Vault models</li><li>Modeling of dimension and facts</li><li>Optimization concepts for large databases (partitioning, compression, indexing)</li></ul><h5>Setting up a data warehouse load with Microsoft Integration Services</h5><ul> <li>Introduction to Integration Services</li><li>Getting to know the SSIS transformation tasks</li><li>Parameterization and configuration of Integration Services packages</li><li>Deployment and operation of integration services</li></ul><h5>Implementation of a quality assurance layer</h5><ul> <li>Introduction of Data Quality Services</li><li>Implementation of customized quality assurance with integration services</li></ul><h5>Creating DataMarts with Microsoft Analysis Services (Multidimensional and Tabular)</h5><ul> <li>Creating cubes</li><li>Deployment von Cubes</li><li>Updating cubes</li></ul><h5>Overview of reporting tools</h5><ul> <li>Introduction to Power BI and Paginated Reports (SSRS)</li></ul>Basic knowledge in the following areas is desirable: - Relational databases - Language TSQLThe 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.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)5 jours4995.004990.004995.004995.004995.004995.004160.00