{"course":{"productid":32868,"modality":1,"active":true,"language":"fr","title":"Master Class: Building a Data Warehouse in SQL 2022","productcode":"BDWSQL22MC","vendorcode":"MT","vendorname":"Master Class","fullproductcode":"MT-BDWSQL22MC","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/masterclass-bdwsql22mc","essentials":"<p>Basic knowledge in the following areas is desirable:<\/p>\n<ul>\n<li>Relational databases<\/li><li>Language TSQL<\/li><\/ul>","audience":"<p>The target group are developers and architects who are planning to set up a data warehouse system.<\/p>\n<p>You will gain an overview of the layers of a DWH system and finally learn how the various components interact.<\/p>","contents":"<h5>Overview of a data warehouse architecture<\/h5><ul>\n<li>Understanding the Layer Stage, Core Datawarehouse and DataMart<\/li><\/ul><h5>Basics of a data warehouse database<\/h5><ul>\n<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>\n<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>\n<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>\n<li>Creating cubes<\/li><li>Deployment von Cubes<\/li><li>Updating cubes<\/li><\/ul><h5>Overview of reporting tools<\/h5><ul>\n<li>Introduction to Power BI and Paginated Reports (SSRS)<\/li><\/ul>","summary":"<p>In this 5-day practical workshop, participants will learn how to set up a data warehouse solution with Microsoft SQL Server 2022 components.<\/p>\n<p>After an architectural overview and modeling approaches of a data warehouse system, you will design a data model, develop load paths with the ETL tool Integration Services and model a multidimensional cube with the Analysis Services. Finally, you will get to know Reporting Services and Power Bi as visualization tools.<\/p>\n<p>At the end of the course you will have independently developed the prototype of a data warehouse system.<\/p>","essentials_plain":"Basic knowledge in the following areas is desirable:\n\n\n- Relational databases\n- Language TSQL","audience_plain":"The target group are developers and architects who are planning to set up a data warehouse system.\n\nYou will gain an overview of the layers of a DWH system and finally learn how the various components interact.","contents_plain":"Overview of a data warehouse architecture\n\n\n- Understanding the Layer Stage, Core Datawarehouse and DataMart\nBasics of a data warehouse database\n\n\n- Special features of a data warehouse database\n- Familiarization with data models Starschema, Snowflag Schema, full historization and Data Vault models\n- Modeling of dimension and facts\n- Optimization concepts for large databases (partitioning, compression, indexing)\nSetting up a data warehouse load with Microsoft Integration Services\n\n\n- Introduction to Integration Services\n- Getting to know the SSIS transformation tasks\n- Parameterization and configuration of Integration Services packages\n- Deployment and operation of integration services\nImplementation of a quality assurance layer\n\n\n- Introduction of Data Quality Services\n- Implementation of customized quality assurance with integration services\nCreating DataMarts with Microsoft Analysis Services (Multidimensional and Tabular)\n\n\n- Creating cubes\n- Deployment von Cubes\n- Updating cubes\nOverview of reporting tools\n\n\n- Introduction to Power BI and Paginated Reports (SSRS)","summary_plain":"In this 5-day practical workshop, participants will learn how to set up a data warehouse solution with Microsoft SQL Server 2022 components.\n\nAfter an architectural overview and modeling approaches of a data warehouse system, you will design a data model, develop load paths with the ETL tool Integration Services and model a multidimensional cube with the Analysis Services. Finally, you will get to know Reporting Services and Power Bi as visualization tools.\n\nAt the end of the course you will have independently developed the prototype of a data warehouse system.","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":5,"formatted":"5 jours"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":4995},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":4990},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":4995},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":4995},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":4995},"NL":{"country":"NL","currency":"EUR","taxrate":21,"price":4995},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":4160}}},"lastchanged":"2026-01-13T18:33:01+01:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course-schedule\/32868","source_lang":"fr","source":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course\/masterclass-bdwsql22mc"}}